homework1-3_final

Tables (6)

Major_department (CopyOfUntitled3)

  • department_name (Field) — VARCHAR(20) — Primary key
  • department_code (Field2) — BIGINT — Primary key
  • office_number (Field3) — BIGINT
  • office phone (Field4) — VARCHAR(20)
  • college (Field5) — VARCHAR(30)

STUDENT (Untitled)

  • student_number (Field2) — BIGINT — Primary key
  • social security number (Field3) — BIGINT — Primary key
  • current address and phone (Field4) — VARCHAR(30)
  • permanent address and phone (Field5) — VARCHAR(30)
  • birthdate (Field6) — VARCHAR(20)
  • sex (Field7) — VARCHAR(10)
  • class (Field8) — VARCHAR(20)
  • degree program (Field11) — VARCHAR(20)
  • student_name (Field) — VARCHAR(30)
  • Major_department (Field12) — composite — Foreign key → Major_department.department_name
  • Minor_department (Field13) — composite — Foreign key → minor_department.department_name

course (Untitled4)

  • course number (Field3) — BIGINT — Primary key
  • course name (Field) — VARCHAR(20)
  • description (Field2) — VARCHAR(100)
  • number of semester hours (Field4) — int
  • level (Field5) — int
  • offering department (Field6) — VARCHAR(20)

grade report (Untitled6)

  • STUDENT (Field33) — BIGINT — Foreign key → STUDENT.social security number
  • letter_grade (Field3) — VARCHAR(10)
  • numeric _grade (Field4) — int
  • student (Field2) — composite
  • section (Field32) — BIGNT — Foreign key → section.course

minor_department (Untitled3)

  • department_name (Field) — VARCHAR(20) — Primary key
  • department_code (Field2) — BIGINT — Primary key
  • office_number (Field3) — BIGINT
  • office phone (Field4) — VARCHAR(20)
  • college (Field5) — VARCHAR(30)

section (Untitled5)

  • course (Field32) — BIGNT — Foreign key → course.course number
  • instructor (Field) — VARCHAR(20)
  • semester (Field2) — VARCHAR(20)
  • year (Field3) — int
  • section_number (Field5) — int