Consider the following table which is used to store records of students and course information. UFID...

 

Transcribed Image Text:

Consider the following table which is used to store records of students and course information. UFID StudentName Major CourseID CourseName InstructorID Instructor Grade COP01 cisel James COP02 cise2 Andrew COP03 cise3 Peter PH01 physics1 Alan PH02 physics2 Alan 4114123 3124234 John Roger CISE Physics I01 102 103 104 104 A A B B B (a) Explain if it is the first normal form. If not, explain the reason and normalize the table into the first normal form (1NF). (b) Explain the criteria for the second normal form (2NF) informally and normalize the table you obtained from the previous part to meet them. Then explain which anomalies (at least two) still can occur in your answer. (c) Explain the criteria for the third normal form (3NF) informally and normalize the table you obtained for the previous question to meet them. (d) Explain if the tables you obtained for the previous question are in BCNF and, if not, normalize them to BCNF. Consider the following table which is used to store records of students and course information. UFID StudentName Major CourseID CourseName InstructorID Instructor Grade COP01 cisel James COP02 cise2 Andrew COP03 cise3 Peter PH01 physics1 Alan PH02 physics2 Alan 4114123 3124234 John Roger CISE Physics I01 102 103 104 104 A A B B B (a) Explain if it is the first normal form. If not, explain the reason and normalize the table into the first normal form (1NF). (b) Explain the criteria for the second normal form (2NF) informally and normalize the table you obtained from the previous part to meet them. Then explain which anomalies (at least two) still can occur in your answer. (c) Explain the criteria for the third normal form (3NF) informally and normalize the table you obtained for the previous question to meet them. (d) Explain if the tables you obtained for the previous question are in BCNF and, if not, normalize them to BCNF.

Answer rating: 100% (QA)

a The table is not in the first normal form 1NF because it has repeating groups For example the StudentName and Major columns are repeated for each co... View the full answer