erd01

Tables (4)

Class (Untitled)

  • Cid (Key) — Primary key — NOT NULL
  • Cname (Field)
  • Croom (Field2)
  • Main_TID (Key2) — Foreign key → Teacher.TID
  • Sub_TID (Key3) — Foreign key → Teacher.TID

Role (Untitled3)

  • G_Role (Key) — Primary key — NOT NULL
  • G_Name (Field)

Student (Untitled2)

  • SID (Key) — Primary key — NOT NULL
  • LName (Field)
  • FName (Field2)
  • Cid (Key3) — Foreign key → Class.Cid
  • Gender (Field3)
  • Email (Field4)
  • Phone_Num (Field5)
  • G_Role (Key2) — Foreign key → Role.G_Role
  • G_Num (Field6)
  • Major (Field8)

Teacher (Untitled4)

  • TID (Key) — Primary key — NOT NULL
  • LName (Field)
  • FName (Field2)
  • Gender (Field3)
  • Phone_Num (Field4)
  • Email (Field5)
  • Inhouse (Field6)