Question

The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team. Each team is given an ID and Team name. Each player and each parent are given an ID when they sign up. Each player ID, first name, last name, their DOB are stored. Information about their parents (ParentID, Parent last name, Parent first name, Home phone and home address) is also requested and stored. For each coach, the system should keep their coach ID, Coach First name and Coach last name, Coach home phone number and the coach address. The following relationships must be defined between the relations (tables) you define. Team is related to Player Team is related to Coach Player is related to Parent - - Constraints and participation: A Team may or may not have a Player A player must have a Team A Team may have many Players A Player has only one Team A Coach must have a Team A Team may or may not have a Coach A Team may have many Coaches A Coach may coach many Teams A Player must have a Parent A Parent must have a Player A Player may have many Parents - - - - A Parent may have many Players. 1) Draw the data model using the constraints defined above. 2) What issue (s) do you see? 3) Propose a different model that would resolve these issues. Make sure to indicate the primary keys for each relation and the relevant foreign keys.

Please answer CLEARLY and LEGIBLE

Relational Algebra

Answer 1

Apart from 3 mastre tables (Player,Team, Coach)
The other relevant tables will be

Team_Coach Tables will be as follows:

Team id Coach Id (Primary key - Team id , Coach Id)

Player Team Table will be

PlayerId Team Id (Primary key - Player id , Team Id)

Player Parent Table will be

PlayerId Parent Id (Primary key - Player id , Parent Id)

Untitled - Notepad File Edit Format View Help / Parent Player id firstname/ lastname DOB id \ firstname lastname homeaddress Coach firstname lastname homeaddress In all the tables id is the primary key A1l the constraints are ok except a player has many parents.However it has been depuicted in the relationship diagram De与 02:56 1105-20185 O Type here to search ENG