homework1_3
Tables (6)
Course (Untitled3)
- course number (Field3) — Primary key
- course name (Field)
- description (Field2)
- office phone (Field4)
- number of semester hours (Field5)
- level (Field6)
- offering department (Field7)
Grade report (Untitled5)
- STUDENT (Key) — Foreign key → STUDENT.Student Number — NOT NULL
- Section (Field32) — Foreign key → Section.course number
- letter grade (Field3)
- numeric grade (Field4)
Major Department (Untitled2)
- department code (Field2) — Primary key
- department name (Field) — Primary key
- office number (Field3)
- office phone (Field4)
- college (Field5)
Minor Department (CopyOfUntitled2)
- department code (Field2) — Primary key
- department name (Field) — Primary key
- office number (Field3)
- office phone (Field4)
- college (Field5)
STUDENT (Untitled)
- Student Number (Key) — Primary key — NOT NULL
- social security number (Field2) — Primary key
- Student name (Field)
- (current address and phone) (Field3)
- (permanent address and phone) (Field4)
- birthdate (Field5)
- sex (Field6)
- class (Field7)
- Major department (Field22) — Foreign key → Major Department.department code
- Minor department (Field8) — Foreign key → Minor Department.department name
- student’s last name (Field9)
- degree program (Field10)
Section (Untitled4)
- course number (Field3) — Foreign key → Course.course number
- instructor (Field)
- semester (Field2)
- section number (Field4)