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.