Question: Normalize the table below according to the First, Second and Third Normal Forms (1NF, 2NF and 3NF). At every level, before normalizing the table,

Normalize the table below according to the First, Second and Third Normal Forms (1NF, 2NF and 3NF). At every

Normalize the table below according to the First, Second and Third Normal Forms (1NF, 2NF and 3NF). At every level, before normalizing the table, state clearly why your current table has not been normalized according to the guidelines of that Normal Form. In stating your reasons, you are free to make mention the columns of the table which do not comply to guidelines of that level of normalization. (10) ITEM T-Shirt Polo T-Shirt Sweat Shirt COLOURS Red, Blue Red, Yellow Red, Blue Blue, Black PRICE 12.00 12.00 12.00 25.00 TAX 0.60 0.60 0.60 1.25

Step by Step Solution

3.45 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Anomalies in First Normal Form The COLOURS column contains multiple values separated by commas which creates repeating groups This violates 1NF where ... View full answer

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!