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...
-
K Find the indicated probabilities using the geometric distribution, the Poisson distribution, or the binomial distribution. Then determine if the events are unusual. If convenient, use the...
-
Indicate whether each of the following statements constitutes a potential advantage (A), disadvantage (D), or neither (N) of using transfer prices for support department costs. a. Requires additional...
-
MVP Corp uses LIFO to value its inventory. The 20x8 inventory records disclose the following: At December 26, 20x8, the company had a special, nonrecurring opportunity to purchase 40,000 units at $17...
-
Assertion - Two prominent limitations of Freud's theories on personality are that they are difficult to test empirically and they are poor at predicting a person's future behaviour Reason - Many of...
-
Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Number Name and Address Payroll information...
-
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,...
-
(J. Watson) Stanford Industries currently uses a normal job-costing system with a single overhead cost pool. It supplies parts to the aeronautic industry and, as a result, quality control is...
-
How easy (or hard) would it be for rivals like Walmart or Carrefour to adopt Tescos data management techniques? Bluebonnet Creameries is a large U.S. ice cream company. The familyowned enterprise...
-
What is the basis of Tescos success? Bluebonnet Creameries is a large U.S. ice cream company. The familyowned enterprise makes premium ice cream using only fresh, natural ingredients. Its butter-fat...
-
Suppose it costs each subsidiary 1 percent of the transaction amount each time it converts its home currency into another currency to pay its suppliers. Develop a strategy by which BLP as a...
-
Fill in the Blank. The response of a system to suddenly applied nonperiodic excitation is called ___________ response.
-
Design a piston-cylinder-type viscous damper to achieve a damping constant of \(175 \mathrm{~N}-\mathrm{s} / \mathrm{m}\) using a fluid of viscosity \(35 \times 10^{-3} \mathrm{~N}-\mathrm{s} /...
-
No summer romances are banal pastimes. Therefore, it is false that some summer romances are banal pastimes. Use the modified Venn diagram technique to determine if the following immediate inferences...
-
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?
-
Thunderhorse Oil. Thunderhorse Oil is a U.S. oil company. Its current cost of debt is 7.30%, and the 10-year U.S. Treasury yield, the proxy for the risk-free rate of interest, is 3.80%. The expected...
-
Ray closed his auto repair business last October. In January he joined RDX Repair Shop as a general partner. His only contribution to RDX is a pickup truck he used 100% for business. He purchased the...
-
Cori's Dog House is considering the installation of a new computerized pressure cooker for hot dogs. The cooker will increase sales by $7,900 per year and will cut annual operating costs by $14,000....
Study smarter with the SolutionInn App