Question: Normalization is a method for organizing data elements in a database into tables. Normalization has a number of processes. For the purposes of this
Normalization is a method for organizing data elements in a database into tables. Normalization has a number of processes. For the purposes of this assignment, data will be normalized up to the third normal form. After the first stage, the data is said to be in the 1st normal form, after the second, the 2nd normal form, and after the third, the 3rd normal form. The fields in the original un-normalized data table are as follows: Sales OrderNo, Date, CustomerNo, CustomerName, CustomerAddress, ClerkNo, ClerkName, ItemNo, Description, Qty, UnitPrice Requirements: Normalize the data up through third normal form, one normalization step at a time. All of this assignment must be typed out in Microsoft Word. Put all table names in bold print and underline all primary and foreign keys. Identify each primary key with a (PK) notation and all foreign keys with a (FK) notation in each table. 1. 2. 3. 4.
Step by Step Solution
3.38 Rating (148 Votes )
There are 3 Steps involved in it
Detailed Explanation In this question I can assist you in standardizing the above data into the thir... View full answer
Get step-by-step solutions from verified subject matter experts
