1115

Tables (3)

ClassRoom (Untitled3)

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

Professor (Untitled2)

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

Student (Untitled)

  • sid (Key) — char(8) — Primary key — NOT NULL
  • name (Field) — char(3)
  • addimission (Field2) — date
  • graduate_date (Field3) — date
  • gender (Field4) — char(1)
  • phone (Field5) — char(11)