ERD Practice
Tables (8)
Area (area)
- Area (area) — VARCHAR(20) — Primary key — NOT NULL
Class (class)
- Class Id (class_id) — VARCHAR(10) — Primary key — NOT NULL
- Area (area) — VARCHAR(20) — Foreign key → Area.Area — NOT NULL
- Class (class) — INT(2)
Curriculum (curriculum)
- Curriculum (curriculum) — VARCHAR(20) — Primary key — NOT NULL
EMP (emp)
- Emp Id (emp_id) — INT(10) — Primary key — NOT NULL
- Emp Name (emp_name) — VARCHAR(20)
Major
- Major (major) — VARCHAR(1) — Primary key — NOT NULL
Staff (staff)
- Staff Id (staff_id) — INT(10) — Primary key — NOT NULL
- Class Id (class_id) — VARCHAR(10) — Foreign key → Class.Class Id — NOT NULL
- Emp Id (emp_id) — INT(10) — Foreign key → EMP.Emp Id — NOT NULL
Status (status)
- Status (status) — VARCHAR(1) — Primary key — NOT NULL
Student (student)
- Student Id (student_id) — INT(10) — Primary key — NOT NULL
- Major (major) — VARCHAR(1) — Foreign key → Major.Major — NOT NULL
- Status (status) — VARCHAR(1) — Foreign key → Status.Status — NOT NULL
- Class Id (class_id) — VARCHAR(10) — Foreign key → Class.Class Id — NOT NULL
- Period (period) — INT(2)
- Name (name) — VARCHAR(10)
- Age (age) — INT(5)