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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!