VENDRE
Rechercher
DISSERTATION
€5,67
Also available in bundle from €11,35
Add to wishlist
100% Money Back Guarantee
Download is directly available
Better prepared for your exams
2
0
(0)

Unit 18 - P7 D1 D2

Scenario 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; • name • address • 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.

Aperçu 1 sur 33 pages
Document also available in bundle (2)
DISSERTATION
€5,67
Also available in bundle from €11,35
Add to wishlist
100% Money Back Guarantee
Download is directly available
Better prepared for your exams
2
0
(0)
Infos sur le Document
École, études et cours connectés
About the document
Subjects
unit 18 · p7 · d1 · d2
Publié le
14 juillet 2019
Nombre de pages
33
Écrit en
2016/2017
Type
Dissertation
Professeur(s)
Inconnu
Grade
D*D*D*
Vendeur
umar07977
Membre depuis 1 année de cela
0 documents vendus
Seller has not received any reviews yet.

Les meilleurs resumes

Evitez les rattrapages et obtenez meilleures notes avec les meilleurs résumés écrits par d’autres étudiants.
Évitez les rattrapages
Avec les résumés écrits par des autres étudiants, on vous garantit que vous serez bien préparés pour vos examens. Plus de 400.000 résumés sont maintenant prêts pour vous. Vos camarades savent exactement quelles sont les difficultés et les éléments clefs dans un module particulier, tout ça pour garantir votre réussite. Avec leur aide, vous serez bien préparés pour entamer vos examens et vous éviterez les rattrapages.
Meilleures notes
Grâce aux résumés qui ont été écrits par des étudiants spécifiquement pour vos études et leurs modules, vous n’aurez jamais de surprise pendant vos examens. Ce ne sont pas des résumés généraux des livres. Leur contenu est adapté à vos études pour que vous puissiez briller à vos examens!
Gagnez de l’argent en étudiant
Avez-vous déjà écrit des résumés ou des notes de cours? Vous pouvez gagner des centaines d’euros en vendant votre travail à vos camarades. En 2015, les étudiants ont gagné plus de 500.000 € parce qu'ils offraient leur travail à d'autres étudiants.
×