Lab #5 – Functional Dependency Anomalies

Due February 23^rd , 2006

To be done as a three person team

Name1 _____________________

Name2 _____________________

Name3 _____________________

Employee Computer Table

EMPID	ComputerID	EMPName	ComputerLocation	Computer Status
16	6	Smith	Bates	S2
16	4	Smith	Madison	S4
22	6	Jones	Bates	S2
22	11	Jones	Showker	S5
27	4	Prima	Madison	S4
29	26	Shipper	Duke	S7
29	4	Shipper	Madison	S4

I. Using the table of data provided above, show the functional dependencies of the data.

II. Discuss the insertion, deletion and modification (update) anomalies that are present in the data.

III. Modify the table as needed to eliminate anomalies dues to the functional dependencies and place the tables in BCNF (Boyce Codd Normal Form).

IV. Explicitly indicate any anomalies in the original table arising from multivalued dependencies

V. Modify the table to eliminate the multivalued dependencies (if any were found in IV).

VI.