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