Write a SQL CREATE TABLE statement to create the PET tablewithout a referential integrity constraint on OwnerID

Question:

Write a SQL CREATE TABLE statement to create the PET tablewithout a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT NULL??

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

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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database Concepts

ISBN: 978-0133544626

7th edition

Authors: David M. Kroenke, David J. Auer

See More Books

Question Posted: Mar 13, 2020 12:05 PM

See More Questions

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should cascade PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,...
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 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,...
18. Equal volumes of two solutions containing 3.65g of HCl and 4.0 g of NaOH respectively are mixed. The pli of the mixture is 2) <7 3) >7 19. When Imi of 0.IN HCIIS added to 1 litre of a solution of...
Consider taking a random sample of size 10 from the population of students at a certain college and asking each of the 10 students whether or not they smoke. In the context of this setting, explain...
Suppose a 10-year, 10% semiannual coupon bond with a par value of $1,000 is currently selling for $1,135.90, producing a nominal yield to maturity of 8%. However, the bond can be called after 5 years...
A fair coin is tossed three times, and the events A and B are defined as follows: A: {At least one head is observed.} B: {The number of heads observed is odd.} a. Identify the sample points in the...
A company must decide whether to buy Machine A or Machine B: At a 10% interest rate, which machine should be installed? Use an annual cash flow analysis in working this problem. Machine A Machine B...
Northwood Company manufactures basketballs. The company has a ball that sells for $ 2 5 . At present, the ball is manufactured In a small plant that relies heavily on direct labor workers. Thus,...
3. Andi and Brandon contribute to a public good they both enjoy. Let a denote a contribution by Andi, b a contribution by Brandon. Andi and Brandon may choose any nonnegative contribution levels....
John R. Lane (SSN 111-44-6666) lives at 1010 Ipsen Street, Yorba Linda, California 90102. John, a single taxpayer, age 66, provided 100/c, of his cousin's support. The cousin lives in Arizona. He...
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,...
On July 1, 2019, Katrina purchased tax-exempt bonds (face value of $75,000) for $82,000. The bonds mature in five years, and the annual interest rate is 3%. a. How much interest income and/or...
Here are summary statistics for randomly selected weights of newborn girls: n = 36, x = 3180.6 g, s = 700.5 g. Use a confidence level of 99% to complete parts (a) through (d) below. a. Identify the...
2. (10 points) Two suppliers of products are available to supply the needs of four supermarkets. Each supplier can provide 90 units per day. Each supermarket would like to receive 60 units per day....
QUESTION 3 (11 marks) Midrand Ltd acquired a 90% interest in Bramely Ltd on 2 December 20.21 for R2 million. The consideration was settled as follows: Cash payment, Issue of 100 000 shares to the...
1. Prepare a Proforma Income Statement for ACCO 295 Corp. (30 points) Use the same Excel table provided to do the calculations with the class explanation. 1. Selling and administrative expenses were...
Sandy Foot Hospital expanded their cardiovascular unit to include more operating rooms. They negotiated a 20-year loan with monthly payments and a large sum of $250,000 due at the end of the loan....
Write code to declare an ArrayList holding the first 10 multiples of 2: 0, 2, 4,..., 18. Use a loop to fill the list with the proper elements.
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
What is the Microsoft.NET Framework? What basic elements does it include?
What are the two tasks to be accomplished when setting up an ODBC data source name?
Which data source type is recommended for Web servers?
NRG Inc. currently has $422 million of debt outstanding. It's cost of debt is 4.1% and its marginal corporate tax rate is 25%. Estimate the tax shield for NRG at the end of the year (don't calculate...
In early 2020, the risk-free rate was .10% and Tesla (TSLA) traded for 524 USD. In one month, TSLA could have either gone up to 576.4 USD or down to 471.6 USD. Suppose you went short a 530.13 USD...
An investment costs $100,000 and provides a cash inflow of $17,000 per year. If the discount rate is 13%, how long must the cash inflows last for it to be an acceptable investment? a) 24 years b) 12...

Write a SQL CREATE TABLE statement to create the PET tablewithout a referential integrity constraint on OwnerID

Question:

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 Answer:

Creating the PET table Assumptions PetID is a surrogate keystarts at 1 and increments by 1 For Microsoft Access Create PetID as NOT NULL and then set the data type to AutoNumber in the GUI IMPORTANT D...View the full answer

Database Concepts

Students also viewed these Computer science questions