1. Consider the table below on employee details of a software company and answer the questions on the following page.
2.  

Employee Name	Address	Skills	Job Title	Hourly Rate
David Jones	160 Barmera Way Footscray	C++ Java DBA	Project Manager	150
George Smith	21 Little River Street Deer Park	Java AWS Cisco	Senior Developer	120
William Robinson	280 Kings Way Melbourne	Python DBA Matlab NS2	Manager	200
Anna Parker	5 David Circuit Footscray	C++ Javascript HTML	Junior developer	80
Tom	2 Spring Street, Docklands	CSS HTML VUE	Junior developer	80

1. 
   Which database's normal form is shown in the above table? Justify your answer.         (7 marks)
2. Draw its dependency diagram. Label all transitive and/or partial dependencies.       (7 marks)
3. Normalize the table to 3NF
4. Produce dependency diagrams that are in 3NF                                                   (8 marks)
5. Write the relational schema.
6. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, that the naming conventions are met, and so on.)             

Answer rating: 100% (QA)

1 Which databases normal form is shown in the above table Justify your answer The given table appears to be in the 1st Normal Form 1NF Each attribute ... View the full answer