Question: Question 3 a) State THREE (3) problems encountered if data is not stored in normalized tables? (4 marks) b) Describe THREE (3) main rules for

Question 3 a) State THREE (3) problems encountered if data is not stored in normalized tables? (4 marks) b) Describe THREE (3) main rules for normalization? (6 marks) Table 1 - Student_Course Tel Major Grade Title Stud Id 111 111 111 222 222 Stud Name Marina Marina Marina Anthony Anthony 1234 1234 1234 2345 2345 Bu Bu Bu IS IS Course Course Teacher Teacher Id Name Room EC2361 Bus Org Wong A1 EC2361 Econs Aziz A2 EC2361 Database Shoba B3 EC2310 Info Sys Allen EC2310 Database Shoba B3 B A B A B4 Normalize the following table to 3NF. (10 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
