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)
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: 80% (5 reviews)
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
Answered By
OTIENO OBADO
I have a vast experience in teaching, mentoring and tutoring. I handle student concerns diligently and my academic background is undeniably aesthetic
4.30+
3+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science 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...
-
In Part Two, you covered a wide range of systems analysis methods in seven chapters, Again, reread the introduction at the beginning of Part Two; then list what resonated the most for you in each...
-
One critical-thinking skill is a heightened awareness of the danger of reaching a conclusion prior to acquiring missing information that were it known would have a reasonable probability of altering...
-
The beginning inventory of merchandise at Francesca Co. and data on purchases and sales for a three-month period are as follows: Instructions 1. Record the inventory, purchases, and cost of...
-
Find a big-O estimate (in terms of n) for the run-time of the code given below. m+0 for i1 to n forji i to n * n m+i+j (b) i1 while i n j <1 while j i jj+1 i+i+1 Activate Go to Setti
-
Chicken is a game played by two macho (i.e. stupid) teenagers who are attempting to prove who is the coolest (dumbest), basically they drive full speed at each other (head-on) on a narrow road and...
-
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,...
-
A 10 000-N shark is supported by a cable attached to a 4.00-m rod that can pivot at the base. Calculate the tension in the tie-rope between the rod and the wall if it is holding the system in the...
-
Unheardof, Inc., has just paid a dividend of $5 per share. This dividend is anticipated to increase at a rate of 15% per year. If the cost of equity for Unheard of is 25%, what should be the market...
-
Parker Company has the following ledger accounts and adjusted balances as of December 31, 2017. All accounts have normal balances. Parkers income tax rate is 20%. Parker has 300,000 shares of Common...
-
A hotel on the Gold Coast has quoted you a gross rate of $1,740 for six nights for the Kaur family. Your organisation receives a 10% commission on any bookings. Calculate the commission you will earn...
-
If a bond pays $1500 in one year and $2500 in two years, its present value is $2800. Find the interest rate which equates the price of the bonds with the discounted future values. [Hint: Consider...
-
Florence Flowers Unlimited is developing its Budgeted Balance Sheet to help it plan for the upcoming year. In setting up their Assets section, they find the following information: Raw Materials...
-
Wilton Corporation has a single class of common stock outstanding. Robert owns 100 shares, which he purchased in 2007 for $100,000. In 2013, when the stock is worth $1,200 per share, Wilton declares...
-
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?
-
A 2.00 kg box is suspended from the end of a light vertical rope. A time-dependent force is applied to the upper end of the rope, and the box moves upward with a velocity magnitude that varies in...
-
Vector C has a magnitude of 21.0 m and points in the -y- direction. Vectors A and B both have positive y-components, and make angles of a = 43.9 and = 25.7 with the positive and negative x-axis,...
-
Jacarda Company makes a composting bin that is subject to wide seasonal var a quarterly basis by dividing each quarter's manufacturing costs (materials, labour, and overhead) by the quarter's...
Study smarter with the SolutionInn App