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 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
