Student Course Registration System
Tables (5)
Course
- course_id — INT
- course_code — VARCHAR(20) — NOT NULL
- course_name — VARCHAR(200) — NOT NULL
- credit — INT — NOT NULL
- department — VARCHAR(100)
Course_Section
- section_id — INT
- course_id — INT — NOT NULL
- professor_id — INT
- semester — VARCHAR(20) — NOT NULL
- year — INT — NOT NULL
- classroom — VARCHAR(50)
- schedule_time — VARCHAR(100)
- capacity — INT
Enrollment
- enrollment_id — INT
- student_id — INT — NOT NULL
- section_id — INT — NOT NULL
- enroll_date — DATETIME — NOT NULL
- grade — VARCHAR(5)
Professor
- professor_id — INT
- name — VARCHAR(100) — NOT NULL
- office — VARCHAR(50)
- email — VARCHAR(150)
Student
- student_id — INT
- name — VARCHAR(100) — NOT NULL
- major — VARCHAR(100)
- grade — VARCHAR(10)
- email — VARCHAR(150)