departmentERD

Tables (5)

Lab (Untitled5)

  • Lname (Key) — varchar(20) — Primary key — NOT NULL
  • room (Field) — char(5)
  • Field2

course (Untitled3)

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

office (Untitled4)

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

porfessor (Untitled2)

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

student (Untitled)

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