nees help answering questions 1-4. Using Microsoft Server SQL 2017

1. (Screen shot Create the tables and appropriate constraints based on the following ER diagram. Use appropriate data types and sizes (see Chapter 8). The database is for a family-owned restaurant. 2. a. Note that the serving Temperature column should only accept the letters H, C, or W (for Hot, Cold, Warm). b. The price column should only have values greater than zero c. All columns in both tables are required d. The CID and PID columns should have the IDENTITY property. e. Show the code in two separate screen shots, one for each table. Category CID Description Product PID CID (ik) Price Temperature (H/C/w) 3. (Screen shot.) Create a non-clustered index on the foreign key of the Product table 4. (Screen shot.) Modify the Product table to add a column named Gluten Free that allows only 1 letter. Include a 5. Demonstrate that you did the following (use a SELECT statement to show the records in the table): check to make sure the value is a Y or N. Make the default value of the column N a. (Screen shot) Insert 3 rows in the Category table i. Appetizer ii. Entree ii. Dessert b. (Screen shot(s)) Insert 3 Product records for each category in the product table. i. Bananas Foster, Dessert category. $6.99, Hot, Y i. Molten Lava Cake, Dessert category, $5.99, Warm, N ili. Key Lime Pie, Dessert category, $4.50, Cold, N iv. Ribeye Steak, Entree category, $16.99, Hot, Y v. Chef Salad, Entree category, $8.99, Cold, Y vi, Fettuccini Alfredo, Entree category, $12.99, Warm, N