Crowdly
Add to Chrome
Football League Database Schema Note: PK-Primary key, FK-Foreign key Tables ...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Football League Database Schema
Note: PK-Primary key, FK-Foreign key
Tables
Teams
Column | Type |
|---|---|
TeamID | INT PK |
TeamName | VARCHAR(100) |
City | VARCHAR(100) |
Coach | VARCHAR(100) |
Players
Column | Type |
|---|---|
PlayerID | INT PK |
TeamID | INT FK |
PlayerName | VARCHAR(100) |
Position | VARCHAR(30) |
JerseyNumber | INT |
Stadiums
Column | Type |
|---|---|
StadiumID | INT PK |
StadiumName | VARCHAR(100) |
Capacity | INT |
Matches
Column | Type |
|---|---|
MatchID | INT PK |
HomeTeamID | INT FK |
AwayTeamID | INT FK |
StadiumID | INT FK |
MatchDate | DATE |
HomeGoals | INT |
AwayGoals | INT |
Goals
Column | Type |
|---|---|
GoalID | INT PK |
MatchID | INT FK |
PlayerID | INT FK |
GoalMinute | INT |
Referees
Column | Type |
|---|---|
RefereeID | INT PK |
RefereeName | VARCHAR(100) |
Country | VARCHAR(100) |
and answer the following question
Write an SQL DML statement to insert a new player with the following details:
- PlayerID: 501
- TeamID: 101
- PlayerName: Player501
- Position: Forward
- JerseyNumber: 9