db
Tables (6)
class
- year — INT — Primary key — NOT NULL
- semester — INT — Primary key — NOT NULL
- division — CHAR(2) — Primary key — NOT NULL
- course_id — CHAR(6) — Foreign key → course.course_id — NOT NULL
- classroom — VARCHAR(10)
- enroll — INT
- prof_id — CHAR(5) — Foreign key → professor.prof_id — NOT NULL
course
- course_id — CHAR(6) — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- credit — INT
department
- dept_id — CHAR(5) — Primary key — NOT NULL
- dept_name — VARCHAR(30) — NOT NULL
- office — VARCHAR(20)
professor
- prof_id — CHAR(5) — Primary key — NOT NULL
- resident_id — CHAR(14) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- position — VARCHAR(10)
- year_emp — INT
- dept_id — CHAR(5) — Foreign key → department.dept_id — NOT NULL
student
- stu_id — CHAR(10) — Primary key — NOT NULL
- resident_id — CHAR(14) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- year — INT
- address — VARCHAR(100)
- dept_id — CHAR(5) — Foreign key → department.dept_id — NOT NULL
takes
- stu_id — CHAR(10) — Foreign key → student.stu_id — NOT NULL
- course_id — CHAR(6) — Foreign key → class.course_id — NOT NULL
- year — INT — Foreign key → class.year — NOT NULL
- semester — INT — Foreign key → class.semester — NOT NULL
- division — CHAR(2) — Foreign key → class.division — NOT NULL
- grade — CHAR(2)