Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 1 - Getting Started - Review Questions: 1.9

Answer

The main achievement here is, we removed redundancy in table OWNERS. In the newly created OWNERS table, you can see there is one record for Marsha Downs and Richard James, even though they both have more than one pet. 1) Owner information can be changed by modifying just a record in the OWNERS table, You need not add a new record in OWNERS table if you want to add a new pet for an existing owner 2) Changing pet information no longer affects the OWNERS table, and changing Owner information does not affect PETS table either 3) The owner can be added without the pet being added to the table.

Work Step by Step

N/A
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

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