Create a referential integrity constraint on OwnerID in PET. Assume that deletions should cascade PET_OWNER (OwnerID, OwnerLastName,
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, PetDOB,?OwnerID)
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 83% (12 reviews)
For Microsoft Access The Microsoft Access AutoNumber does not support ON DELETE and ON UPDATE constraint clausesTherefore create PET as shown in Quest...View the full answer
Answered By
Charles mwangi
I am a postgraduate in chemistry (Industrial chemistry with management),with writing experience for more than 3 years.I have specialized in content development,questions,term papers and assignments.Majoring in chemistry,information science,management,human resource management,accounting,business law,marketing,psychology,excl expert ,education and engineering.I have tutored in other different platforms where my DNA includes three key aspects i.e,quality papers,timely and free from any academic malpractices.I frequently engage clients in each and every step to ensure quality service delivery.This is to ensure sustainability of the tutoring aspects as well as the credibility of the platform.
4.30+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science 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....
-
Law Management Services began business on January 1, 2012, with a capital investment of $120,000. The company manages condominiums for owners (Service Revenue) and rents space in its own office...
-
A researcher did a randomization test to compare men and women on a variable Y. The null hypothesis is that men and women are the same, and the alternative is that they are different. There are 28...
-
Why is the cost of system maintenance high?
-
Based on the following pedigree for a trait determined by a single gene (affected individuals are shown as filled symbols), state whether it would be possible for the trait to be inherited in each of...
-
Capitalization of Interest McPherson Furniture Company started construction of a combination office and warehouse building for its own use at an estimated cost of $5,000,000 on January 1, 2010....
-
You are the Director of the 6 ICU units at your facility. You have an all RN staff and CNA's in each of the units. Your CNO has recently informed you that he has performed a supply audit and has...
-
Paul V. Dietrich Farms Ltd.: Expansion Plan In November 2020, Paul Dietrich, a seventh-generation Canadian farmer, was presented with an investment opportunity. A local farmland owner was selling a...
-
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,...
-
Write the required SQL statements to create the PET_2 table. PET_2 (PetName, PetType, PetBreed, PetDOB, OwnerID) PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID,...
-
Nash Company has the following adjusted accounts and balances at year-end (June 30): Prepare an adjusted trial balance in good form for the Nash Company at June 30. Accounts payable Accounts...
-
A machine with a cost of $69,500 has an estimated residual value of $3,853 and an estimated life of 5 years or 17,789 hours. What is the amount of depreciation for the second full year, using the...
-
Chuck McElray owns Common Grounds Coffee House. The business has cash of $2,000 and furniture that cost $8,000. Debts include accounts payable of $1,000 and a $6,000 note payable. How much equity...
-
Assume that the expectations theory holds, and that liquidity and maturity risk premiums are zero. If the annual rate of interest on a 2-year Treasury bond is 10.5 percent and the rate on a 1-year...
-
"To motivate employees' organizations should focus on rewards and punishments". Critically discuss this statement with reference to relevant motivational theories. Leadership Assignment Theoretical...
-
At December 31, 20x2, Marsha Co. had a balance of $205,150 in work in process, represented by the following two jobs: Cost Job A Job B Direct materials $12,600 $29,000 Direct labour $23,300 $29,000...
-
During 2013, Gary earned $57,000 as an executive. Gary, who is single, supported his half sister, who lives in a nursing home. Gary received the following interest: $400 on City of Los Angeles bonds,...
-
The percentage of completion and completed contract methods are described in the FASB ASC. Search the codification to find the paragraphs covering these topics, cite them, and copy the results.
-
What is a multiple-tier driver?
-
What is a single-tier driver?
-
What role does the DBMS driver serve? Who supplies it?
-
130 g of water is placed in a 10-g aluminum cup. Both the water and cup start at temperature 40 C. 30 g of ice at an initial temperature of 0 C is added to the water. The ice is allowed to melt and...
-
A small plastic ball of mass 5.86 10-3 kg and charge +0.178 C is suspended from an insulating thread and hangs between the plates of a capacitor (see the drawing). The ball is in equilibrium, with...
-
Assume that the firm invests $170,000 today and $200,000 three years from now to get $75,000 at Year 1, $80,000 at Year 2, $75,000 at Year 3, $140,000 at Year 4, $165,000 at Year 5, and $155,000 at...
Study smarter with the SolutionInn App