Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
4. The AdoptivePerson table


Now we have the last table, AdoptivePerson. It stores information about people who pay for the care of certain animals at the zoo.


Select all the information from the AdoptivePerson table. You'll find the following columns:

  • Id—uniquely identifies each adoptive person in the database.
  • FirstName—the first name of the adoptive person.
  • LastName—the last name of the adoptive person.
  • City—the city where this person lives.
  • AnimalId—refers to the Animal table and shows which animal this person has donated money for.