Create the Oracle database tables using SQL Data Definition Language (DDL) LECTURER PK Lecturer Number Lecturer Name

Create the Oracle database tables using SQL Data Definition Language (DDL)

 

Transcribed Image Text:

LECTURER PK Lecturer Number Lecturer Name Lecturer Grade FK1 Department_Code DEPARTMENT ---belongs to /has---H-PK Department Code Department Name WORK_LOAD has/is of PK,FK1 Subject Code PK,FK2 Lecturer Number Hours has/is of II SUBJECT PK Subject Code Subject Name Subject Category Each lecturer may teach one or many subjects and each subject is taught by one or many lecturers. Each department has one or many lecturers but each lecturer may not belong to more than one department. LECTURER PK Lecturer Number Lecturer Name Lecturer Grade FK1 Department_Code DEPARTMENT ---belongs to /has---H-PK Department Code Department Name WORK_LOAD has/is of PK,FK1 Subject Code PK,FK2 Lecturer Number Hours has/is of II SUBJECT PK Subject Code Subject Name Subject Category Each lecturer may teach one or many subjects and each subject is taught by one or many lecturers. Each department has one or many lecturers but each lecturer may not belong to more than one department.