CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 37

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.
Also create a Word document that shows the structure of each table
and the data in each of your tables (copy and paste from MySQL).
Name this file yourname_tables.docx.
Note that your deliverables each week include any revisions to a
previous task.
Submit your Task 2 deliverable as a zip file including the following.
· Task 0 proposal (with any revisions)
· Your Task 1 ERD (with any revisions)
· Your Task 1 DD (with any revisions)
·
Your Task 2 script file to create and populate tables
(yourname_task2.txt)
·
A Word document showing all tables and data
(yourname_tables.docx)
Task 3
Your final task is to use your tables for an update and for reports.
There are two requirements.