Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions