Question: (a) Write the DDL commands needed to create a relational database for the schema for the horse racing example shown in Figure 4.8. (b) Make

(a) Write the DDL commands needed to create a relational database for the schema for the horse racing example shown in 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 Lucky's 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?

Provide your responses in a DDL file (*-schema.sql) and DML file (*-data.sql).

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

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 ,...

USING MY SQL Workbench (a) Write the DDL commands needed to create a relational database for the schema for the horse racing example shown in Figure 4.8. (b) Make up data and enter records for at...

Consider the following schema. Write the DDL commands needed to create a relational database for this horse racing example. RaceHorse (regNum, hName, gender, type, purchaseDate, purchasePrice,...

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,...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Code needed for last two pages using primary and foreign key Creating a Relational Database Schema from ER Diagram and Populating the Database 1. BEFORE adding any PK Constraint or PK-FK Constraints...

Discuss some ways the company could estimate the projects risk and then explain how risk might be incorporated into the decision analysis.

5. Record assets acquired and liabilities assumed using the * (2 Points) shares value principle book value principle fair value principle fair and shares value principle

A put option on UK pounds has a strike price of $2.05/f and a cost of $0.02. What is the break-even price for the option? A A) $2.03/E B B) $2.05/E. C C) $2.07/f D D) The answer depends upon if this...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+2 What are the human resource implications of these new ways of working?

=+j Enabling a productive global workforce.

=+ Are you interested in creating or