QUESTION 6 (20 Marks) 6.1 Define the concept of normalisation and discuss the objective of normalising tables in a datab

[answerhappygod]

Question 6 20 Marks 6 1 Define The Concept Of Normalisation And Discuss The Objective Of Normalising Tables In A Datab 1 (70.94 KiB) Viewed 44 times

QUESTION 6 (20 Marks) 6.1 Define the concept of normalisation and discuss the objective of normalising tables in a database. (10 marks) 6.2 Suppose a school wants to store the data of teachers and the subjects they teach. They create a table that looks like this: Since a teacher can teach more than one subject, the table can have multiple rows for a same teacher. The table below is already in First Normal Form (1NF). Convert the table into Second Normal Form (2NF). (10 marks) teacher_id subject teacher_age 111 Maths 38 1111 Physics 38 222 Biology 38 333 Physics 140 333 Chemistry 140