given the following requirements for a simple database for the football League (FL) Write the needed SQL
Fantastic news! We've Found the answer you've been seeking!
Question:
given the following requirements for a simple database for the football League (FL)
Write the needed SQL Statements to create the database:
the FL has many teams:,
each team has a name, a city, a coach, a captain, and a set of players; 24 players,
each player belongs to only one team,
each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, a team captain is also a player,
a game is played between two teams (host team and guest team) and has a date (such as May 11th, 2020) and a score (such as 4 to 2).
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: