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.

Sample teams table


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.