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
