University Database
Tables (5)
Course (course)
- Course Number (course_number) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR
- Description (description) — VARCHAR
- Semester Hours (semester_hours) — INT
- Level (level) — INT
- Offering Department (offering_department) — INT — Foreign key → Department.Department Code
Department (department)
- Department Code (department_code) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR — NOT NULL
- Office Number (office_number) — INT
- Office Phone (office_phone) — INT
- College (college) — VARCHAR
Grade Report (grade_report)
- Student Number (student_number) — INT — Foreign key → Student.Student Number — NOT NULL
- Section Number (section_number) — INT — Foreign key → Section.Section Number — NOT NULL
- Course Number (course_number) — INT — Foreign key → Section.Course Number — NOT NULL
- Letter Grade (letter_grade) — CHAR
- Numeric Grade (numeric_grade) — INT
Section (section)
- Section Number (section_number) — INT — Primary key — NOT NULL
- Course Number (course_number) — INT — Foreign key → Course.Course Number — NOT NULL
- Instructor (instructor) — VARCHAR
- Semester (semester) — CHAR
- Year (year) — INT
Student (student)
- Student Number (student_number) — INT — Primary key — NOT NULL
- Social Security Number (social_security_number) — INT — NOT NULL — DISTINCT
- First Name (first_name) — VARCHAR
- Last Name (last_name) — VARCHAR
- City (city) — VARCHAR
- State (state) — VARCHAR
- Permanent Address Zip (permanent_address_zip) — INT
- Current Phone (current_phone) — INT
- Permanent Phone (permanent_phone) — INT
- Birthdate (birthdate) — INT
- Sex (sex) — CHAR
- Class (class) — CHAR
- Major Department (department_code) — INT — Foreign key → Department.Department Code
- Minor Department (department_code2) — INT — Foreign key → Department.Department Code