Write an SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is

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

image

image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Concepts

ISBN: 978-0133544626

7th edition

Authors: David M. Kroenke, David J. Auer

Question Posted: