You are required to create the following tables in a database named StudentNumber_DATA6212_ExamQ2: MODULES MODULE_CODE MODULE_NAME VENUES

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

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

The database can be created using the query below MYSQL is used to create the database a... View the full answer