LAST

Tables (9)

Building

  • building_id — VARCHAR(50) — Primary key
  • building_name — VARCHAR(100) — NOT NULL

Course

  • course_id — VARCHAR(50) — Primary key
  • course_name — VARCHAR(100) — NOT NULL

Enrollment

  • student_id — VARCHAR(50) — Primary key — NOT NULL
  • course_id — VARCHAR(50) — Primary key — NOT NULL

Professor

  • professor_id — VARCHAR(50) — Primary key
  • professor_name — VARCHAR(100) — NOT NULL

ProfessorCourse

  • professor_id — VARCHAR(50) — Primary key — NOT NULL
  • course_id — VARCHAR(50) — Primary key — NOT NULL

Room

  • room_id — VARCHAR(50) — Primary key
  • room_name — VARCHAR(100) — NOT NULL

RoomBuilding

  • room_id — VARCHAR(50) — Primary key — NOT NULL
  • building_id — VARCHAR(50) — Primary key — NOT NULL

Student

  • student_id — VARCHAR(50) — Primary key
  • student_name — VARCHAR(100)
  • department_name — VARCHAR(100)

Timetable

  • timetable_id — INT
  • course_id — VARCHAR(50) — NOT NULL
  • room_id — VARCHAR(50) — NOT NULL
  • building_id — VARCHAR(50)
  • professor_id — VARCHAR(50)
  • day_of_week — VARCHAR(10)
  • time_slot — VARCHAR(20)