You have recently inherited your grandfather s coffee shop, The Broadway CafÃ©, which is conveniently located in downtown Auckland. The cafÃ© offers many different kinds of specialised coffees, teas, a full service bakery and homemade sandwiches, soups, and salads. Your grandfather first opened The Broadway CafÃ© in 1952 and it was a local hotspot for many years.
Unfortunately, business has been steadily declining over the last five years. Although your grandfather was an expert at running the coffee shop, it is outdated. There are no computers in the store and all ordering takes place manually. Your grandfather had a terrific memory and knew all of his customers by name, but unfortunately, none of this information is located anywhere in the store. The family recipes for the baked goods and soups are also stored in your grandfather s memory. Inventory is tracked in a note pad, along with employee payroll, and marketing coupons. The cafÃ© does not have a website, uses very little marketing except word-of-mouth and essentially still operates the same as it did in 1952.
4. You understand that database technology is better equipped than spreadsheet applications to improve your ability to analyse information. Furthermore, you have a great deal of data available to turn into information to help you set the strategic direction for the cafÃ©. However, your systems are not integrated and the quality of the data within the above disparate systems is low, so you cannot determine vital information such as which customers are ordering coffee and not food or music and not coffee. For example, the three details that a customer ordered four cappuccinos, three CDs and two coffee-of-the-month gift coupons, are discrete facts housed in separate systems. So you plan to build a small database for The Broadway CafÃ© to help you track and analyse customer orders and sales information.
a. Identify five different types of entities, attributes, keys and relationships in each entity you will want to consider when designing the database for The Broadway CafÃ©. [submit the answer in writing along with your answers in other questions]
b. From the five entities from 4a, create three tables in MS Access with appropriate fields, primary keys and relationships among the three tables. Populate each table with at least five rows of data.
c. Create a data entry form for one of the tables in MS Access
[For 4b and 4c, submit your answers as Access files]
? Identified entities and their attributes
? Identified primary and foreign keys
? Illustrated relationship among entities
? Created three tables with sample data in MS
? Created a data entry form for one of the tables
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more