- Question No 04 The Following Table Show A Table Called Student Report For A University Decompose The Student Report In 1 (124.49 KiB) Viewed 43 times
Question No 04: The Following table show a table called STUDENT REPORT for a university. Decompose the student report into a set of 3NF relations. [C2, CLO-3, PLO-3] 1680458 1680458 STUDENT REPORT StudentID Student Major CourseID Name Muzaffar TE 5431073 5431073 a) The table shown in Figure is susceptible to update anomalies. Provide examples of insertion, deletion and update anomalies. 5431073 b) Identify the functional dependencies represented by the attributes shown in the table of the figure. State any assumptions you make about the data and the attributes shown in this table. c) Describe and illustrate the process of normalizing the table shown in Figure to 3NF. Identify primary, alternate and foreign keys in your relations. Shahzad SE Saim Sameer Hamza EE CIV ME TE350 SE465 EE350 CIV201 ME300 CourseTitle Signals System Database Systems Electric Machines Instructor Name Codd Machine Design Parsons Codd Construction Miller Management Bennett Instructor Location B104 B317 B104 H310 B212 Question No 04 (Part B): [C2, CLO-3, PLO-3] Describe and illustrate the process of normalizing the tables to Boyce-Codd Normal Form (BCNF). Sample relations Enrollment (StudentID, courselD, course_Instructor, Student_Name, Student Degree, Student ADD, course_Name, Instructor_Name, Instructor_Office, Grade) StudentSupervisor (StudentID*, specialization, supervisor) Grade A A B C B