Use the following tables for your answers to questions 3.7 through 3.51: PET_OWNER (Own...

Use the following tables for your answers to questions 3.7 through 3.51:

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

PET (PetID, PetName, PetType, PetBreed, PetDOB, OwnerID)

Sample data for these tables are shown in Figures 3-18 and 3-19. For each SQL statement you write, show the results based on these data.

If possible, run the statements you write for the questions that follow in an actual DBMS, as appropriate, to obtain results. Use data types that are consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types by using either the SQL Server, Oracle Database, or MySQL data types shown in Figure 3-5.

The following table schema for the PET_2 table is an alternate version of the PET table— use it to answer review questions:

PET_2 (PetName, PetType, PetBreed, PetDOB, OwnerID)

Write the required SQL statements to create the PET_2 table.