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

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should 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.52 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

For Microsoft Access The Microsoft Access AutoNumber does not support ON DELETE and ON UPDATE constraint clausesTherefore create PET as shown in Quest... 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!

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

Assume that you are the owner of a small neighborhood bakery serving hundreds of customers in your area. Identify the kinds of customer information you would like your firms CRM system to capture....

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 the required SQL statements to create the PET_3 table. Assume that PetWeight is Numeric(4,1). PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET ( PetID , PetName,...

Write an SQL statement to add a PetWeight column like the one in PET_3 to the PET table, given that this column is NULL. Again, assume that PetWeight is Numeric(4,1). PET_OWNER ( OwnerID ,...

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

In the analysts playscript, what information about managers is recorded in the right-hand column?

Ammonia is contained in a rigid sealed tank unknown quality at 0oC. When heated in boiling water to 100oC its pressure reaches 1200 kPa. Find the initial quality, the heat transfer to the ammonia and...

Is conflict always negative? If so, what are some effective ways of preventing destructive conflict in the workplace?

Harry decides to finance his new home with a 30-year fixed mortgage. Because he figures he will be in this home for a long time, he decides to pay a fully deductible discount point on his mortgage to...

What is a multiple-tier driver?

What is a single-tier driver?

What role does the DBMS driver serve? Who supplies it?

Al Fateh Inc., has a seasonal pattern to its business. It borrows under a line of credit from Central Bank at 1% over prime. Its total asset requirements now (at year end) and estimated requirements...

We are evaluating a project that costs $ 8 8 3 , 0 0 0 , has a life of eight years, and has no salvage value. Assume that depreciation is straight - line to zero over the life of the project. Sales...

You have been assigned to implement a three-month hedge for a stock mutual fund portfolio that primarily invests in medium-sized companies. The mutual fund has a beta of 1.58 measured relative to the...