In Class Practice: Create Table Assignment: Football Commision
- Due Nov 2, 2017 by 11:59pm
- Points 100
- Submitting a text entry box or a file upload
- Available Oct 9, 2017 at 12am - Nov 3, 2017 at 11:59pm
During class, we will use the Relational Schema and the Data Dictionary / Meta Data in the files below as a guide to create a series of create table statements. The data dictionary describes a database that manages information for a fictional little league football team. Make sure that you place the create table statements in the proper order to ensure you do not get referential integrity errors while executing the create table script. At the end of the script, place a drop database command to remove the database and tables from the database
Data_Dictionary for Football Commissioner-1.pdf Download Data_Dictionary for Football Commissioner-1.pdf
When the assignment is completed, upload the SQL text file
Extra Credit
In class, we created four tables. We created the Coach, Player, Team and Plays Table. There are potentially, 6 or 7 tables in the in original design that we constructed in the In Class Practice Design that we did for the Little League Football Database. For Extra Credit, write the remaining CREATE TABLE Statements for the Home Field, Game and possibly the Scheduled Tables.
There is an EXTRA 100 Points for doing the Extra Credit portion of the assignment.
Find Rubric