Using the SQL Emulator prepare SQL statements to perform the following tasks. Each task is worth 10 points. For all tasks show a screenshot of what the emulator provided (i.e., The Red Box). Place each screenshot within a single Word document indicating what task you are answering. If you are unclear as to what is required, please review the Answer Example provided.

For Tasks 3-6, please provide BOTH the SQL used to make the change (a screenshot of the Red Box) and Confirm the change by showing the resultant Table (another screenshot of the Red Box).

Tasks:

1. (10 points) Using the SQL Emulator Create a Table named Type (case counts). Use the Table below for the column specifications. Your answer should include a screenshot of what the emulator provided (The Red Box).

Column Name	Column Type	Primary Key	Not Null	Comment
TypeID	Integer	Yes	Yes	Pet type identifier. The highest type id will be 99.
Food	Maximum of 20 characters	No	Yes	Type of food
CageSize	Exactly 1Character	No	Yes	Size of cage for this pet type
WaterBowlSize	Exactly 1 Character	No	Yes	Size of water bowl
FoodBowlSize	Exactly 1 Character	No	Yes	Size of food bowl
NeedsWalk	Exactly 1 Character	No	Yes	Y if this type of pet needs to be walked
NeedsLitter	Exactly 1 Character	No	Yes	Y if this type of pet needs litter
NeedsLiner	Exactly 1 Character	No	Yes	Y if this type of pet needs a cage liner