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)