Question: 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
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 entities and attributes. For example:
I would go into Access and create a database named "Broadway Cafe." In the database, I would add tables entities to track data. Below is an example of one.
Recipes to track my cafe's recipes. The attributes would be: Recipe ID Name, Type Italian Swedish, etc... Portion example for steaks, oz or oz etc... Price, Ingredients, Directions how to cook the dish.
Do NOT use what I listed! 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: inventory; sales of Coffee Beans, etc...?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
