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)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
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 the full answer
Answered By
Rayan Gilbert
I have been teaching since I started my graduation 3 years ago. As a student, working as Teacher/PA has been tough but made me learn the needs for student and how to help them resolve their problems efficiently. I feel good to be able to help out students because I'm passionate about teaching. My motto for teaching is to convey the knowledge I have to students in a way that makes them understand it without breaking a sweat.
1+ Reviews
10+ Question Solved
Related Book For 
Question Posted:
