Question 1 Caterine is a food caterer that offers two types of buffets: fixed preselected dishes or dishes chosen from various item categories. Both types of buffets come with different number of dishes with a choice of delivery. An example of a buffet with fixed preselected dishes is Molto delizioso. It consists of 5 dishes: spaghetti aglio olio, lemon buttered prawns, vegetable salad, chocolate clair and tropical fruit platter. Buffets with fixed preselected dishes have fixed size portions. For example, Molto delizioso comes in portions for 10 persons at the cost of $218 whereas another buffet Delectable Tea has 7 dishes in portions for 15 persons at the cost of $168. Add-on dishes are available only to some buffets with fixed preselected dishes. For example, one pizza and ten croissants can be added to Molto delizioso at a cost of $28 and $15 respectively. Pizza or croissants, however, may not be available as an add-on dish for Delectable Tea or they may possibly be available at a different cost and/or quantity. Some buffets with fixed preselected dishes are not entitled to any add-on dishes. For a buffet with choices, the cost is per person with a minimum required number of persons. The dishes available to each buffet are categorised, and a customer can choose one dish in each category. Note that a dish may appear in only one category for a buffet but may appear in a different category for a different buffet. A buffet with choice dishes is not entitled to any add-ons. Each dish (e.g., spaghetti aglio olio) can be part of a buffet and/or it can be an add-on dish. It has a code, a name. In addition, other details about it may be recorded such as whether it is a popular choice, a chef recommendation or is spicy. Customers must be registered before they can place order for either of the two types of buffets. Details such as their contact, name and email are recorded. Each order has a unique order number. The date and time ordered and the date and time the dishes should be ready by are also recorded. If delivery is required, a delivery order records the address to deliver to and the delivery charges. A delivery order is identified by a delivery id.

If a buffet with choice dishes is ordered, e.g., Local Favourites the buffet which has a choice of 6 dishes from 6 categories, the customers choices must be recorded, together with the number of persons the buffet is ordered for. In addition, special requests can be made for each dish chosen, e.g., less salt and more spicy. If a buffet of fixed dishes is ordered, and there are add-on dishes that the buffet is entitled to, and if the customer chooses to add dishes to the dishes in the buffet, then the add-on dishes must be recorded. Over time, Caterine does make changes to the delivery charge, the prices of add-on dishes and the buffet charge per person. It is necessary to record the cost of each order, including add-on dishes, delivery charges etc., if applicable, to account for the amount collected for each order.

Construct a conceptual (ER) model from the statements of requirements. In your ER model, provide the relevant entities, with entities name, relevant attributes and identifier, (7 marks) relationships with maximum and minimum cardinalities and relationship name (13 marks)