CSC 321, Instructor: Zhen Jiang Project 3 Normalization

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A+B---> C; A+B+D--->F; A---->E, G

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A+B---> C; A+B+D--->F; A----> E, G; E----> G

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A---> B, C, D, E, F, G; B-----> D,E; F-----> G

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A---> B, C, D, E, F, G; B+F----> D,E; F-----> G

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A+B---> C; A--> D,E; F-----> G; D---->E

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Given the follow table T( A,B,C,D,E,F,G)

Suppose we have the following dependencies: A+B---> C; A--> D,E; D---->E

a) What is the primary key?

b) Convert to set of tables in 2nd N.F.

c) Convert to set of tables in 3rd N.F.

Evaluation: Answer each question, provide the table, focus on each attribute and its position in tables, and DONOT forget to underline the key in each table! Submit your word file via D2L.