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)