C170 VHT1.docx C170 VHT1 A1A. TABLE IN FIRST NORMAL FORM Using the sales order form, I

C170 VHT1.docx  C170 VHT1  A1A. TABLE IN FIRST NORMAL FORM  Using the sales order form, I created a dataset from the given information.  I decided to use a composite primary key since both keys could uniquely identify the data for the table.  I ensured there were no repeating groups by splitting the address requirements into their own attributes.  A1B.  TABLE IN SECOND NORMAL FORM  Since I used a composite (multivalued) primary key in the first normal form, I knew I should look for dependencies on the keys.  To resolve the dependencies, I split the attributes into three separate tables.  Doing this resolved the dependency issues and created separate tables for Donut Order, Quantity, and Donut.  A1C. NORMALIZED TABLE IN THIRD NORMAL FORM  To ensure normalization to the third normal form, there should be no transitive dependencies so these needed to be removed.  This was solved by creating a Customer tabl