sd

Tables (3)

Buildings (Untitled)

  • Building Number (Key) — Int — Primary key — NOT NULL
  • Number of Floors (Field) — Int
  • Elevator Access (Field2) — Bool
  • Site Parking Available (Field3)

Classes (Untitled2)

  • Class ID (Key) — Primary key — NOT NULL
  • Building Number (Key2) — Int — Foreign key → Buildings.Building Number — NOT NULL
  • Instructor ID (Field)
  • Class Name (Field2)
  • Class Description (Field3)
  • Class Category (Field4)
  • Credits (Field5)
  • Classroom (Field6)
  • Field7

Staff (Untitled3)

  • Staff ID (Key) — Primary key — NOT NULL
  • Staff ID (Key2) — Foreign key → Staff.Staff ID — NOT NULL