Question: 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,

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, 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.38 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Assumptions OwnerID is a surrogate key starts at 1 and increments by 1 For Microsoft Access The Microsoft Access AutoNumber data type only supports a starting value of 1 and an increment of 1 See Does ... 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!

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...

Write an SQL statement to display the PetBreed column of PET. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET ( PetID , PetName, PetType, PetBreed, PetDOB,? OwnerID )...

Write an SQL CREATE TABLE statement to create the PET_OWNER table, with OwnerID as a surrogate key. Justify your choices of column properties.

Write an SQL statement to drop the PetWeight column you added to the PET table in either question 3.47 or 3.49. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (...

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...

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...

Figure 3 - 2 8 : BITM 5 2 0 - Project 4 Submit either an access database with each of your queries numbered in the database or submit a Word document with the query syntax. You will be graded 1 pt...

Blow You Away, Ltd., operates a line that produces ceiling fans. This line consists of single-machine stations and is almost balanced (i.e. station rates are nearly equal). A manufacturing engineer...

Information: November 01 08 12 19 22 28 TRANSACTIONS Opening inventory Purchased from supplier Issued to production Returned to supplier Purchased from supplier Issued to production NUMBER OF UNITS...

in units of production depreciation the depreciation rate is calculated as . . . a . ( axuisition cost - residual value ) / total estimated units of production

In what circumstances is the IRS method for allocating expenses between personal use and rental use for second homes more beneficial to a taxpayer than the Tax Court method?

What disadvantage of ODBC does OLE DB overcome?

Why is OLE DB important?

What is the current version of the .NET Framework, and what new features does it include?

Question 1 9 of 3 5 George invested his savings in shares of a new company. The company's share price dropped by $ 2 . 2 5 at the end of the first year, and by a further $ 2 . 7 5 at the end of the...

Regarding Harvard business school case 'The B.F. Goodrich-Rabobank interes trate swap' is someone can answer below question? 5. Goodrich a. Compare 30-year fixed rate in the US market and the fixed...

Judy Johnson is choosing between investing in two Treasury securities that mature in five years and have par values of $1000. One is a treasury note paying an annual coupon of 5.06 percent. The other...