ERD

Tables (7)

Untitled (Student)

  • Key (sid) — char(8) — Primary key — NOT NULL
  • Field (name) — char(3)
  • Field (admission) — date
  • Field (graduate_date) — date
  • Field (gender) — char(1)
  • Field (phone) — char(11)
  • Key (LName) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Course)

  • Key (cid) — char(6) — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (grade) — int

Untitled (Professor)

  • Key (pid) — char(4) — Primary key — NOT NULL
  • Field (room) — char(5)
  • Field (phone) — char(11)
  • Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Lab)

  • Key (LName) — varchar(20) — Primary key — NOT NULL
  • Field (room) — char(5)
  • Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (ClassRoom)

  • Key (room) — char(5) — Primary key — NOT NULL
  • Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Address)

  • Key (zipcode) — char(5) — Primary key — NOT NULL
  • Field (Do) — char(10)
  • Field (city) — char(10)
  • Field (Gu) — char(10)
  • Field (Bunzi) — char(10)

Untitled (Sugang)

  • Key (cid) — char(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (sid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (open_date) — date
  • Field (score) — char(2)
  • Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (room) — char(5) — Foreign key → Untitled.Key — NOT NULL