Draw Entity Relation Database - Essay Example

A) Given the following table, normalize to 3NF where PK=Primary Key and FK = Foreign Key. Hint: 2nd normal form problemPart Number (PK)Warehouse (PK)LocationAt this point, the location attribute is dependent on the Warehouse (PK) only and not on Part Number (PK). It also means that a non-prime attribute is dependent partially on the key attribute, which would fall under the second normal form. After 2NF is normalization the relations would be as follows:Part Number (PK)Warehouse (PK)B) Given the following table, normalize to 3NF where PK=Primary Key and FK = Foreign Key.

Hint: transitivity problemEmployee ID (PK)DeptDept LocationAt this point, the Dept is dependent on Employee (PK) and Dept Location is dependent on Dept which arises a transitivity problem. It can be solved as follows.