CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 35

Note that your deliverables each week include any revisions to the
previous task.
Submit your Task 1 deliverable as a zip file including the following.
·
Task 0 proposal (with any revisions or updates)
·
Your ERD copied to a Word document that fits on a single 8 x
10 page
·
Your DD (Excel file)
Task 2
First, make sure to make any necessary revisions to your logical
model based on Task 1 feedback. Using MySQL, write the
statements to develop a physical model of your database by creating
the tables and constraints based on your Task 1 logical model. Be
sure to use your ERD and data dictionary and create all constraints
appropriately.
Once your tables are created, you will populate them with data
using MySQL statements to insert records into the database. You
should insert a minimum of five records into each table and more
where necessary to ensure that the data in the database is sufficient
to allow for each of your reports to be tested.
The result will be a script file that includes statements to
· DROP all tables;
· CREATE all tables with constraints;
· INSERT data into all tables; and
· SELECT data from all tables to show the data in each table.
Name this file yourname_task2.txt.