this is my suggestion :All primary keys are not null,ID may include characters, you should set it to Varchar , instead of integer.year_of_joining should have domain YEAR, instead of CHAR(4).
Student Table:CREATE TABLE Student(StudentID INT PRIMARY KEY, Student_firstname CHAR(20), Student_lastname CHAR(20), Date_of_birth DATE, Major VARCHAR(10), Grade VARCHAR(5));Model Table:CREATE TABLE Module(ModuleID INT PRIMARY KEY, Module Name VARCHAR(50), Department CHAR(30));Professor Table:CREATE TABLE Professor(ProfessorID INT PRIMARY KEY, Professor_firstname CHAR(30), Professor_lastname CHAR(30), year_of_joining CHAR(4), Certificate CHAR(100));
- Kindly Correct The Below Tables As Below Suggestions This Is My Suggestion All Primary Keys Are Not Null Id May Inclu 1 (70.72 KiB) Viewed 54 times
Student Firstname StudentID Student Lastname Student Date of birth [1,"] Major Grade attend The examination office wants to build a database to manage the grades of students. For every student, studentID is unique. Besides, first name, last name, date of birth, major and the grade must be stored. 1 student can attend many modules but 1 module accommodate at most 70 students. Modules can be identified by the moduleID. Moreover, the module name, department, have to be managed. 1 module is taught by exactly 1 professor, 1 professor can take charge more than 1 module. The ID of professor is unique. other data of professor must be kept are first name, last name, year of joining and certificate. Professor D Professor Firstname ModuleID [1,70] ModuleName Module [1,1] teach [1,*] [1,70] Professor Professor Lastname Department Certificate Year of joining