You are required to create the following tables in a database named
StudentNumber_DATA6212_ExamQ2:

 

MODULES MODULE_CODE MODULE_NAME VENUES VENUE_CODE VENUE_NAME ADDRESS CITY VARCHAR(10) NOT NULL VARCHAR(50) NOT NULL ASSESSMENT_BOOKINGS VENUE_CODE VARCHAR(5) NOT NULL VARCHAR(50) NOT NULL VARCHAR(50) NOT NULL VARCHAR(50) NOT NULL MODULE_CODE VARCHAR(10) NOT NULL MARKS VARCHAR(5) NOT NULL ASSESSMENT DATE DATE NOT NULL START_TIME TIME NOT NULL DURATION SMALLINT NOT NULL SMALLINT NOT NULL PRIMARY KEY PRIMARY KEY PRIMARY KEY FOREIGN KEY REFERENCES MODULE(MODULE_CODE) PRIMARY KEY FOREIGN KEY REFERENCES VENUES(VENUE_CODE) PRIMARY KEY PRIMARY KEY