Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design a relational database to capture information needed by business processes Assignment Information: Your friend just started a small caf in a college town. She

Design a relational database to capture information needed by business processes Assignment Information: Your friend just started a small café in a college town. She heard that you are taking this class so she asked for your help in determining what information can be captured. You sat in the café for two days and documented the following:

The café has only three employees: your friend (who is also the owner), and two baristas. Any of them can take the order, prepare the order, and collect payment from the customer. 

For example, your friend may take the order. Barista 1 then prepares the order. Barista 2 collects the money. It all depends on who is available. Since it's just a small café, it only sells coffee and tea related products and no food items. Currently, the store does not have a loyalty program so no customer information is collected at this time?

Step by Step Solution

3.40 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

Relational Database Design for your Friends Coffee Shop Based on your observations heres a suggested ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: W. Steve Albrecht, James D. Stice, Earl K. Stice

10th edition

324645570, 978-0324645576

More Books

Students also viewed these Accounting questions