derive relational database schemas for the database from the above E/R diagram,

Question

derive relational database schemas for the database from the above E/R diagram, using the strategy described in the class notes and in the text for going from E/R relation.

Part 1: Consider the following model of a database for football (soccer) players, where a player plays isn't allowed. Derive a relational Schema based on this E/R diagram. Name. Name. Name President Player elon Country nclul In Club Name President Derive relational database schemas for the database from the above E/R diagram, using the strategy described in the class notes and in the text for going from E/R to relations.

Explanation / Answer

Please note that Primary Keys Are Underlined

Also, Foreign Keys are in Italics

I have added description using # symbol for you

Relational Schema:

Player(Name,Age,BelongsTo)

#Each player has a unique name, age, and belongs to only one country

Country(Name,PartOf)

#Each country has a unique name and is a part of some ConFed

ConFed(Name,President)

#Each conFed has a name and has a president

InClub(PlayerName,ClubName)

#One club has many players, and one player can be in many clubs, so we have created a new table for that

Club(ClubName,President,CountryName)

#Each club has a unique name, a president, and belongs to a country

#Since a club name can be same in two different countries, primary key here is a combination of country name and club name

If you face any issue, you can leave a comment :)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.