Smokey Pizza Assignment. This assignment may be completed on paper or with software. If you use paper, please photograph or scan your image into a pdf file for submission. Make sure the image is...

Smokey Pizza Assignment. This assignment may be completed on paper or with software. If you use paper, please photograph or scan your image into a pdf file for submission. Make sure the image is easily readable before submission. If you use software, print your solution to pdf for submission. You will need to both draw an REA model and extract the tables necessary to implement the model. The format for table presentation should be as illustrated in Table 20.1. Note there are columns for Table Name, Primary Key, Foreign Keys, and Other Attributes.


WOMPOM PIZZA SMOKEY PIZZA Smokey Pizza has been in business in Dubois, Wyoming since Butch Cassidy was a resident in 1890, selling their famous mutton and lamb pizzas cooked over the smoking desert sagebrush. In compliance with old traditions, customers send smoke signals to place orders for pizza. Each customer order can be for one or more pizzas and for more than one type of pizza. Each complete order is delivered by horseback the same day. Smokey never has a problem with incomplete orders because the ingredients it uses in its pizzas are readily available. Because Smokey is the only pizza business in Dubois willing to deliver, people are willing to wait for the pizzas to be delivered by horseback. Besides, whether the pizza is hot or cold the taste is the same. Smokey loves their horses and wants to make sure they don’t abuse them. Thus they track which horse delivered each order along with which employee is responsible for that horse. Each horse has one employee that is primarily responsible, but that employee can be responsible for many horses. Delivery riders give customers a copy of the order, which serves as a customer invoice. Smokey does not want its delivery riders to handle cash, so all sales are on account. Smokey sends a customer purchases report each week to headquarters that shows all pizza orders delivered. Each month Smokey Pizza headquarters in Lander mails customers a bill for all the orders delivered during the month. Payment in full is due by the 10th of the next month. Customers pay willingly so they can keep getting the best tasting mutton and lamb chip pizzas in the world. Smokey tracks each customer’s top three favorite pizzas in the database in order to notify them if Smokey is having a special on one of their favorite pizzas. Draw a Data Model using 3 events: Order, Delivery, and Cash collections. Also specify the tables needed to store the data for each resource, event and agent. Include in each table the Primary keys, Foreign keys, as well as the most important attributes.