Gallery Customer History Form

Customer Name

Jackson, Elizabeth Phone (206) 284-6783

123 4^th Avenue

Seattle, WA

98122

Purchases Made

Artist Title Purchase Date Sales Price

03 - Carol Channing Laugh with Teeth 09/17/2000 7000.00

15 - Dennis Frings South toward Emerald Sea 05/11/2000 1800.00

03 - Carol Channing At the Movies 02/14/2002 5550.00

15 - Dennis Frings South toward Emerald Sea 07/15/2003 2200.00

The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer.

Normalize this table to:

UNF:

1NF:

2NF:

3NF:

Department	Product Code	Aisle Number	Price	Unit of Measure
Produce	4081	1	0.35	lb
Produce	4027	1	0.90	ea
Produce	4108	1	1.99	lb
Butcher	331100	5	1.50	lb
Butcher	331105	5	2.40	lb
Butcher	332110	5	5.00	lb
Freezer	411100	6	1.00	ea
Freezer	521101	6	1.00	ea
Freezer	866503	6	5.00	ea
Freezer	866504	6	5.00	ea

This report is used by the department managers to update the prices that are displayed in the grocery store for these products.

Please Normalize those two exercises to:

UNF:

1NF:

2NF:

3NF:

Please be Accurate and efficient at Database. This is Database.