Look at each example below and indicate which normal form is violated and why it is violated and then rewrite the attribute list to correct it. Primary keys in the examples are underlined. Be sure to underline any primary key(s) and italicize any foreign keys.

1)

Normal Form Violated in the table above: ________________

SOLUTION:

2)

Normal Form Violated in the table above: ______________

SOLUTION:

3)

Normal Form Violated in the table above: __________________

SOLUTION:

4)

Normal Form Violated in the table above: _______________

SOLUTION:

5)

Normal Form Violated in the table above: __________________________

SOLUTION:

Part B

Consider the following fields: (listed in alpha order)

LeagueID, LeagueName, ManagerLName, ManagerFName, PlayerID, PlayerLName, PlayerFName, Schedule, SportID, SportName, Stats, TeamID, TeamName

Consider the following statements:

Players are part of a team

A team plays a certain sport and is part of a league

1) Put the above named fields into 4^th Normal Form using the following steps:

a. Show all functional dependencies

b. Identify every candidate key

c. To make things easier, convert each of the above into a Sentence Structure

Put each into 4NF breaking out any fields, if needed. Be sure to underline the primary key field of each relation and indicate the foreign key if any

SPORT MANAGER Primary Key (SportID, ManagerID) Sport Basketball Golf Football Cross Country SportID ManagerlD 102 106 103 105 GF FB SPORT MANAGER Primary Key (SportID, ManagerID) Sport Basketball Golf Football Cross Country SportID ManagerlD 102 106 103 105 GF FB