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: 83% (6 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...
-
An organization monitors many aspects of elementary and secondary education in a very large country. Their 2000 numbers are often used as a baseline to assess changes. In 2000, 36% of students had...
-
Go to the Ernst \& Young Web site (https://www. ey.com/Publication/vwLUAssets/ey-worldwide-transfer-pricing-reference-guide-2018-19/\$FILE ley-worldwide-transfer-pricing-reference-guide-2018-19.pdf)...
-
Beale Management has a noncontributory, defined benefit pension plan. On December 31, 2011 (the end of Beale's fiscal year), the following pension-related data were available: Required: 1. Prepare...
-
How do you define a healthy marriage or permanent committed relationship? What are your spiritual beliefs about marriage? What are your thoughts about monogamy? Since marriage is not the only form of...
-
For each of the following, review the data in the images below and identify the (1) delimiter and (2) the qualifier (if applicable). Is an asset ID a good data field to use as a unique identifier in...
-
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,...
-
Determine the product of inertia of the area with respect to respect to the x and y axes, and then use the parallel-axis theorem to find the product of inertia of the area with respect to the...
-
Compute the following probabilities: a. If \(Y\) is distributed \(N(1,4)\), find \(\operatorname{Pr}(Y \leq 3)\). b. If \(Y\) is distributed \(N(3,9)\), find \(\operatorname{Pr}(Y>0)\). c. If \(Y\)...
-
A solenoid can be treated as a series \(R L\) circuit. If such a cylindrical solenoid driven by a \(60-\mathrm{Hz}, 120-\mathrm{V} \mathrm{AC}\) source has 1200 turns of \(2 \mathrm{~cm}\) radius...
-
An \(R L C\) series circuit consists of a \(450-\Omega\) resistor, a \(3.00-\mathrm{mF}\) capacitor, and a \(1.00-\mathrm{H}\) inductor. The circuit is driven by a power source that oscillates at...
-
A light ray travels through medium 1 , index of refraction \(n_{1}=1.1\), into medium 2, index of refraction \(n_{2}=1.5\) (Figure P33.55). At what angle with respect to the normal to the interface...
-
A schematic diagram of a refractive microscope is shown in Figure P33.74. The focal length of the objective lens is \(25 \mathrm{~mm}\), that of the eyepiece lens is \(63 \mathrm{~mm}\), and the two...
-
No flower gardens are creations that feature skunkweed. Therefore, it is false that all flower gardens are creations that feature skunkweed. Use the modified Venn diagram technique to determine if...
-
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?
-
On May 13, 2015 the treasurer of a corporation might enter into a long forward contract to sell 100 million in six months at an exchange rate of 1.5736 This obligates the corporation to pay 1 million...
-
Problem 6-20 Inflation and Company Value Sparkling Water, Incorporated, expects to sell 3.7 million bottles of drinking water each year in perpetuity. This year each bottle will sell for $1.46 in...
-
evaluate email to my supplier: Regarding the NRE rework amount on the PSA, we appreciate your diligence in spotting the discrepancy. We agree with your proposal to redline the NRE Rework line in the...
Study smarter with the SolutionInn App