Sql server

1. Each time a new state is added or updated in the States table verify that the StateCode follows this pattern - First 5 character same as the StateName followed by the number of characters in the state name

for example

Washington code will be 'WASHI10'

Alabama code will be 'ALABA10'

California code will be 'CALIF6'

2. Create a function that takes Property name as input and returns a list of all the recipes that have that property.

3. Category Name and Property Name cannot be same. Every time a new category name is added or updated check if the same category name is listed as a property name. Similarly, every time a new property name is added or updated check if the same property name is listed as a category name.

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