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.

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)

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

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 Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Concepts 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,...

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

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

Database Structures SQL Write SQL code to complete the following (create and insert data into the following tables) and run the code in MS SQL SERVER to get practice using the command line and...

Write SQL code to complete the following (create and insert data into the following tables) and run the code in MS SQL SERVER to get practice using the command line and getting syntax errors. You can...

Data integrity refers to the accuracy of data. If the data that an organization relies on to make decisions does not have integrity, then the organization cannot make good decisions that impact the...

Use the following tables and sample data for your answers to the questions in this assignment. (Please note that the tables have already been normalized.) Use MS SQL Server Management Studio to write...

Prove that if {an} converges and {bn} diverge then {an + bn} diverge?

1. What is a Riemann sheet (define it, and detail its properties) 2. Describe the Riemann sheet of G(z) = ln(z). 3. Describe with a figure and then discuss the branch cut for f(z) = log(z). 4....

Which of the following is a shorthand notation for programming which uses a combination of informal programming structures and verbal descriptions of of code

A taxpayer sold a piece of real property in year 1. The amount of year 1 real property taxes was estimated at the closing of the sale and the amounts were allocated between the buyer and the...

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?

You Want to sell your house. Comparable houses in the neighborhood have sold in a range from $220,000 to $260,000. You think that the market value for your house is $250,000 and you put an add on...

Sheridan Company manufactures and sells two products. Relevant per-unit data concerning each product follow: Product Basic Deluxe Selling price $40.00 $52.00 Variable costs $18.00 $27.50 Machine...

The net preseat value (NPV) method estimates how much a potential project will contribute to the more value the project adds; and added value means a stock price. In equation form, the NPV is defined...