Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started