Question: Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType,

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade.

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)

FIGURE 3-18| PET_OWNER Data OwnerID OwnerLastName OwnerFirstName OwnerPhone OwnerEmail 1 Downs Marsha

555-537-8765 Marsha.Downs@somewhere.com 2 James Richard 555-537-7654 Richard.James@somewhere.com 3 Frier Liz 555-537-6543 Liz.Frier@somewhere.com

FIGURE 3-18| PET_OWNER Data OwnerID OwnerLastName OwnerFirstName OwnerPhone OwnerEmail 1 Downs Marsha 555-537-8765 Marsha.Downs@somewhere.com 2 James Richard 555-537-7654 Richard.James@somewhere.com 3 Frier Liz 555-537-6543 Liz.Frier@somewhere.com 4 Trent Miles Miles.Trent@somewhere.com

Step by Step Solution

★★★★★

3.42 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

For Microsoft Access Microsoft Access does not support ON DELETE and ON UPDATE constraint clauses See Does Not Work with Microsoft Access ANSI89 SQL o... View full answer

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 Database Concepts Questions!

Cascade of Poses (COP) is a business that specialises in the delivery of arrangements of roses. Cascade of Poses uses six main suppliers of roses, and has worked hard over the past two years to...

Pet Partner is a small company that provides pet boarding, grooming, and minor medical services for dogs and cats. The company has been successful for its first three years because of its careful...

In a study of pet owners, it was reported that 24% celebrate their pets birthday (Pet Statistics, Bissell Homecare, Inc., 2010). Suppose that this estimate was from a random sample of 200 pet owners....

Write a SQL statement to display all columns of all rows of PET. Do not use the asterisk (*) notation. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET ( PetID ,...

Data table for a few SQL questions : Use the following tables for your answers: PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET_3 (PetID, PetName, PetType, PetBreed ,...

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade. The PET_OWNER and PET tables already exist, so create the constraint only.PET_OWNER ( OwnerID,...

Write a SQL statement to display the name and breed of all pets sorted by PetBreed in ascending order and by PetName in descending order within PetBreed. PET_OWNER ( OwnerID , OwnerLastName,...

Write an SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Assume, however, that you have only...

Write SQL statements to add a PetWeight column like the one in PET_3 to the PET table, given that this column is NOT NULL. Again, assume that PetWeight is Numeric(4,1). Use the PetWeight data from...

Write a SQL CREATE TABLE statement to create the PET_OWNER table, with OwnerID as a surrogate key. Justify your choices of column properties. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName,...

The following are relevant inventory numbers from ABC Bistro for the 2021 fiscal year. Inventory-Food & Beverages, March 31, 2020 $1,177 Inventory-Food & Beverages, April 1, 2021 $1,664 $146,200 Cost...

Petty Cash Mc Mann, Inc. decided to establish a petty cash fund to help ensure internal control over its small cash expenditures. The following information is available for the month of April. 1. On...

1 . Tata Brothers wish to approach the bankers for temporary overdraft facility for the period from October 2 0 1 0 to December 2 0 1 0 . During the period of this period of these three months, the...

Consider the settlement statement in Appendix A to this chapter. What amounts on the statement are the Jeffersons allowed to deduct on their 2016 tax return? Indicate the settlement statement line...

Explain how the three types of data sources differ.

Summarize the three SQL grammar conformance levels.

Summarize the three ODBC API conformance levels.

You are given a cash flow diagram to determine the ROR by trial and error. After trying 4 different i* values, the following PW values have been obtained: Step 1: try i* = 5%, AW = $767 Step 2 = try...

Risk is not only measured in terms of losses, but also in terms of variability. The highest possible value for positive correlation is +1. Combining assets with highly correlated returns will greatly...

On November 1 , the home mortgage balance was $227,000 for the home owned by Donald Howard. The interest rate for the loan is 9 percent. Assuming that Donald makes the November monthly mortgage...