Write a SQL CREATE TABLE statement to create the PET_OWNER table, with OwnerID as a surrogate key.

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