Normalization

• The following functional dependencies apply to a table with attributes A,B,C,D,E,F,G,H,I,J,K.
• For each problem, assume the primary key is the candidate key with the fewest number of attributes.
• You may assume the table is already in first normal form.
• For each set of functional dependencies, specify all the candidate keys, the prime attributes, the nonprime attributes, and the current normal form.
• If the table is NOT in third normal form, normalize it into a set of tables that satisfy third normal form. Specify the primary key and foreign keys for each table.
• Remember to include maximum cardinalities in your ERDs

1. AB,C,D,E,F,G,H,I,J,K B,CD,E FH
2. A,BC,D,E,F,G,H,I,J,K BD,E AF,G,H
3. AB,C,D,E,F,G,H,I,J,K B,C,DA,E,F,G,H,I,J,K F,GA,B,C,D,E,H,I,J,K
4. AB,C,D,E,F,G,H,I,J,K J,K D,E,F,G E,F,G D