assignment1

Tables (6)

Class (Untitled4)

  • Region (Key) — Primary key — NOT NULL
  • Number (Key2) — Primary key — NOT NULL
  • ID (Key3) — Primary key — NOT NULL

Coach (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • AssignedClassID (Key2) — Foreign key → Class.Region — NOT NULL

Consultant (Untitled)

  • ID (Key2) — Primary key — NOT NULL
  • AssignedClassID (Key) — Foreign key → Class.Region — NOT NULL

Curriculum (Untitled5)

  • Category (Key) — Primary key — NOT NULL

Job (Untitled3)

  • AssignieeID (Key3) — Foreign key → Coach.ID — NOT NULL
  • AssignedClassID (Key) — Foreign key → Consultant.AssignedClassID — NOT NULL
  • Description (Field)

Student

  • Name (Key) — Primary key — NOT NULL
  • OrdinalNumber (Key2) — Primary key — NOT NULL
  • MajorStatus (Key3) — Primary key — NOT NULL
  • CompleteStatus (Key4) — Primary key — NOT NULL
  • Region (Key5) — Primary key — NOT NULL
  • ClassID (Key7) — Foreign key → Class.Region — NOT NULL