221115

Tables (7)

Untitled (student)

  • Key (sid) — char(8) — Primary key — NOT NULL
  • Field (name) — char(3)
  • Field (addmission_day) — date
  • Field (graduate_day) — date
  • Field (gender) — char(1)
  • Field (phone) — char(11)

Untitled (professor)

  • Key (pid) — char(8) — Primary key — NOT NULL
  • Field (room) — char(5)
  • Field (phone) — char(11)

Untitled (course)

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

Untitled (office)

  • Key (oid) — char(9) — Primary key — NOT NULL
  • Field (name) — varchar(20)

Untitled (lab)

  • Key (lname) — varchar(20) — Primary key — NOT NULL
  • Field (room_no) — char(5)

Untitled (class)

  • Key (room) — char(8) — Primary key — NOT NULL

Untitled (sugang)

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