Am I Properly Normalizing this Table

237 views Asked by At

The following problem comes from: https://cs.senecac.on.ca/~dbs201/pages/Normalization_Practice.htm (Exercise 3)

The unnormalized table appears like this:

UNF

To comply with First Normal Form, all repeating groups must be dealt with. In this case, multiple products could appear on a single order, so it must be given its own entity and related back to the original table:

1NF/2NF

These tables are also in Second Normal Form, because in all of the tables, each non-key attribute is dependent on the primary key in it's table.

Finally, to bring it to Third Normal Form, Customer must be given its own entity and related back to the original Order entity:

enter image description here

Have I properly normalized the original table into Third Normal Form? If not, please provide feedback explaining what I've done wrong.

1

There are 1 answers

0
mukesh lakum On

Store some Customer's Primary details in Order Table which are available on Bill, because once customer details is changed then Bill is differ then original.

Same for Product, Store Product price in Product_Order table, because once Product price changed Bill will change.