REA DIAGRAMMING: Joes Ristorant

Joes Ristorant is a small restaurant near a college campus. It serves both lunch and dinner from a standard menu. It also has a salad bar. Staff take orders by writing down the orders on an order pad. The orders are then taken to the kitchen where the food is prepared. When the food is ready, the staff are notified and deliver the food to the customers table. When the meal is finished, the staff provide customers with a bill, which has been prepared by hand. All sales must be paid by cash or credit card and entered into the cash register. Joe maintains one checking account for all sales receipts.

Required:

Create an REA diagram for Joes order-taking and cash receipts process, including all relationships.

List the tables and attributes, including the primary key needed to implement the data model in a relational database.