Database: Relational Schema Exercise - Teams

Name _______________________________________

Here is a section of a table that contains information about players and teams. However, the table is unnormalized, ie, it has redundant data, which has lead to some anomalies.

Assumptions

• Each player is only on one team.
• Each team has only one sponsor.

Draw the Schema

How would you improve this database by making it into a relational database with more than one table? Draw a relational schema showing the appropriate tables, attributes, keys, and relationships.