Q1) Use the following tables for your answer to the question below:

PET_ OWNER ( OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)
PET ( PetID, PetName, PetType, PetBreed, PetDOB, OwnerID) Sample data for these tables are shown in Figures 3-15 and 3-16 on page 181 of your textbook. 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. Name your database Pet- Database. 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 on pages 110 and 111 of your textbook.

Write an SQL CREATE TABLE statement to create the PET table without a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT NULL? Write SQL Statements to insert the data in Figure 3-16 on page 181 of your textbook into the PET table.