Create a Class Library project for the middle tier of your $3-$Tier application.

a$.$ Add models for Pet and the Species Lookup values.

$$ Your Pet model should be based on the View created in Lab $4$ so it can work

with your Select stored procedures.

b$.$Add Interfaces and Repositories for both Models:

$$ For Species, you just need to return a collection suitable as the data

source for a combo box.

$$ For Pet, you need methods for:

$1.$ The $5$ Standard Stored Procedures for the PET table. Don$$t forget about

concurrency on Update.

$2.$ The $$SelectByX$$ stored procedure.