departmentERD

Tables (7)

Address (Untitled4)

  • zipcode (Key) — date(5) — Primary key — NOT NULL
  • Do (Field) — char(30)
  • City (Field2) — char(10)
  • gu (Field3) — char(10)
  • bungi (Field4) — char(10)

ClassRoom (Untitled6)

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

Course (Untitled3)

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

Lab (Untitled5)

  • Lname (Key) — varchar(20) — Primary key — NOT NULL
  • roomNo (Field) — char(5)
  • pid (Key2) — char(4) — Foreign key → Professor.pid — NOT NULL
  • zipcode (Key3) — date(5) — Foreign key → Address.zipcode — NOT NULL

Professor (Untitled2)

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

Student (Untitled)

  • sid (Key) — char(8) — Primary key — NOT NULL
  • name (Field) — char(3)
  • admission (Field2) — date
  • graduate_date (Field3) — date
  • gender (Field4) — char(1)
  • phone (Field5) — char(11)
  • Lname (Key2) — varchar(20) — Foreign key → Lab.Lname — NOT NULL
  • zipcode (Key3) — date(5) — Foreign key → Address.zipcode — NOT NULL

Sugang (Untitled7)

  • sid (Key) — char(8) — Foreign key → Student.sid — NOT NULL
  • cid (Key2) — char(6) — Foreign key → Course.cid — NOT NULL
  • Open_date (Field) — date
  • score (Field2) — char(2)
  • pid (Key3) — char(4) — Foreign key → Professor.pid — NOT NULL
  • room (Key4) — char(5) — Foreign key → ClassRoom.room — NOT NULL