Answer Happy

Question 2: ER Modeling (12 marks) You are required to design the database for a pizza restaurant with the following requirements. Registered customers (identified by cid, with cname, and address as attributes) can order pizzas by phone. Each order (identified by oid, with payment as attribute) consists of one or more pizzas (identified by pname, with size as attribute). Each order is delivered by an available driver (identified by did, with phone as attribute). An order must be made by a single customer. A customer can make more than one order, and you need to record when each order is made. Draw an ER diagram that captures the above information. Use ER modeling constructs, such as keys, participations, weak entities, as appropriate.