Thanks

IT 235 Final Project Scenario Cougar Pizza Pies is a new concept in pizza delivery. Dylan and Samanth a Morgan have been serving high-class pizzas for over 20 years but have decided to take a new direction with theirnext pizza concept. Instead of focusing on an ever-increasing variety of specialty pizzas, the Morgans have decided to turn the value concept toward the high-volume, late-night pizza-delivery business. Certainly, being close to Atlanta United University, home of the Cougars, and its 38,000 students provides a deep and growing marketfortheirbusiness. As such, the Morgans are creating Cougar Pizza Pies to sell and deliver pizzas only between midnight and 4:00 a.m. A view of the current competitive landscape shows that no other business is currently targeting that same market. The Morgans believe that the simplest business model will bring them the best success in theirdesired market. As such, the new restaurant will not have anyseating (as most orders will be delivered), butit will allow for pickup of pizzas if needed. It will also have a limited menu of pizzatypes (thin, regular, or pan) and a limited topping list (pepperoni, sausage, ham, and extra cheese) in ordertofacilitate the high sales volume expected. Also, to coordinate special instructions from customers (delivery access, cooking preferences, etc.), the Morgans would like to have an area where they can add customer notes to orders. Following theirsimplicity model, the Morgans have fixed their prices as follows: Thin and Regular Crust: $13.00 Pan Pizza: $15.00 Toppings: $2.00 each . . . Furthermore, for marketing outreach and research purposes, they would like to track orders by phone number, street address, city, state, and zip code The Morgans would like to determine and validate that their new business is profitable and business savvy. Thus, they have hired you to design a database that supports the validation of the late-night pizza-delivery business. Alongwith any considerations mentioned above, they know they need to be able to track the following details in a database: . Pizza orders, including toppings added Customerwho ordered pizza Address pizza was delivered to Name and phone number of employee who delivered pizza Name of employee who took pizza order .Salesperhour, day, week, and month .Delivery status details at various points in the night. Each order should have a status along with the order date and time and the delivery date and time. Note that if a customer picks up the pizza, the pickup time is the delivery time. Some otherconsiderations for the ordering process include the following: A customer can certainly order more than one pizza Customers move often and may orderfrom different locations (a friend's house, for instance) so address details may also change often. However, each customerwould have one prefe rred address Most orders need to be completed and delivered within an hour . . IT 235 Final Project Scenario Cougar Pizza Pies is a new concept in pizza delivery. Dylan and Samanth a Morgan have been serving high-class pizzas for over 20 years but have decided to take a new direction with theirnext pizza concept. Instead of focusing on an ever-increasing variety of specialty pizzas, the Morgans have decided to turn the value concept toward the high-volume, late-night pizza-delivery business. Certainly, being close to Atlanta United University, home of the Cougars, and its 38,000 students provides a deep and growing marketfortheirbusiness. As such, the Morgans are creating Cougar Pizza Pies to sell and deliver pizzas only between midnight and 4:00 a.m. A view of the current competitive landscape shows that no other business is currently targeting that same market. The Morgans believe that the simplest business model will bring them the best success in theirdesired market. As such, the new restaurant will not have anyseating (as most orders will be delivered), butit will allow for pickup of pizzas if needed. It will also have a limited menu of pizzatypes (thin, regular, or pan) and a limited topping list (pepperoni, sausage, ham, and extra cheese) in ordertofacilitate the high sales volume expected. Also, to coordinate special instructions from customers (delivery access, cooking preferences, etc.), the Morgans would like to have an area where they can add customer notes to orders. Following theirsimplicity model, the Morgans have fixed their prices as follows: Thin and Regular Crust: $13.00 Pan Pizza: $15.00 Toppings: $2.00 each . . . Furthermore, for marketing outreach and research purposes, they would like to track orders by phone number, street address, city, state, and zip code The Morgans would like to determine and validate that their new business is profitable and business savvy. Thus, they have hired you to design a database that supports the validation of the late-night pizza-delivery business. Alongwith any considerations mentioned above, they know they need to be able to track the following details in a database: . Pizza orders, including toppings added Customerwho ordered pizza Address pizza was delivered to Name and phone number of employee who delivered pizza Name of employee who took pizza order .Salesperhour, day, week, and month .Delivery status details at various points in the night. Each order should have a status along with the order date and time and the delivery date and time. Note that if a customer picks up the pizza, the pickup time is the delivery time. Some otherconsiderations for the ordering process include the following: A customer can certainly order more than one pizza Customers move often and may orderfrom different locations (a friend's house, for instance) so address details may also change often. However, each customerwould have one prefe rred address Most orders need to be completed and delivered within an hour