Answered You can hire a professional tutor to get the answer.
What are entities and attributes for the given business rules? What are the PARTICIPATION and CONNECTIVITY , cardinalities?
What are entities and attributes for the given business rules? What are the PARTICIPATION and CONNECTIVITY , cardinalities?
A database is to be developed to hold details about a range of team sports including:Football , Soccer, Baseball,Basketball,Beach Volleyball,Cricket,Netball,Rugby League,Rugby Union,Volleyball
For each sport we wish to record the sports name, the sports standard team size (the number of players on the ground/court at any time), a description of the sport to a maximum of (VARCHAR 100 )and whether the sport is played in multiple countries of the world (ie. if the sport is international).
Sports are arranged into leagues. For each league we wish to record the league code, the league name, whether the league is an international league, the name of the President/CEO of the league, the title of the position held by the this league head, the leagues contact address and phone number.
Sports are played by teams, a given team is restricted to playing a single sport. Each team is assigned a unique team code across all sports. A team will have recorded the teams name, the home city of the team, the name of the head of the team (the President/CEO) and the name of the team's head coach.
A team consists of players. All players are required to be registered as a player and are assigned a unique player number across all sports. The players name is recorded. The system must also record the players height, weight, date of birth and a brief bio of the player
(which is optional) up to (VARCHAR 200) A given player may be a member of multiple teams eg. a local, a state and a national team, or even across different sports. The system must also record the official position of a player within a given team, where such a position has been
assigned. We wish to record, for each player the amount of time they spend on the ground for each game they play in.
Within a league, when two teams play one another they play at a venue, on a particular date with a particular game start time. The outcome from the game may be one team Wins, a Draw, the game is Cancelled or Forfeited. A sample game fixture/result is shown in Appendix
A (note not all rows are shown in each table, indicated by ....). The system must allow the full season fixture to be loaded at the start of the season, game results will be updated as they
are played.
For the venues in which games are played we wish to record the name of the venue, its full address (including city) and its seating capacity. For each city in which a venue is located we wish to record the city's name, elevation in metres and average temperature, average high temperature, average low temperature (all temperatures in C), average precipitation (rainfall
in mm) and the country in which the city is located. Typical weather data can be determined from several internet locations including
http://www.weatherbase.com/
Countries, are identified by the ISO3166-1 2-character country, details of which can be obtained from several internet locations, for example the CommonDataHub http://www.commondatahub.com/live
Required to do
Conceptual model (Entity Relationship Diagram) for the Sports database.
○ For this conceptual model, include identifiers (keys) for each entity and the other attributes required for that entity to support the operational activities of the database. As a conceptual model no include foreign keys.
○ No surrogate key be added to this model.
○ Participation and connectivity for all relationships on the diagram
