- Part 4 Normalization 15 Marks Total The Tables Below List Student Subject Department Number And Enrolment Data Each 1 (177.15 KiB) Viewed 45 times
Part 4 Normalization (15 marks total] The tables below list student/subject, department number, and enrolment data. Each student may enroll in many subjects from various departments in a university. Subjects are offered by different departments. Subjects 0 1122 1123 1124 1124 1199 1199 Subject Name DepartmentN 0 Database 1 D100 Chemistry II D88 Biology 11 D12 Biology II D12 Chemistry I D6 Chemistry 1 D6 Student Name J. Smith P. Ross J. Smith K. Lee J. Smith T. Khan EnrolmentDate 14/2/2016 17/2/2011 16/2/2016 14/1/2013 20/1/2016 20/1/2010 Enrolment fee $1200 $1200 $1100 $1100 $1000 $1000 Subject No 1122 1123 1124 1124 1199 1199 StudentNo u100 u201 u100 u313 u100 u295 (a) The data in the above table is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur in the above tables. (5 marks] (b) Design a database to store the data from the above table. Your designed database must be in the third normal form (3NF). Draw the E-R diagram of your model in 3NF. [10 marks)