CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 36
Note that this proposal may be revised in the coming weeks as your
understanding of the database modeling process grows.
Task 1
Develop a detailed logical model of your database based on your
business scenario submitted for Task 0. Your data model will include
an entity-relationship diagram (ERD) developed with Microsoft Visio
or MySQL and a data dictionary (DD) developed with Microsoft Excel.
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.