Mia runs a successful sandwich shop in Birmingham. The shop provides a lunchtime sandwich delivery service for customers who phone in orders from their office or workplace. Her business started as a small, one-person enterprise, but it has expanded rapidly. She now has a number of employees, who are trying to work as a team to provide a good service to their customers but as the business has grown, the employees are making an increasing number of mistakes with orders they send out. Both staff and customers are becoming frustrated with the ordering system.
This is what happens at the moment
A customer rings up the shop to place an order; all calls are taken by the booking clerk, who is called Erica. If they are an existing customer Erica looks up their details in the card index file, if they are a new customer, a card is completed for them.
The following information is required for the card;
• telephone number
Once a customer card has been completed the sandwich order is taken, customers usually order more than one type of sandwich with each order.
The sandwiches available for order are on the menu flyer along with the codes and prices; this is contained in “Mia M”
Erica knows a bit about computers and has decided to enter the customer details into a spreadsheet so she can do promotional mailshots more efficiently. The spreadsheet is available and is called “Customer ”.
Sandwich orders are made by entering the details onto a paper order form; a copy of which has been provided (“order ”).
The order form is then passed to the production part of the business where staff put their initials just before the company name column to show that they have made up the sandwiches on that line. This is an important part of the process as Mia uses the information to make sure work is being shared out properly amongst production staff.
There is a manual record of staff as per the provided document (“staff ”), there are currently only two staff members but there are plans to expand the business.
This is what you are going to do about it
You have decided to use database software to provide a more efficient solution. The new database system will hold information about customers, sandwiches, orders and staff.
The system will have to produce a daily order sheet for the production staff to use as well as allowing them to update orders with who has fulfilled them.
The system will have to provide customer invoices and staff production reports.
Trusted by students worldwide
Over the past month, 21,189 students have bought study materials through Stuvia.
Immediately available, always accessible
Your summaries are immediately downloadable after purchase, wherever and whenever you study, in both digital and hardcopy formats.
100% money back guarantee
Is your purchase not to your liking? Then you will be refunded for the entire amount, as Stuvia credit.
Safe & Protected transactions
Pay with trusted payment options like SiD Instant EFT, or your Credit or Debit Card. Payments are handled through a secure TLS-Connection so your information is always well protected.
More courses of Information Technology 2010 QCF - PEARSON
Avoid resits and achieve higher grades with the best study notes written by your fellow students.
With summaries written by fellow students, you are guaranteed to be properly prepared for your exams. Over 250,000 specific summaries are at your disposal. Your fellow students know exactly where the pitfalls lie and what the key elements will be to your success in that module. With their assistance, you can become well prepared and can avoid having to retake exams.
Get better grades
Thanks to the summaries written by fellow students specifically for your course and its modules, you will never miss a trick when it comes to your exams. No generic book summaries, but the specific content you need to ace your exams.
Earn while you study
Have you written lots of lecture summaries or notes? Earn hundreds of pounds each month by selling your written material to your fellow students. Last year students earned over R 8.000.000 from selling their work to other students.