dd
Tables (5)
COURSE
- COURSE_ID — INT
- COURSE_NAME — VARCHAR(100) — NOT NULL
- DEPT — VARCHAR(50)
- GRADE — INT
- CREDIT — INT
- PROF_ID — INT
- ROOM_ID — VARCHAR(10)
- DAY_OF_WEEK — VARCHAR(5)
- PERIOD — INT
- CAPACITY — INT
- CHECK — (CAPACITY >= 1)
ENROLLMENT
- ENROLL_ID — INT
- STUDENT_ID — INT — NOT NULL
- COURSE_ID — INT — NOT NULL
- REG_DATE — DATE
PROFESSOR
- PROF_ID — INT
- NAME — VARCHAR(50) — NOT NULL
- DEPT — VARCHAR(50)
ROOM
- ROOM_ID — VARCHAR(10)
- BUILDING — VARCHAR(50)
- FLOOR — INT
- ROOM_NO — VARCHAR(10)
STUDENT
- STUDENT_ID — INT
- NAME — VARCHAR(50) — NOT NULL
- DEPT — VARCHAR(50)
- GRADE — INT