Question: Create a relational database for the schema for the horse racing example. Make up data and enter records for at least 5 horses (name one

Create a relational database for the schema for

Create a relational database for the schema for the horse racing example. Make up data and enter records for at least 5 horses (name one of the horses Lucky), at least 10 people (owners, trainers, and jockeys), and at least 5 races, with at least 5 entries in every race.

Write SQL queries for each of the following; execute and save them:

  • What are the name and telephone number of the person who trained Lucky?
  • What was Luckys final position in a given race?
  • What are the name and address of the jockey who rode the winning horse in a particular race?
  • Create a trigger to track the number of first place finishes each jockey has earned.
RaceHorse (regnum, hName, gender, type, purchaseDate, purchasePrice, trainedBy, stabledat) Offspring (regnum, parent) Barn (bid, bName) Person (pId, pName, pPhone, pAddress) OwnedBy (regnum. pId, percentage) RaceSchedule (sid, year, month, day) Race(sId, rNumber, purse) Entry (sId, rNumber, gate, finalPos, jockey, horse) RaceHorse (regnum, hName, gender, type, purchaseDate, purchasePrice, trainedBy, stabledat) Offspring (regnum, parent) Barn (bid, bName) Person (pId, pName, pPhone, pAddress) OwnedBy (regnum. pId, percentage) RaceSchedule (sid, year, month, day) Race(sId, rNumber, purse) Entry (sId, rNumber, gate, finalPos, jockey, horse)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!