Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you explain in a few sentences what this ORM diagram represents. Athlete is an entity type. Reference Scheme: Athlete has Athlete_Nr. Reference Mode: .Nr.

Can you explain in a few sentences what this ORM diagram represents.

image

Athlete is an entity type.
Reference Scheme: Athlete has Athlete_Nr.
Reference Mode: .Nr.
Data Type: Numeric: Signed Integer.

Fact Types:
Athlete has Athlete_Nr.
Athlete has FamilyName.
Athlete has ExtendedGivenName.
Athlete has PhoneNR.
Athlete has EmailAddress.
Athlete was born in State.
Athlete plays Sport.
Athlete was born in Country.

FamilyName is a value type.
Data Type: Text: Variable Length (30).

Fact Types:
Athlete has FamilyName.

ExtendedGivenName is a value type.
Data Type: Text: Variable Length (30).

Fact Types:
Athlete has ExtendedGivenName.

PhoneNR is a value type.
Data Type: Text: Variable Length (10).

Fact Types:
Athlete has PhoneNR.

EmailAddress is a value type.
Data Type: Text: Variable Length (30).

Fact Types:
Athlete has EmailAddress.

State is an entity type.
Reference Scheme: State has StateCode; State is in Country.

Fact Types:
Athlete was born in State.
State has StateCode.
State is in Country.

StateCode is a value type.
Data Type: Text: Fixed Length (2).

Fact Types:
State has StateCode.

Country is an entity type.
Reference Scheme: Country has Country_Code.
Reference Mode: .Code.
Data Type: Text: Fixed Length (2).

Fact Types:
Country has Country_Code.
State is in Country.
Country is large.
Country has CountryName.
Country in Sport has Rank.
Athlete was born in Country.

CountryName is a value type.
Data Type: Text: Variable Length (30).

Fact Types:
Country has CountryName.

Sport is an entity type.
Reference Scheme: Sport has Sport_Name.
Reference Mode: .Name.
Data Type: Text: Fixed Length (20).

Fact Types:
Sport has Sport_Name.
Country in Sport has Rank.
Athlete plays Sport.

Rank is an entity type.
Reference Scheme: Rank has Rank_Nr.
Reference Mode: .Nr.
Data Type: Numeric: Unsigned Small Integer.

Fact Types:
Rank has Rank_Nr.
Country in Sport has Rank.
Playing has Rank.

Athlete has FamilyName.
Each Athlete has exactly one FamilyName.
It is possible that more than one Athlete has the same FamilyName.

Athlete has ExtendedGivenName.
Each Athlete has exactly one ExtendedGivenName.
It is possible that more than one Athlete has the same ExtendedGivenName.

Athlete has PhoneNR.
Each Athlete has at most one PhoneNR.
It is possible that more than one Athlete has the same PhoneNR.

Athlete has EmailAddress.
Each Athlete has at most one EmailAddress.
It is possible that more than one Athlete has the same EmailAddress.

Athlete was born in State.
Each Athlete was born in at most one State.
It is possible that more than one Athlete was born in the same State.

State has StateCode.
Each State has exactly one StateCode.
It is possible that more than one State has the same StateCode.

State is in Country.
Each State is in exactly one Country.
It is possible that more than one State is in the same Country.

Country is large.
In each population of Country is large, each Country occurs at most once.

Country has CountryName.
Each Country has exactly one CountryName.
Each CountryName is of at most one Country.

Country in Sport has Rank.
For each Country and Sport,
that Country in that Sport has at most one Rank.
This association with Country, Sport provides the preferred identification scheme for CountryInSportHasRank.
For each Sport and Rank,
at most one Country in that Sport has that Rank.

Athlete plays Sport.
It is possible that for some Sport, more than one Athlete plays that Sport
and that some Athlete plays more than one Sport.
In each population of Athlete plays Sport, each Sport, Athlete combination occurs at most once.
This association with Sport, Athlete provides the preferred identification scheme for Playing.

Playing has Rank.
Each Playing has at most one Rank.
It is possible that more than one Playing has the same Rank.

Athlete was born in Country.
Each Athlete was born in at most one Country.
It is possible that more than one Athlete was born in the same Country.
Derivation Note: * Athlete was born in Country off that Athlete was born in some State that is in that Country.

For each FamilyName and ExtendedGivenName,
at most one Athlete has that FamilyName and
has that ExtendedGivenName.

Each Athlete has some PhoneNR
or has some EmailAddress.

For each StateCode and Country,
at most one State has that StateCode and
is in that Country.
This association with StateCode, Country provides the preferred identification scheme for State.

For each Sport and Rank,
at most one Playing involves that Sport
and has that Rank.

Notes: * Athlete was born in Country off that Athlete was born in some State that is in that Country.

 

 

 

Can you explain in a few sentences what is shown in this relational schema shot.

image

PhoneNR EmailAddress Sport (.Name) has has "Playing !" plays has Athlete (.Nr) Rank (.Nr) has has was born in was born in FamilyName Extended GivenName State has is in Athlete was born in Country off that Athlete was born in some State that is in that Country. StateCode Country (.Code) is large has/ is of in ... has... Sport (.Name) CountryName Rank (.Nr)

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_2

Step: 3

blur-text-image_3

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

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Algorithms questions

Question

=+a) Make a decision tree for these decisions.

Answered: 1 week ago