The following table shows details of the students marks for their respective modules for the semester....

Transcribed Image Text:

The following table shows details of the students marks for their respective modules for the semester. Lecturer Department School of Engineering School of Engineering School of Engineering School of Engineering School of Design School of Design School of Design School of Design School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Design Student No S1056 $1059 $1100 S1308 $1059 $1056 $1100 $1308 $1100 $1056 $1059 S1308 S1308 $1059 $1056 $1100 i) ii) Student Name Modue Code John Ng Mary Chua Jack Chia iv) Bobby Ching Mary Chua John Ng Jack Chia Bobby Ching Jack Chia John Ng Mary Chua Bobby Ching Bobby Ching Mary Chua John Ng Jack Chia IT001 IT001 IT001 IT001 IT002 IT002 IT002 IT002 IT003 IT003 IT003 IT003 IT004 IT004 IT004 IT004 Module Name FCS FCS FCS FCS Please complete the following FOUR (4) parts: Database Systems Database Systems Database Systems Database Systems IDC IDC IDC IDC ICS ICS ICS ICS Grade HD D D D HD D C C P D D HD D P HD HD Table 1. Student Score Report Based on Table 1, write down the unnormalised form. Lecturer Name Robin Annie Chew Robin Annie Chew Jason Ong Jason Ong Jason Ong Jason Ong Robin Robin Annie Chew Annie Chew Robin Robin Robin Jason Ong (5 marks) Identify the repeating group of attributes and transform part (i) into tables that are in 1st Normal form. (Explain the rationale for your decision). (10 marks) Identify any partial dependencies in part (ii) and transform into tables that are in 2nd Normal Form. (Explain the rationale for your decision). (10 marks) Identify any transitive dependencies in part (iii) and transform into tables that are in 3rd Normal Form. (Explain the rationale for your decision). (Please clearly state all assumptions and ensure that you have sufficient annotations). (10 marks) The following table shows details of the students marks for their respective modules for the semester. Lecturer Department School of Engineering School of Engineering School of Engineering School of Engineering School of Design School of Design School of Design School of Design School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Engineering School of Design Student No S1056 $1059 $1100 S1308 $1059 $1056 $1100 $1308 $1100 $1056 $1059 S1308 S1308 $1059 $1056 $1100 i) ii) Student Name Modue Code John Ng Mary Chua Jack Chia iv) Bobby Ching Mary Chua John Ng Jack Chia Bobby Ching Jack Chia John Ng Mary Chua Bobby Ching Bobby Ching Mary Chua John Ng Jack Chia IT001 IT001 IT001 IT001 IT002 IT002 IT002 IT002 IT003 IT003 IT003 IT003 IT004 IT004 IT004 IT004 Module Name FCS FCS FCS FCS Please complete the following FOUR (4) parts: Database Systems Database Systems Database Systems Database Systems IDC IDC IDC IDC ICS ICS ICS ICS Grade HD D D D HD D C C P D D HD D P HD HD Table 1. Student Score Report Based on Table 1, write down the unnormalised form. Lecturer Name Robin Annie Chew Robin Annie Chew Jason Ong Jason Ong Jason Ong Jason Ong Robin Robin Annie Chew Annie Chew Robin Robin Robin Jason Ong (5 marks) Identify the repeating group of attributes and transform part (i) into tables that are in 1st Normal form. (Explain the rationale for your decision). (10 marks) Identify any partial dependencies in part (ii) and transform into tables that are in 2nd Normal Form. (Explain the rationale for your decision). (10 marks) Identify any transitive dependencies in part (iii) and transform into tables that are in 3rd Normal Form. (Explain the rationale for your decision). (Please clearly state all assumptions and ensure that you have sufficient annotations). (10 marks)

Answer rating: 100% (QA)

3 Achieving First Normal Form 1NF Each table has a clear and unique primary key Each column in the table contains atomic values indivisible Benefits o... View the full answer