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

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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