Question: Answer the following questions based on the table below: Faculty Studentid StudentName Faculty Courselds CourseNames Exam Grades Program College Name Assistants Dates 111 Mohammed 0103330
Answer the following questions based on the table below: Faculty Studentid StudentName Faculty Courselds CourseNames Exam Grades Program College Name Assistants Dates 111 Mohammed 0103330 SWD Dr. Sagib Mr. All 75 20 Nov 0103331 FormalSpec. Dram Mr. Ayman 80 SE Engineering 25 Nov. 222 khaled Khaled 0102221 OOP Dr. Issam Mr. Ahmed 65 18 Nov SE Engineering 010222 DLD Dr Fadi Mr. Abdalla 70 20 Nov (a) Explain database anomalies that appear in the above table with examples (3 marks) b) Normalize the above table up to 3NF (7 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
