(Use BCNF procedure (3-steps) to normalize the table given below)

Normalize the table R up to BCNF. Clearly show your steps and state all Primary and Foreign keys.

R ( TeamId, TeamName, TeamCoach, PlayerId, PlayerName, Year, Score)

Functional Dependencies:

1. TeamId TeamName, TeamCoach

2. PlayerId PlayerName

3. PlayerId, Year TeamId, Score