DBS Lab7

Tables (5)

Coaches (Untitled3)

  • Coach_ID (Key) — Primary key — NOT NULL
  • Team_ID (Key2) — Primary key — NOT NULL
  • Name (Field)

Guardians (Untitled2)

  • Guardian_ID (Key) — Primary key — NOT NULL
  • Name (Field)

Players (Untitled4)

  • Player_ID (Key) — Primary key — NOT NULL
  • Team_ID (PK) — Foreign key → Teams.Team_ID — NOT NULL
  • Guardian_ID (Key2) — Foreign key → Guardians.Guardian_ID — NOT NULL
  • Key2 (Key22) — Foreign key → Teams.Key2 — NOT NULL
  • Name (Field)
  • Birth_Day (Field2)
  • Shirt_Number (Field3)

Sponsors (Untitled5)

  • Sponsor_ID (Key) — Primary key — NOT NULL
  • Team_ID (Key2) — Primary key — NOT NULL
  • Name (Field)
  • League (Field2)

Teams (Untitled)

  • Team_ID (PK) — Primary key — NOT NULL
  • Coach_ID (Key) — Foreign key → Coaches.Coach_ID — NOT NULL
  • Sponsor_ID (Key2) — Foreign key → Sponsors.Sponsor_ID — NOT NULL
  • Key2 (Key22) — Foreign key → Coaches.Team_ID — NOT NULL
  • Name (Field)