Given the following table:

1. Using the table above, list all functional dependencies.

2. Based on the functional dependencies in 1), transform the above table into in BCNF. (There will be ONLY TWO FINAL tables)

3. For each BCNF table, clearly state the following:

a) Primary keys

b) Candidate keys

c) Foreign keys

d) Composite keys

You have to state the name of the table and list the specific keys respectively. State none on each where not applicable as well.

4. In the original table above,

a) if we delete the items Antique Desk and Antique Candle Holders, describe what happens. What is the anomaly type?

b) if we want to ADD a NEW Purchase Price of $400.00, describe what is needed. What is the anomaly type?

c) if we change the Vendor name of Linens and Things to Things n Linen in only one row, describe what happens. What is the anomaly type?

5. In the original table above;

a). State ATLEAST TWO multivalued dependencies.

Purchaseltem Purchase Price Purchase Date vendor Phone Antique Desk 1,800.00 7-Nov-15 European Specialties 206-325-7866 1,750.00 7-Nov-15 European Specialties Antique Desk 206-325-7866 21o oo 7-Nov-15 European Specialties Antique Candle Holders 206-325-7866 7-Nov-15 European Specialties Antique Candle Holders 200.00 206-325-7866 600.00 14-Nov-15 Linens and Things 206-325-6755 Dining Table Linens Candles 30.00 14-Nov-15 Linens and Things 206-325-6755 Desk Lamp 14-Nov-15 Lamps and Lighting Floor Lamp 300.000 14-Nov-15 Lamps and Lighting 20e-325-e97 450.00 21-Nov-15 Linens and Things 206-325-6755 Dining Table Linens Candles 21-Nov-15 Linens and Things 206-325-6755 27.00 150.00 Book Shelf -15 Harrison, 425-746-4322 Denise 425-746-5433 28-Nov-15 Lee, Andrew Antique Desk 300.00 28-Nov-15 Lee. Andrew 425-746-5433 Antique Desk Chair 750.00 28-Nov-15 New York Brokerage 206-325-9088 Antique Chair 28-Nov-15 New York Brokerage Antique Chair