Question: Question #2.) Database Relationship Case Scenario (25 points) - Review the following case scenario and answer the questions by filling out the table template below,

Question \#2.) Database Relationship Case Scenario (25 points) - Review the following case scenario and answer the questions by filling out the table template below, and - 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 tournament 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. What are the objects of interest? 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
