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)