SchoolSystem

Tables (5)

class (untitled2)

  • class id (class) — varchar — Primary key — NOT NULL
  • class name — varchar
  • score — int
  • field (Field) — varchar
  • field2 (Field2)

enrollment (Untitled3)

  • e_id (enroll number) — int — Primary key — NOT NULL
  • Key (studentid) — int — Foreign key → student.Key — NOT NULL
  • class id (class) — varchar — Foreign key → class.class id — NOT NULL
  • s_id (studient id) — int
  • c_id (key) — varchar
  • e_score (enroll score number) — char
  • field (Field)

passport (Untitled2)

  • p_id (Key) — Primary key — NOT NULL
  • ssn (Key2) — Foreign key → person.ssn — NOT NULL

person (Untitled4)

  • ssn (Key) — Primary key — NOT NULL

student (Untitled)

  • Key (studentid) — int — Primary key — NOT NULL
  • email (student email) — varchar
  • phone (student phone number) — varchar
  • Field