​​​​MIS 310 – HW 2 As part of a Database implementation project, a pet company is planning to implement a system in 2015 using MS Access. For an initial prototype and demo, the project team (of which you are the lead) has been entrusted with the task of creating a database table, populating it with meaningful data and creating multiple queries to demonstrate the utility of the application. Complete the prototype based on the information given below: 1. [20] Write a SQL CREATE TABLE statement to create the PET table with the following fields, with appropriate data types, lengths and null/not null attributes: • PetID​​​​ • PetName​​​ • PetType​​​ • PetBreed​​​ • PetDOB​​​ • OwnerID​​​ Hint: Create Table ​ ( ​number not null, ​ ​char(40) ​….. ​); 2. [30] Use the INSERT INTO statement to populate the PET table with the following values from the table below: Hint: INSERT INTO VALUES ('value1', 'value2', 'value3',…..,'valuen'); 3. [50] Create the following business queries and name them as following: Query 1: Write a SQL statement to display all columns of all rows of PET. Do not use the asterisk (*) notation. Query 2: Write a SQL statement to display all columns of all rows of PET. Use the asterisk (*) notation. Query 3: Write a SQL statement to display the breed and type of all pets. Query 4: Write an SQL statement to display the PetBreed column of PET. Query 5: Write a SQL statement to display the PetBreed column of PET. Do not show duplicates. Query 6: Write a SQL statement to display the breed, type, and DOB for all pets having the type Dog and the breed Std. Poodle. Query 7:.Write a SQL statement to display the name, breed, and type for all pets that are not of type Cat, Dog, or Fish. Query 8: Write an SQL statement to display the Pet ID, breed, and type for all pets having a four-character name starting with K.