Question
You are the manager of a junior baseball team composed of 20 players . The baseball tournament lasts 10 weeks and each team plays against
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.
design a logical model by identifying correctly all the relationships and their degrees (e.g., 1:1, 1:M, M:M)
Down below are the relationships between object models:
- A Team has a many players, but a player belongs to one team
- A Team participate many matches, but in a match only one team must be participate.
- A Player belongs to one team, but a team contains many players
- A Player may have several positions, in a position contains several players.
- A Player may play several matches, a match can play by many players.
Objective: design a logical model by identifying correctly all the relationships and their degrees (e.g., 1:1, 1:M, M:M)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Please comment if you need any additional information. Please design logical model. An example of a logical model can be found below:
Thank you! Will rate thumbs up
Team Player Position Matches Team 1:M NA* 1:M Player M:1 M:N M:N Position NA* M:N M:N Matches M:1 M:N M:N An example of a logical model is shared below for your reference. 1: N Employees Emplo PK Managerld FK DeptiD FK 1:1 Departments DeptiDPK 1: N 1: M M:N Dependents DependentiDPKN EmplD EK B Hobbies Hobbyid ------ PK Dependenti FK AO (Note: need to break the M: M relationship above with an Intersector Join table)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started