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)