Wildcat Pizza, a walk-in restaurant located off of State Highway 6, has been in business for 40 years selling their famous ground shorthorn pizza to the community. Customers use a combination of hand signals and yells to place their orders. Wildcat Pizza offers three pizza toppings (pepperoni, ground pork, or ground shorthorn) and three pizza sizes (thin, thick, or pan). Cheese is included on all pizzas.

A Wildcat employee, called a Fish, handles all orders. When an order is placed, the Fish records the order on a cook sheet and then returns a confirming hand signal and yell to let the customer know the order was properly received. The cook sheet contains the following information: customer name, customer address, customer phone number, date, order#, employee name, product description, quantity ordered, price, extended price, subtotal, tax, and total due.

In the confirmation hand signal and yell, the Fish repeats the order, then gives the customer an invoice/receipt, along with a confirmation number (order#). This form is a duplicate form that contains information regarding the customer and the order, including the total amount due. Customers must pay for the pizza at the time of ordering. After the Fish receives cash from the customer, the customer signs the invoice/receipt form. One copy is left with the customer as a cash receipt, while the other copy is retained by the Fish as a record of the customer’s payment. The Fish then files the retained copy of the customer invoice/receipt and puts the monies received in the cash register. Payment information from the invoice/receipt forms is used to verify the amount of money returned to the register by the Fish.

Because Fish aren’t allowed the privilege of touching the pizza, the completed cook sheets are sent to the Yell Leader, a cook, who then prepares the pizza. When the pizza is ready, the Yell Leader drums Hullabaloo, Whoops to signify the order is ready, and yells out the order number. When the customer hears their order number called, they pick up their pizza.

At the end of each month, a pizza report is sent to Wildcat management. The pizza report summarizes pizza sales for the month. Wildcat management uses the information from the Pizza Report to determine periodic price changes for Wildcat products.

You have been asked by Wildcat Pizza to create a system that will allow them to capture all information about pizza sales. The new system will allow management of Wildcat Pizza to keep track of customers, the pizzas that are sold, and the money that is collected from pizza sales.

Additionally, Wildcat management has been wanting to implement a customer referral discount, whereby any customer who states that they were referred by another customer will earn the referring customer a $5.00 discount off their next order. However, the management wants to limit this discount such that it can only be claimed up to 5 times per customer. The system that you design should facilitate this discount process.

Questions:

1.Create a legible conceptual data model and draw its ERD. Your conceptual data model should include all entities, attributes, relationships, and cardinalities (max and min). Be sure to document any assumptions you make regarding your conceptual data model.

2.Create a logical data model in 3NF using relational schema notation. You must include referential integrity arrows in your logical data model. The logical data model should be consistent with your conceptual data model (i.e., all names must be identical, and all transformation rules should be followed). Be sure to document any assumptions you make regarding your logical data model.