In this assignment you will create views against the $3060$AnimalAttack database and store then in your database. To view the tables and data in you can login and do queries on the database using this account:

Login ID: $3060$AnimalAttackLogin

Password: BagelBites$449!$

To Create Views:

Use YOUR credentials to login to SSMS$.$

Create a new view in your database using the View Designer.

Expand your database, right click on the Views folder, and select New View.

You can then open the $3060$AnimalAttack database in the Object Explorer window.

You can now drag tables from the $3060$AnimalAttack Database into the View Designer as you need them to create views.

What You Will Submit

For each view, take a screenshot of your view code and a screenshot of the results once you run your view. Put your screenshots in a Word document and label them appropriately.

Views to Create:

How many types of First Aid are on file? Name this view vView$01$ and add on your initials $($For example: mine would be vView$01$kh$).$

What pets are not regulated by a government regulatory agency? List in ascending alpha order. Name this view vView$02+$ your initials.

List all the pets and the food they eat, in ascending alpha order by Pet and Pet Food. Name the view vView$03+$your initials.

List all the pets that have bitten, in ascending alpha order. Don$$t duplicate pets. Name the view vView$04+$ your initials.

List the number of attacks per year and the year, in ascending order by year. Name the view vView$05+$ your initials.