1. The ReallyGoodRestaurant has decided to open a small shop beside the restaurant to sell high quality artisan cooking ingredients. The restaurant uses several suppliers to provide good ingredients. Each supplier supplies an ingredient in only one unit size e.g. supplier A supplies sea salt in bags of 500 grams and supplier B supplies sea salt in 250 gram bags. Each supplier charges a specific price for an ingredient in that unit size. However different suppliers can provide the same ingredient in different unit sizes. Also to encourage the sale of these ingredients, the restaurant provides a text description of the recipes used in the restaurant and indicates which ingredients from each recipe can be bought from the shop. Each recipe has been designed by one or more chefs in the restaurant. The ReallyGoodRestaurant needs to maintain a database capable of storing information about ingredients, the suppliers of those ingredients, the unit size that each supplier supplies a particular ingredient, a text description of each recipe, the name(s) of the chef(s) who designed each recipe, an indication of which ingredients are used in which recipes, the cost (to the restaurant) of ingredients in a particular unit sizes from suppliers, and the price for which the shop sells each ingredient (in a particular unt size). (i) Develop an Entity Relational (ER) Model for the above database, stating any assumptions you make. (ii) Using the appropriate mapping techniques, map the ER Model to a Relational Model and show the functional dependency between attributes within each table. In your answer, identify the Primary and Foreign keys for each relation.