Research Staff(First
Name, Last Name, Relation, e-mail,
Dept
Code, Course Code)
primary key (First Name, Last Name), foreign key (Dept Code) references Department, foreign key (Course Code) references Course, foreign key (First Name, Last Name) references Anag, School Member(First
Name, Last Name, Faculty, Year)
Department(Dept Name, Dept
Code, Budget, Dept Area)
Course(Course
Name, Course Code, Length, Room Code)
Room(Room Code,
Seats Number, Notes)
Anag(First Name,
Last Name, Address, City, e-mail)
|
|
|
|
|