Record Sructure
Diagram
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
** Please
Note: Primary keys are underlined and Foreign Keys are indicated by green text **
Student
(Student_ID,
First_Name, Last_Name, Date_of_Birth, Permanent_Code, Address, Street,
City, Province, Postal_Code, Phone_Number, Program )
Course
(Course_ID, Course_Name, Credits )
Enrolled
(Student_ID,
Course_ID, Grade, Semester )
Assignments
(Assign_ID,
Start_Date, Due_Date, Course_ID )
Course_Section
(Course_Section_ID,
Time, Couse_ID,
Professor_ID, Location_ID, Start_Time,
End_Time, Day )
Professor
(Professor_ID,
First_Name, Last_Name, Email, Office_Phone, Office_Number )
Location
(Location_ID, Floor,
Room, Campus )
|
|
