HW1_P3
Tables (6)
Course
- Course_name (Course_number) — string — Primary key — NOT NULL
- Name — string — Foreign key → Department.Name — NOT NULL
- Department_code — string — Foreign key → Department.Department_code — NOT NULL
- Course_number (Course_name) — string
- Credit_hours — int
- Field (Level) — string
- Field (Offering_department) — string
Department
- Name — string — Primary key — NOT NULL
- Department_code — string — Primary key — NOT NULL
- Office_number — string
- Office_phone — string
- College_name — string
Untitled (Student)
- Key (Student_number) — string — Primary key — NOT NULL
- Name — string — Foreign key → Department.Name — NOT NULL
- Department_code — string — Foreign key → Department.Department_code — NOT NULL
- Field2 (SSN) — string
- Field3 (Current_address) — string
- Field4 (Current_phone) — string
- Field5 (Permanent_address) — string
- Field (Permanent_phone) — string
- Field2 (Birthdate) — date
- Field3 (Gender) — string
- Field4 (Grade) — string
- Field (Major) — string
- Field2 (Minor) — string
- Field3 (Degree_program) — string
Untitled (Enrolls)
- Course_name (Course_number) — string — Foreign key → Untitled.Course_name — NOT NULL
- Name — string — Foreign key → Untitled.Name — NOT NULL
- Department_code — string — Foreign key → Untitled.Department_code — NOT NULL
- Key (Student_number2) — string — Foreign key → Untitled.Key — NOT NULL
- Name (Name2) — string — Foreign key → Untitled.Name — NOT NULL
- Department_code (Department_code2) — string — Foreign key → Untitled.Department_code — NOT NULL
- Field (Student_number) — string
- Field2 (Section_identifier) — int
Untitled (Grade_Report)
- Course_name (Course_number2) — string — Foreign key → Untitled.Course_name — NOT NULL
- Name — string — Foreign key → Untitled.Name — NOT NULL
- Department_code — string — Foreign key → Untitled.Department_code — NOT NULL
- Key (Student_number) — string — Foreign key → Untitled.Key — NOT NULL
- Name (Name2) — string — Foreign key → Untitled.Name — NOT NULL
- Department_code (Department_code2) — string — Foreign key → Untitled.Department_code — NOT NULL
- Field (Stuent_number) — string
- Field2 (Section_indentifier) — int
- Field3 (Letter_grade) — string
- Field4 (Numeric_grade) — int
Untitled (Section)
- Course_name (Course_number) — string — Foreign key → Course.Course_name — NOT NULL
- Name — string — Foreign key → Course.Name — NOT NULL
- Department_code — string — Foreign key → Course.Department_code — NOT NULL
- Field (Instructor) — string
- Field2 (Semester) — string
- Field3 (Year) — int