mentoring

Tables (5)

classroom (Untitled)

  • building (Key) — Primary key — NOT NULL
  • room_number (Key2) — Primary key — NOT NULL
  • capacity (Field)

course (Untitled3)

  • course_id (Key) — Primary key — NOT NULL
  • dept_name (Key2) — Foreign key → department.dept_name — NOT NULL
  • title (Field)
  • credits (Field2)

department (Untitled2)

  • dept_name (Key) — Primary key — NOT NULL
  • building (Field)
  • budget (Field2)

instructor (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • dept_name (Key2) — Foreign key → department.dept_name — NOT NULL
  • name (Field)
  • salary (Field2)

section (Untitled5)

  • sec_id (Key2) — Primary key — NOT NULL
  • semester (Key3) — Primary key — NOT NULL
  • year (Key4) — Primary key — NOT NULL
  • course_id (Key) — Foreign key → course.course_id — NOT NULL
  • building (Key5) — Foreign key → classroom.building — NOT NULL
  • room_number (Key23) — Foreign key → classroom.room_number — NOT NULL
  • time_slot_id (Field)