Question 2
Please complete the following FOUR (4) parts:
i) Based on Figure 1, write down the unnormalised form.
ii) Identify the repeating group of attributes and transform part (i) into tables that are in 1 st Normal form. (Explain the rationale for your decision). (10 marks)
iii) Identify any partial dependencies in part (ii) and transform into tables that are in 2 nd Normal Form. (Explain the rationale for your decision). (10 marks)
iv) Identify any transitive dependencies in part (iii) and transform into tables that are in 3 rd Normal Form. (Explain the rationale for your decision). (10 marks)
(Please clearly state all assumptions and ensure that you have sufficient annotations).
Stuck with a lot of homework assignments and feeling stressed ?
Take professional academic assistance & Get 100% Plagiarism free papers
The post Identify the repeating group of attributes and transform part (i) into tables that are in 1 st: Introduction to Database, Design and Development Assignment, SMU appeared first on Singapore Assignment Help.
Need help with your own assignment?
Our expert writers can help you apply everything you've just read — to your actual assignment.
Get Expert Help Now →