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)