submit a 250 words paper on the topic Draw Entity Relation Database.

/in /by

Hi, need to submit a 250 words paper on the topic Draw Entity Relation Database. A) Given the following table, normalize to 3NF where PK=Primary Key and FK = Foreign Key. Hint: 2nd normal form problem

Part Number (PK)

Warehouse (PK)

Location

At 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 problem

Employee ID (PK)

Dept

Dept Location

At 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.