Question: Write an SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will

Write an SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Assume, however, that you have only LastName, FirstName, and Phone and that therefore Email is NULL. Use the last three lines of the data provided in Figure 3-19.

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 4 Trent Miles Miles.Trent@somewhere.com

Step by Step Solution

★★★★★

3.52 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

NOTE If you are inserting data into Microsoft Access tables with an AutoNumber surrogate key or into MySQL tables with AUTOINCREMENT you have to list ... 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 statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key, and that the DBMS will provide a value for it.Use the first three lines of data provided in...

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

Write an SQL statement to display the last name, first name, and email of any owners of cats. Use a subquery. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET ( PetID...

Write an SQL statement to add three new rows to the PET OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Assume, however, that you have only...

Write an SQL statement to add three new rows to the PET OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Use the first three lines of the data...

Write SQL statements to add these 3 new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and the DBMS will provide a value for it. OwnerID OwnerLastName OwnerFirstName OwnerPhone...

Part 1 Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons. books ( book_id int, title varchar(20), author_last_name...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

have the value Junior. Write SQL statements to insert the data into each of the five Garden Glory Database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in...

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

Vaughn report the Following results from the sale of 5000 units in May sales of 390000 variable cost $270,000 fixed cost $90,000 and net income 30,000 assume that Vaughn increase the sales price by...

af Let the functions and- be continuous in some rectangle a

Glucagon increases blood glucose because it causes hypersecretion of cortisol stimulates cells to take in insulin stimulates the liver to convert glycogen into glucose increases water retention

Paris participates in her employers nonqualified deferred compensation plan. For 2016, she is deferring 10 percent of her $320,000 annual salary. Assuming this is her only source of income and her...

What is lock granularity? AppendixLO1

Explain the difference between an exclusive lock and a shared lock. AppendixLO1

Explain two-phase locking. AppendixLO1

Manitowoc Crane (A). Manitowoc Crane (U.S.) exports heavy crane equipment to several Chinese dock facilities. Sales are currently 12,000 units per year at the yuan equivalent of $23,000 each. The...

2. If you would like to retire with $2,000,000, what amount must you invest at the end of each year for the next 40 years if you can invest at 10% per year? If you invest at the end of each month for...

Which of the following guidelines are appropriate for inclusion in a portfolio management policy? I. Diversify among different types of securities and across industry and geographic lines. II ....