Page Break Part 4 Normalization (15 marks total] The tables below list student/subject, department number, and enrolment

[answerhappygod]

Page Break Part 4 Normalization 15 Marks Total The Tables Below List Student Subject Department Number And Enrolment 1 (48.04 KiB) Viewed 26 times

Page Break 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. SubjectNo SubjectName DepartmentNo 1122 1123 1124 1124 1199 1199 Database I Chemistry II Biology II Biology II Chemistry I Chemistry I D100 D88 D12 D12 D6 D6 StudentName J. Smith P. Ross J. Smith K. Lee J. Smith T. Khan Enrolment Date 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 SubjectNo 1122 1123 1124 1124 1199 1199 StudentNo u 100 u201 u100 u313 u 100 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] a (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.