Database Normalization

A engineering consultancy firm supplies temporary specialized staff to bigger companies in the country to work on their project for certain amount of time. The table below lists the time spent by each of the company’s employees at other companies to carry out projects. The National Insurance Number (NIN) is unique for every member of staff.

• Find the Fully Functional Dependencies on the PK and the Partial Dependencies on the PK.
• Normalise the table to 2NF 
• Find the transitive dependencies on the 2NF tables
• Normalise the tables to 3NF

Transcribed Image Text:

NIN Contract No Hours Company ID Employee Name Company Location 616681B 674315A 72 P. White SC115 Belfast SC1025 SC1025 Belfast Bangor Bangor 48 R. Press SC115 SC23 SC23 323113B SC1026 SC1026 24 24 P. Smith P. White 616681B NIN Contract No Hours Company ID Employee Name Company Location 616681B 674315A 72 P. White SC115 Belfast SC1025 SC1025 Belfast Bangor Bangor 48 R. Press SC115 SC23 SC23 323113B SC1026 SC1026 24 24 P. Smith P. White 616681B