task4-4
Tables (5)
course
- course_id — VARCHAR(10) — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- credits — INT — NOT NULL
- class_days — INT — NOT NULL
enrollment
- student_id — VARCHAR(10) — Foreign key → student.student_id — NOT NULL
- course_id — VARCHAR(10) — Foreign key → course.course_id — NOT NULL
instructor
- instructor_id — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- sex — CHAR(1)
- phone — VARCHAR(20)
- email — VARCHAR(100)
student
- student_id — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- sex — CHAR(1)
- phone — VARCHAR(20)
- email — VARCHAR(100)
teaches
- instructor_id — VARCHAR(10) — Foreign key → instructor.instructor_id — NOT NULL
- course_id — VARCHAR(10) — Foreign key → course.course_id — NOT NULL