代做Individual Project: The Company MySQL ERD and Database调试SQL 程序

日期：2024-03-12 11:25

Individual Project: The Company MySQL ERD and Database

There are several departments in the company. Each department has a unique identification,a name, location of the office and a particular employee who manages the department. A department controls a number of projects, each of which has a unique name, a unique number and a budget. Each employee has a name, identification number, address, salary and birthdate. An employee is assigned to one department but can join in several projects. We need to record the start date of the employee in each project. We also need to know the direct supervisor of each employee. We want to keep track of the dependents for each employee. Each dependent has a name, birthdate and relationship with the employee.

1.    An entity-relationship model (ERM) in the Third Normal Form. The model should  use the Crows Foot notation in the style employed, with all primary and foreign keys, relationship labels, and cardinality clearly indicated. Data definitions for all attributes are required. The ERM diagram will be in PNG or similar with a clear background. Data definitions, if not contained in the entities, will also be uploaded in a separate Word document.

2.   The MySQL Company Database. You will populate tables to provide examples of the data and how it might be queried.

The deliverables here will be:

a.    MySQL Company script file .sql.

b.   The Company EER. This is performed by Reverse Engineering the database once created.

Please upload all work to Canvas by March 10th.