DATABASE

Please answer all questions

QUESTION 5 a) Briefly explain about partial and transitive dependencies. (2 marks) b) Based on the following dependency diagram, identify the partial dependency, transitive dependency and full functional dependency. A1 A2 A3 A4 A5 A6 A7 (4 marks) c) Questioni, il and il are based on the following table. SubjName Emp No 1212 Emp Name Umar Hashi m Emp Post Lecturer Unit Code CSC Unit Name Computer Science Subj Code CSC131 Credit Hour 4 Room No B04 Computer Concept CSC122 ITT330 4 4 B11 Lab12 2323 ENG Engineering Zaleha Senior Ibrahim Lecturer ENG312 4 Lab09 Problem Solving Operating System Heat and Mass Transfer Introduction to Electrical Engineering Writing Skill ENG111 4 C06 ELC112 on B05 1516 Aishah Professor ELC English Borhan 2356 Samad Assoc STA Statistics Abdul Prof Note: Emp means Employee, Subj means Subject STA244 Probability 4 B09 9 CONFIDENTIAL CS/FEB 2021/1CT200/TS232 i. What normal form is the table in? Please give your reasons. (3 marks) ii. What will be the primary key for the above table? (2 marks) ii. Normalize the table into 3NF. Show all steps on how you arrive at your answer. (7 marks)