Answer
PET table has better design because it contains an ID column, which can be used as Primary key to create relations. None of the columns in PET_2 table enforce uniqueness.
Work Step by Step
No steps
Database Concepts
by Kroenke, David; Auer, David;
Published by
Pearson
ISBN 10:
0133544621
ISBN 13:
978-0-13354-462-6
Chapter 3 - Structured Query Language - Figure 3-18 - Pet_Owner Data - Page 213: 3.12
Update this answer!
You can help us out by revising, improving and updating this answer.
Update this answerAfter you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.
