A software development company requires a database to record details about its projects. Each project has its own project number, name, project...

Grand Total

$49041.09

Note:     * indicates project leader.

This represents the data as un-normalised and redundancy exists throughout the table.

The following business rules apply:

·               The company manages many projects.

·               Each project requires the services of many employees.

·               An employee may be assigned to several different projects.

·               Each employee has a single primary job classification. This job classification determines the hourly billing rate.

·               Many employees can have the same job classification. For example, the company employs more than one database designer.

TASKS

1.             Using the provided spreadsheet data and business rules, you are to create a fully expanded ERD solution for the system.

2.             Convert the ERD solution from the previous question to a Relational Schema indicating all primary and foreign keys. Note: Where appropriate break attributes down further.

3.             Construct a data dictionary for each of the tables.

4.                           Implement your design in MySQL. All tables must enforce referential integrity where necessary. Record all MySQL commands.

5.                           Populate your tables with the data provided in the spreadsheet. Record all MySQL statements.