Use Database Design Language (DBDL) to create the normalized tables and fields necessary to complete the Soccer Database. Be sure to note all keys.

Use the DBDL you created to implement (create) the database in SQL Server 2012.

All tables must be in at least 3NF, all keys must be noted properly and the relationships should be correct.

 

One of your friends has volunteered to run a soccer League this fall. He/she asked you if you had any suggestions on how they could keep track of the Players, Referees, Scores, and Sponsors of each Match. You told them that it just so happens that you are taking a Database Design class this semester and you would LOVE to help out and design a database for the league. The League wants to keep track of the following information: Location of the Match Date Played Referee Name Referee Phone Referee Address Team Name Sponsor Name - one sponsor per team Total Score of the Match for each team Players Name Players Points Scored in each Match Player Penalties each Match Design the tables needed for this database. Every table should be in 3NF. Using DBDL, create the normalized tables (3NF) and relationships between the tables that are needed for this project. Note: A player can play for more than one team (substitute) but only one team during a given match.