This assignment will serve as a starting point for a database information system you plan to implement in your business. After reading the information in Appendix C, think about the different entities you might use for your business.
- Create an Access database that includes 4 entities and 5 attributes.
- Create table relationships among all tables, with at least one bridge between many to many relationships.
Go into Access and create a database named “Broadway Cafe.” In the database, add 4 tables to track data. The tables could be as follows:
- Recipes (to track my cafe’s recipes. So, the attributes would be: Recipe ID, Name, Type (Italian, Swedish, etc…), Portion (example, for steaks, 8 oz or 12 oz, etc…) Price, Ingredients, Directions (how to cook the dish.)
- Sales: The attributes would be: Sales ID, Date, Time, Category (breakfast, lunch or dinner), Quantity, Price, Customer ID (we are going to track what customers order.
- Customer: Customer ID, First Name, Last Name, Email Information, Sales ID (link their purchase to the actual customer, Recipe ID (link the recipe of the dish they ordered to their account.)
- Orders, what items did the customer order?
- Inventory, what ingredients were used to fill the order?
Create your own, but always have an ID field, with a specific name like Recipe ID, in each table. Remember, Broadway Cafe is yours, so you can track what you want. What about Inventory? Sales of Coffee Beans, etc…?
0 comments