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