Project+System

The system below is designed for managing staff who work on a variety of projects in a house building company. Each project has a unique ID and each employee is unique. Employees, however, can be allocated to more than one project. An employee’s salary depends on their grade.


 * Project System**






 * Employee Information**



The above data could be written in UNF as follows

__Project code__ Project description Project type Employee ID Employee name Employee grade Employee salary Date joined Months allocated

a) State why project code is a suitable primary key (1)

b) Take the system at UNF and convert it 3NF. At each stage indicate all primary and foreign keys (17)

c) Draw and entity relationship diagram for your solution at 3NF (6)