Suppose you are given the following requirements for a simple database for the football League (FL):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).Construct a Database Conceptual Model using UML ER diagram for the FL database.Use mapping rules to convert the design to Logical database model using UML ER model.Check the entities to be in the 3NF normal form.Write the needed SQL Statements to create the database. DateScoreGameСарainSkill levelHostGuestPlayerInjuryrecordsTeamlogbelong toDiscriptionTeam nameCoachPlayer namePositionCity Suppose you are given the following requirements for a simple database for the football League (FL):• 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).1- Construct a Database Conceptual Model using UML ER diagram for the FL database.2- Use mapping rules to convert the design to Logical database model using UML ER model.3- Check the entities to be in the 3NF normal form.4- Write the needed SQL Statements to create the database.

Answered: Suppose you are given the following…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Suppose you are given the following requirements for a simple database for the football League (FL):

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).
Construct a Database Conceptual Model using UML ER diagram for the FL database.
Use mapping rules to convert the design to Logical database model using UML ER model.
Check the entities to be in the 3NF normal form.
Write the needed SQL Statements to create the database.