SchoolSystem

Tables (5)

Student

  • S_id (student id) — Primary key — NOT NULL
  • Field
  • email (student email)
  • Field2 (student phone number)

Untitled (user)

  • Key — Primary key — NOT NULL

Untitled2 (Class)

  • Key (c_ID) — varchar — Primary key — NOT NULL
  • Field (C_name) — varchar
  • Field (scoore) — int
  • Field — varchar
  • Field2

Untitled3 (Enrollment)

  • Key — Primary key — NOT NULL
  • S_id (student id) — Foreign key → Student.S_id — NOT NULL
  • Key (Key2) — Foreign key → Untitled2.Key — NOT NULL
  • Field (e_id) — int
  • Field (s_id) — int
  • Field (c_id) — varchar
  • Field (e_score) — char
  • Field

Untitled4