A local mom and pop pizza shop has been in business for many years. Most of their business is delivery to homes in a couple of nearby neighborhoods.
When someone phones the pizza shop, an employee writes the order on a paper notepad. The cook looks at the little pieces of paper from the pad to figure out which pizzas to make. The deliver kid (two kids on Friday and Saturday nights) takes the little pieces of paper with him to know where to deliver the pizza. The little sheets of paper (well, most of them) come back with the delivery kid, who puts all the filled order sheets in a little basket. At the end of each night, the owner looks through the basket to see how many orders were filled that night.
This process has a few problems. Sometimes the delivery kid loses the sheets after (and a few times even while) delivering the pizzas. Also, the customers have gotten use to calling the big chain pizza places who always remember the customers' address, which pizza they like etc. Finally, the owner has a difficult time figuring out which items are selling best and when they are selling best. A lot of the management and planning is guesswork.
The owner has decided to employ you to build a small database system to track orders. Design a simple database that will meet the owner's needs.
1) Design the database tables. For each table, provide self explanatory field names. Be sure to identify the primary and foreign keys.
2) Other than tracking the current orders to the filled and then delivered, what new capabilities or features are simple to add to your database application? In other words, what simple and useful queries can your design handle?
For this assignment, you can work alone or in a group of up to 3 students.
Submit your work on no more than two sheets of paper. Type all your work. Using "tables" inside Microsoft Word is a good way to format your work.
Grade will be based on how well the shop owner's problem will be solved by your solution, clarity of your ideas, and usefulness of your added features.