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:

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!