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 3 entities and attributes. For example:
I would go into Access and create a database named "Broadway Cafe." In the database, I would add 3 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, 8 oz or 12 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!