student class

Tables (4)

class (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • title (Field)

online (Untitled4)

  • Key — Primary key — NOT NULL

student (Untitled)

  • ID (Key) — integer — Primary key — NOT NULL
  • Major (Key2) — Primary key — NOT NULL
  • age (Field)
  • gender (Field2)
  • First Name (Field3)
  • Last Name (Field4)
  • Phone (Field5)
  • Email (Field6)

student&class (Untitled3)

  • ID (Key) — Foreign key → student.ID — NOT NULL
  • Major (Key2) — Foreign key → student.Major — NOT NULL
  • ID (Key3) — Foreign key → class.ID — NOT NULL