Use the following tables for your answer to the problem 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 prepare, show the results based on these data. If possible, run the statements you prepare for the problems 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.
prepare 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? prepare SQL Statements to insert the data in Figure 3-16 on page 181 of your textbook into the PET table