SQL

1. Every time a Recipe is changed (For an existing recipe new ingredient is added, or the Qty of an existing ingredient is changed), record this in audit table. Also, update the Recipe date in the Recipes table.

2. Create indexes for all the tables, which might benefit from indexing. The way the application is used is searching by Category Name, Property Name, Ingredient Name, Recipe Name, Recipe Creator and Recipe Name.

3. Create a view listing the Recipe Name and the number of ingredients used for that recipe.

Reclnads RecipePropertv Property Ingds ProplD PropertyName RID 7 Ingdld Ingdld ProplD Mesurld IngdName Qty Persons Person!D FirstName LastName AddressID Recipes RID RName Mesmts RecipeOwners person!D Mesurld RecipeDate MDesc RID Addresses Address!D StAddress City StateCode Zip States RecipeCats RID CID StateCode StateName Categories CatName