Question: Please use the textbook - referenced figure 4 . 8 for this question. a . Write the DDL commands needed to create a relational database

Please use the textbook-referenced figure 4.8 for this question.
a. Write the DDL commands needed to create a relational database
for the schema for the horse racing example shown in Chapter 4,
Figure 4.8.
b. Make up data and enter records for at least five horses (name one
of them Lucky), six people (including owners, trainers, and
jockeys), and at least one race, with at least five entries.
c. Write SQL queries for each of the following and execute them:
(i) What are the name and telephone number of the person
who trained Lucky?
(ii) What was Luckys final position in a given race?
(iii) What are the name and address of the jockey who rode
the winning horse in a particular race?
Please use the textbook - referenced figure 4 . 8

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 Programming Questions!