MIS Project Assignment

Tables (6)

Apprentice (Untitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8

Badge (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Companion.Key — NOT NULL
  • Field
  • Field2

Companion (CopyOfUntitled)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Badge.Key — NOT NULL
  • Field7
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12

Lesson (Untitled5)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Companion.Key — NOT NULL
  • Key (Key3) — Foreign key → Apprentice.Key — NOT NULL

Registration (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Apprentice.Key — NOT NULL
  • Key (Key3) — Foreign key → Companion.Key — NOT NULL
  • Key (Key4) — Foreign key → Lesson.Key — NOT NULL

Review (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Apprentice.Key — NOT NULL
  • Key (Key3) — Foreign key → Companion.Key — NOT NULL
  • Key (Key22) — Foreign key → Companion.Key — NOT NULL
  • Key (Key4) — Foreign key → Lesson.Key — NOT NULL
  • Field