--D A D A S S I G N M E N T 2 -- --Modify this script so that it meets the requirements of Assignment 2 --When done, complete these tasks: --1. SAVE this file --2. EXECUTE this entire script in ISQL Jr --3. Copy and paste the OUTPUT generated by ISQL Jr into a file named ASS2_1234567_OUTPUT.TXT (where 1234567 is your student id) --4. ZIP this file with the ASS2_1234567_OUTPUT.TXT file and submit via ESP (see instructions on page 1 of the assignment) prompt START OF OUTPUT SECTION prompt Student ID: 1627503 prompt Student Name: Abbas Brooks prompt Tutor Name: Ankit Vyas prompt Tutorial Day: Thursday prompt Tutorial Time: 2:30-4:30 prompt Tutorial Room: ATC009 prompt -------------------------------------------------------------- prompt Task 1.2 DROP ALL TABLES -- DROP DATABBASE DAD prompt -------------------------------------------------------------- prompt Task 1.3 CREATE WORKER & TASK TABLES -- Create Table WORKER wrikid Number(4) tskid Number(4) prompt -------------------------------------------------------------- prompt Task 1.4 INSERT STATEMENTS TO POPULATE WORKER and TASK TABLES --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.5 CREATE ALLOCATION TABLE --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.6 INSERT STATEMENTS TO POPULATE LOCATION TABLE WITH VALID DATA --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.7 ALLOCATION / WORKER / TASK Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.8 PK Test (must fail) --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.9 Constraint Check Test (must fail) --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.10.1 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.10.2 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.10.3 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 1.10.4 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt SECTION 2 prompt -------------------------------------------------------------- --DO NOT ADD DROP STATEMENT HERE. PUT THEM IN SECTION 1.2 ABOVE prompt -------------------------------------------------------------- prompt Task 2.2 CREATE TIMELOG TABLE --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.3 INSERT STATEMENTS TO POPULATE TIMELOG TABLE WITH VALID DATA --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.4 PK and FK Test (Must Fail) --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.5 List data in TimeLog table --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.1 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.2 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.3 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.4 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.5 Query --XXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 2.6.6 Query --XXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt -------------------------------------------------------------- prompt SECTION 3 prompt -------------------------------------------------------------- --DO NOT ADD DROP STATEMENT HERE. PUT THEM IN SECTION 1.2 ABOVE prompt -------------------------------------------------------------- prompt Task 3.2 CREATE ADDITIONAL TABLES --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 3.3 INSERT STATEMENTS TO POPULATE ADDITIONAL TABLES WITH VALID DATA --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt -------------------------------------------------------------- prompt SECTION 4 prompt -------------------------------------------------------------- prompt Task 4.1 INSERT STATEMENTS TO TEST Check Constraints --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 4.2.1 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt -------------------------------------------------------------- prompt Task 4.2.1 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 4.2.2 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 4.2.3 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 4.2.4 Query --XXXXXXXXXXXXXXXX prompt -------------------------------------------------------------- prompt Task 4.2.5 Query --XXXXXXXXXXXXXXXX prompt --------------------------------------------------------------