Writers Den

Objective:Normalize table to third normal form (3NF)

Submission requirements:

·
For all text and image
submissions, use MS Word.

·
For all SQL code submissions,
use MS Word.

·
For all diagrams submissions,
use MS Visio.

·
If the submission is more than
one file:

1.
Name each item appropriately.

a. For example:
LAB3-Normalization-yourName.vsd, LAB3-Questions-yourName.docx

2. Save each item in a single
folder.

3. This folder should also be
named appropriately.

a. For example: LAB3-yourName

4. Compress the folder.

5. Submit the compressed file in
Blackboard.

Lab:For this assignment, you will
normalize the below Orders table to 3NF. Make sure to identify all
the entities and their attributes, especially if you make any new items (such
as entity or attributes). The following is a list of possible attributes for
ORDERS; you may have more:

ORDERS

OrderNo

CustomerNo

CustomerName

CustomerAddress

CustomerCity

CustomerState

CustomerZip

OrderDate

ItemsOrdered

Total

Submit dependency diagrams for
all entities you create. The following table is a sample of data, before ORDERS
was normalized. Please start with the below table and then write out each
dependency diagram as you move from 1NF to 2NF to 3NF. Show your progress and
submit your final document with all dependency diagrams in Blackboard.

The following table is a sample, before ORDERS was
normalized:

ORDER NO	ORDER DATE	CUSTOMER NO	CUSTOMER NAME	CUSTOMER ADDRESS	ITEMS ORDERED
100	1/1/99	54545	ACME Co	1234 1stSt.	1A4536, Flange, 7lbs, $75;4-OR2400, Injector, .5lbs, $108;4-OR2403, Injector, .5lbs, $116;1-4I5436, Head, 63lbs, $750
101	1/1/99	12000	Sneed Corp.	555 Main Ave.	1-3X9567, Pump, 5lbs, $62.50
102	1/1/99	66651	ZZZ & Co.	4242 SW 2nd	7-8G9200; Fan, 3lbs, $84;1-8G5437, Fan, 3lbs, $15;1-3H6250, Control, 5lbs, $32
103	1/2/99	54545	ACME Co	1234 1stSt.	40-8G9200, Fan, 3lbs, $480;1-2P5523, Housing, 1lb, $165;1-3X9567, Pump, 5lbs, $42