Lab 9: Normalization Three Slution

To further develop your facility with the art and science of normalization.
You have been captured by the Star Helix Security and tasked with designing a database
for the Belters Little League Sports Alliance on Ceres Station. Here are some facts:

The league consists of many teams spread over three age groups.

The three age groups are as follows: under 10, 10 through 14, over 14

Each team plays in exactly one age group.

A team consists of many players, one or more assistant coaches, and one head coach.

We have Pirst and last names, addresses, and phone numbers for all players and

For all coaches we need know the number of years they have been coaching.

A player can play on only one team.

A coach can coach several teams as long as each team is in a different age group.
1. Identify and document all functional dependencies.
2. Draw a fully annotated E/R diagram that illustrates the Platonic ideal of beautiful and
correct relational database design.
3. Convince me that your database is in 3NF (or even better, in Boyce-Codd Normal

Chapters 3 and 4.1 and 4.6 in our text, especially 4.1.11 and 4.6

Stack OverPlow -

Microsoft on Normalization -
Powered by