Your team is to design a relational database for an online pizza service. Customers log on to the site and provide their first and last names, address, telephone number, and email address. They order pizza from a menu. Assume that each item on the menu has a unique number, a description, and a price. Assume there is one person per shift who receives orders and handles them, from giving the order to the kitchen to dispatching a delivery person. The system automatically records the time at which the server picked up the order. The business wants to maintain the details of customers, including their orders of the past six months. The following are reports that management might require: (1) a list of all the orders handled by a server over a period of time; (2) summaries of total sales, by item, for a period; and (3) a report showing all of the past week’s deliveries by server, showing each individual order—customer last name and address, items ordered, time of order pickup, and last name of delivery person. (You can assume the last names of delivery people are unique, because if there is more than one with the same last name, a number is added to the name.)

a. Chart the table for each entity, including all its fields and the primary key.

b. Draw the entity relationship diagram.