Complete the problem for an SQL database and write the SQL stored procedure as defined in the problem:
2. Consider the Seasoned Steak 'n Side restaurant with the small selection of specially designed dinners, each of which included a specially seasoned main course specially seasoned side dish and just the right wine You recall that the chef sommelier has rules regarding side dishes and wine can be served in the same meal as the main dish. Consider the following 4NF database the dependencies MAIN DISH Salmon Steak Salmon Steak Beef Steak Beef Steak Baked Chicker Baked Chicken Grilled Pork Chop Potato Salad SIDE DISH Mashed Potatoes White Rice Baked Potato Mashed Potato Mashed Potatoes MAIN DISH Salmon Steak Salmon Steak Beef Steak Beef Steak Baked Chicken Chardonnay Baked ChickenPinot Grigio Grilled Pork Chop Beaujolais Grilled Pork Chop Chardonnay WINE Pinot Grigio Chardonnay Cabernet Sauvignon Pinot Noir Sweet Potato Each day, the chef sommelier decides on a new menu to offer customers. The menu lists up to 10 meal combinations contain one main dish, one side dish and one type of wine. For example, one day's menu might look as follows WINE MAIN DISH SIDE DISH Salmon Steak Mashed Potato Pinot Grigio Salmon Steak White Rice Beef Steak Beef Steak Baked Potato Cabemet Sauvignon Beef Steak Mashed Potato Cabernet Sauvignon Beef Steak Pinot Grigio Baked PotatoPinot Noin Mashed Potato Pinot Noin a. Write a stored procedure that will accept a main dish, side dish and wine combination for the menu and reject any combination that violates a multivalued constraint b. Write a PHP program that i. lets the user create a new table for the day and enter valid meals ii. lets the user add meals to the table ili displays the current table each time a new meal is added 2. Consider the Seasoned Steak 'n Side restaurant with the small selection of specially designed dinners, each of which included a specially seasoned main course specially seasoned side dish and just the right wine You recall that the chef sommelier has rules regarding side dishes and wine can be served in the same meal as the main dish. Consider the following 4NF database the dependencies MAIN DISH Salmon Steak Salmon Steak Beef Steak Beef Steak Baked Chicker Baked Chicken Grilled Pork Chop Potato Salad SIDE DISH Mashed Potatoes White Rice Baked Potato Mashed Potato Mashed Potatoes MAIN DISH Salmon Steak Salmon Steak Beef Steak Beef Steak Baked Chicken Chardonnay Baked ChickenPinot Grigio Grilled Pork Chop Beaujolais Grilled Pork Chop Chardonnay WINE Pinot Grigio Chardonnay Cabernet Sauvignon Pinot Noir Sweet Potato Each day, the chef sommelier decides on a new menu to offer customers. The menu lists up to 10 meal combinations contain one main dish, one side dish and one type of wine. For example, one day's menu might look as follows WINE MAIN DISH SIDE DISH Salmon Steak Mashed Potato Pinot Grigio Salmon Steak White Rice Beef Steak Beef Steak Baked Potato Cabemet Sauvignon Beef Steak Mashed Potato Cabernet Sauvignon Beef Steak Pinot Grigio Baked PotatoPinot Noin Mashed Potato Pinot Noin a. Write a stored procedure that will accept a main dish, side dish and wine combination for the menu and reject any combination that violates a multivalued constraint b. Write a PHP program that i. lets the user create a new table for the day and enter valid meals ii. lets the user add meals to the table ili displays the current table each time a new meal is added
