SQL

hese videos give a step by step direction. I also included a sample project of what it should look like (but it might not be fully correct, however, the comments from the mentor align with that sample project and mine doesn't)

Videos to follow:

https://drive.google.com/file/d/0B7GdJJx7i3PEQnd1b...

https://drive.google.com/file/d/0B7GdJJx7i3PEOXBDW...

Comments from mentor:

I have a couple suggestions.

· On your 1NF, you miss some attributes found on the Donut Shop Order/Receipt, e.g. Phone number etc. Also, “DonutID” needs to be a PK, as an order can have different types of Donut.

· On your 2NF, your “Order Table” should have both OrderID/DonutID has both (PK,FK). This is per normalization process. You will need to adjust the PK, in the other two tables accordingly.

· On your 3NF, you need to make the same adjustment on the “Doti Table” and the other tables as in the case of 2NF.