Question: Design a logical model for the baseball team. Question $2 Requirements: Complete in filling out the table given below and in designing the Baseball team

Design a logical model for the baseball team. Question $2 Requirements: Complete in filling out the table given below and in designing the Baseball team Information logical modeling You are the manager of a junior baseball team composed of 20 players. The baseball toumament lasts 10 weeks and each team plays against each other once during the duration of the tournament. Certain players are skillful enough to play different positions. Your team plays one game every Saturday (An Event, e-g.. Matches) afternoon against a different team. 1. 1. What are the objects of interest? 2. 2 What are the relationships that exist among the objects of interest? 3. Are there any other possible entities for this team's data structure? 4. Carefully review and fill the table below if there are any remaining relationships exist between two entities. 5. Provide a clear rationale if you happen to add any new entities and the importance of their relationship in this database design structure. Team Position Matches Player 1:M Teal NA Player M: 1 M:N M:N Position NA M:N M:N Matches M: 1 M:N M:N Rationale: Each Team has many Players and each Player plays in only one Team Each Player may play in one or more Positions and each Position is played by one or more Players Each Match is played against one Team (at a time) and each Team plays in one or more Matches Note: there is no relationship between Team and Position. Position is related to Player. Design a logical model for the baseball team. Question $2 Requirements: Complete in filling out the table given below and in designing the Baseball team Information logical modeling You are the manager of a junior baseball team composed of 20 players. The baseball toumament lasts 10 weeks and each team plays against each other once during the duration of the tournament. Certain players are skillful enough to play different positions. Your team plays one game every Saturday (An Event, e-g.. Matches) afternoon against a different team. 1. 1. What are the objects of interest? 2. 2 What are the relationships that exist among the objects of interest? 3. Are there any other possible entities for this team's data structure? 4. Carefully review and fill the table below if there are any remaining relationships exist between two entities. 5. Provide a clear rationale if you happen to add any new entities and the importance of their relationship in this database design structure. Team Position Matches Player 1:M Teal NA Player M: 1 M:N M:N Position NA M:N M:N Matches M: 1 M:N M:N Rationale: Each Team has many Players and each Player plays in only one Team Each Player may play in one or more Positions and each Position is played by one or more Players Each Match is played against one Team (at a time) and each Team plays in one or more Matches Note: there is no relationship between Team and Position. Position is related to Player
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
