You have to normalize database tables to 3^rd Normal form for the data presented in the next page. Data for this assignment presents sales transaction details.

Deliverables include the following:

1.Dependency diagram of table after converting to 1NF indicating all the dependencies

2.Dependency diagram for each table after converting to 2NF indicating all the dependencies

3.Dependency diagrams of each table after converting to 3NF indicating all the dependencies

4.Create normalized fully attributed Entity Relationship diagram in MS Visio showing all the entities, their relationships, and cardinalities (Add additional attributes to each table as appropriate; Make sure not to end up de-normalizing the tables in the process).

5.Answer these specific questions:

a.How will you maintain historical accuracy of product price?

b.Did you identify any derived attribute and if yes then, how did you handle it?

Note: You need to upload to Moodle before the due date and time the following:

MS Word document showing items 1, 2, 3, and 5 above (You could use Word features such as Insert Table, and Insert Shapes tools to draw the dependency diagram A sample drawing is shown in page 3)

MS Visio file showing item 4 above

Note: This is an individual assignment. While it is okay to consult another student to clarify any doubt, any sharing of files and modifying computer files created by others and representing that work as ones own should be strictly avoided. Please refer to course policies in the syllabus on academic conduct and unauthorized collaboration.

Order ID	Sales Person ID	Sales Person Name	Customer ID	Customer Name	State	Product ID	Product Name	Unit Price	Qty.	Tax	Total
11011	3	Leverling	ALFKI	Alfreds Futterkiste	IL	58	Escargots de Bourgogne	$13.25	40	7.25%	568.43
						71	Fltemysost	$21.50	20	7.25%	461.18
10643	6	Suyama	ALFKI	Alfreds Futterkiste	IL	28	Rssle Sauerkraut	$45.60	15	7.25%	733.59
						39	Chartreuse verte	$18.00	21	7.25%	405.41
						46	Spegesild	$12.00	2	7.25%	25.74
						60	Camembert Pierrot	$34.00	3	7.25%	109.40
10692	4	Peacock	ALFKI	Alfreds Futterkiste	IL	63	Vegie-spread	$43.90	20	7.25%	941.66
						60	Camembert Pierrot	$34.00	5	7.25%	182.33
10952	1	Davolio	ALFKI	Alfreds Futterkiste	IL	6	Boysenberry Spread	$25.00	16	7.25%	429.00
						28	Rssle Sauerkraut	$45.60	2	7.25%	97.81
10625	3	Leverling	ANATR	Ana Trujillo Emparedados	MO	14	Tofu	$23.25	3	6.00%	73.94
						42	Hokkien Fried Mee	$14.00	5	6.00%	74.20
						60	Camembert Pierrot	$34.00	10	6.00%	360.40
10759	3	Leverling	ANATR	Ana Trujillo Emparedados	MO	32	Mascarpone Fabioli	$32.00	10	6.00%	339.20
10926	4	Peacock	ANATR	Ana Trujillo Emparedados	MO	11	Queso Cabrales	$21.00	2	6.00%	44.52
						13	Konbu	$6.00	10	6.00%	63.60
						19	Teatime Chocolate Biscuits	$9.20	7	6.00%	68.26
						72	Mozzarella di Giovanni	$34.80	10	6.00%	368.88
10308	7	King	ANATR	Ana Trujillo Emparedados	MO	69	Gudbrandsdalsost	$28.80	1	6.00%	30.53
						70	Outback Lager	$12.00	5	6.00%	63.60
10365	3	Leverling	ANTON	Antonio Moreno Taquera	IL	11	Queso Cabrales	$21.00	24	7.25%	540.54
10535	4	Peacock	ANTON	Antonio Moreno Taquera	IL	11	Queso Cabrales	$21.00	50	7.25%	1,126.13
						40	Boston Crab Meat	$18.40	10	7.25%	197.34
						57	Ravioli Angelo	$19.50	5	7.25%	104.57
						59	Raclette Courdavault	$55.00	15	7.25%	884.81
10573	7	King	ANTON	Antonio Moreno Taquera	IL	17	Alice Mutton	$39.00	18	7.25%	752.90
						34	Sasquatch Ale	$14.00	40	7.25%	600.60
						53	Perth Pasties	$32.80	25	7.25%	879.45