Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Ensure that you create the database and table objects exactly as depicted below. STUDENTS STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY STUDENT_NAME VARCHAR(40) NOT NULL STUDENT_SURNAME VARCHAR(40) NOT NULL MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY MODULE_NAME VARCHAR(40) NOT NULL

Ensure that you create the database and table objects exactly as depicted below. STUDENTS STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY STUDENT_NAME VARCHAR(40) NOT NULL STUDENT_SURNAME VARCHAR(40) NOT NULL MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY MODULE_NAME VARCHAR(40) NOT NULL

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 65P
See similar textbooks
icon
Related questions
Question
You are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the database and table objects exactly as depicted below. STUDENTS STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY STUDENT_NAME VARCHAR(40) NOT NULL STUDENT_SURNAME VARCHAR(40) NOT NULL MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY MODULE_NAME VARCHAR(40) NOT NULL MODULE_CREDIT SMALLINT NOT NULL STUDENT_MODULES STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES STUDENTS(STUDENT_ID) MODULE ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURERS LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY LECTURER_NAME VARCHAR(40) NOT NULL LECTURER_SURNAME VARCHAR(40) NOT NULL O The Independent Institute of Education (Pty) Ltd 2021 Page 3 of 10 19, 20; 21 2021 LECTURER_MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES LECTURERS(LECTURER_ID)
Transcribed Image Text:You are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the database and table objects exactly as depicted below. STUDENTS STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY STUDENT_NAME VARCHAR(40) NOT NULL STUDENT_SURNAME VARCHAR(40) NOT NULL MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY MODULE_NAME VARCHAR(40) NOT NULL MODULE_CREDIT SMALLINT NOT NULL STUDENT_MODULES STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES STUDENTS(STUDENT_ID) MODULE ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURERS LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY LECTURER_NAME VARCHAR(40) NOT NULL LECTURER_SURNAME VARCHAR(40) NOT NULL O The Independent Institute of Education (Pty) Ltd 2021 Page 3 of 10 19, 20; 21 2021 LECTURER_MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES LECTURERS(LECTURER_ID)
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer