y 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 ( 2020) and a score (such as 4 to 2). host team and guest team) and has a date (such as May 11th, 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
Suppose you are given the following requirements for a simple
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 ( 2020) and a score (such as 4 to 2). host team and guest team) and has a date (such as May 11th,
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images