기말
테이블 (6)
COURSE
- course_id — INTEGER
- course_name — TEXT — NOT NULL
- dept — TEXT
- grade — INTEGER
- credit — INTEGER
- prof_id — INTEGER
- room_id — TEXT
- day_of_week — TEXT
- period — INTEGER
- capacity — INTEGER
ENROLLMENT
- enroll_id — INTEGER
- student_id — INTEGER — NOT NULL
- course_id — INTEGER — NOT NULL
- reg_date — TEXT
PROFESSOR
- prof_id — INTEGER
- name — TEXT — NOT NULL
- dept — TEXT
ROOM
- room_id — TEXT
- building — TEXT
- floor — INTEGER
- room_no — TEXT
STAFF
- staff_id — INTEGER
- name — TEXT — NOT NULL
- dept — TEXT
STUDENT
- student_id — INTEGER
- name — TEXT — NOT NULL
- dept — TEXT
- grade — INTEGER