FIT9132 Introduction To Databases

STEP 1

RUN ALL COMMANDS IN THIS FILE >> FIT9132_2018S1_A2_Schema_Start.sql

STEP 2

RUN ALL COMMANDS IN THIS FILE >> FIT9132_2018S1_A2_Insert_Start_v1.1.sql

STEP 3

RUN ALL COMMANDS IN THIS FILE >> START FROM:

 TASK Task 2.1 >> Task 2.2 >> Task 3.1 >> Task 3.2 >> Task 3.3 >> Task 4.1 >> Task 4.2 >> YOUR DONE

NB: I SKIP TASK 1.1 BECAUSE THOSE COMMANDS HAVE ADDED IN THE FILE(Toward the end of file) >> FIT9132_2018S1_A2_Schema_Start.sql

NB: I SKIP TASK 1.2 TO AVOID DROPPING ALL THE CREATED TABLES

NB: I SKIP TASK 2.3 TO AVOID SEQUENCE MANAGER WHICH SHALL BE NEEDED.

STEP 4 [NOTE] 

IF YOU MISS ANY STEP DROP ALL THE TABLES AND START AGAIN

USE THIS TO DROP ALL THE TABLES

DROP TABLE ENTRY;

DROP TABLE COMPETITOR;

DROP TABLE EMERCONTACT;

DROP TABLE GUARDIAN;

DROP TABLE TEAM;

DROP TABLE TEAMMEMBER;

DROP TABLE CHARITY;

DROP TABLE EVENT;

DROP TABLE EVENTTYPE;

DROP TABLE CARNIVAL;

DROP SEQUENCE COMPETITOR_SEQUENCE; 

COMMIT;