You have been hired to create a database for a small coffee shop. The owners of the coffee shop would like to keep track of customers, products (as in listed on a menu), ingredients for the products, and sales. Customers can order products with various ingredients and suppliers provide the ingredients to the coffee shop.
1. Start your project by formulating a business statement that describes the scope and components of the database to be created (you may want to read all the deliverables listed below before formulating your statement.)
2. Create a list of fields that would need to be included in your database (you can use Word, Excel, or whatever method you like) and sample data.
3. Normalize your data to third normal form and create an EER diagram of the final database indicating primary and foreign keys.
4. Once your EER diagram is created create the database (feel free to use the forward engineer feature in MySQL Workbench to accomplish this task.)
5. Jake in their accounting department will need data to pay suppliers. Formulate a view that would provide the access to the necessary data.
6. Describe how a trigger or stored procedure in the database would be helpful to the coffee shop owners.
7. Describe three factors that the administrator of the database should address and why.
8. Create a document that contains: