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