Question

Draw a relational model for the following case study.
Case Study
The local under-sixteen football league needs a database to help track teams, children
that sign up to play in the league, the parents of these children and the coaches for each
team.
The league wishes to record the details for each parent of a particular player (the parents
last name, first name, phone contact number and address). For each player, the system
needs to record the player's last name, first name, blood type and their date of birth. Any
allergies that the player has also need to be recorded.
A player may only play in one team with this league. Each team is given a unique id, the
system needs to record this id, the teams name, and the city their home ground is located
(a city may have several under-sixteen teams based in it). A team’s colours are also to be
recorded, teams may choose to use a single or multiple team colours. A team may have
several coaches – one of the coaches is designated as the head coach.
A coach is only permitted to coach one team in the under-sixteen leagues. All
communications from the league to the team are via the head coach. To be registered to
play in this league a team must have a head coach and at least one player. The database
needs to track a coach's first and last name, phone and address contact details and the
team that they are coaching.

Answer 1

Hey here, is my answer......to appreciate my work please give positive Rating......

Draw a relational model for the following case study.

Here we have Entities:-

• PARENTS: Parents_ID, last name, first name, phone_no, address
• PLAYER: Player_ID, last name, first name, blood type, date of birth, Allergy.
• TEAM: Team_ID, Colour_ID, Player_ID, Team_name, City.
• COLOUR: Colour_ID, Team_ID, Colour_name.
• COACH: Coach_ID, Player_ID, Team_ID,  last name, first name, phone_no, address, Team_name.

RELATIONSHIP and Cardinality:-

• A Parent must have one Player.
• A Player must have a parent.
• A player has only one Team.
• A Team may has one or more Colours.
• A Team may have many Coaches.
• A coach has only one Player.
• A Coach must have a Team.
• A Player has only one Team.

thanks...................... for any help and query please drop comment in comment section....