Thread: The PC Inc. Shop Case Study
10-28-13, 13:57 #1Registered User
- Join Date
- Oct 2013
Unanswered: The PC Inc. Shop Case Study
The PC Inc. Shop has been in operation for just six months and looks set to be a successful business. PC Inc. is a retail outlet which offers computer equipment at very competitive prices. The shop is sited in a locality which ensures consistently high sales.
Products fall into three categories: Personal Computer, Laptop and Printer. The shop also stocks accessory items such as USB drives, web cams, printer cartridges, cables, plugs, adapters etc. Products can be described in terms of processor speed, memory capacity, size of hard disk, price, and speed of CD drive, screen size and colour.
Since the shop is small - it is staffed by five sales staff and has two managers - it is crucial that only those products which can be sold quickly are stocked. It is the job of one of the managers, Dave Tindall, to oversee the ordering and stocking of product items. What Dave requires is the ability to monitor the sales of given products.
The sales staff work on a commission basis which is calculated by adding the number of sales made for the day and multiplying by two.
In view of the fact that the shop has been so busy meeting the high level of sales, as this is what earns money, they have neglected to develop an adequate internal system for monitoring the products. Ideally Dave would like to be able to have a system which could very easily provide him with answers to both product information queries and also queries about the sales process itself.
Some of the product information queries could be as follows:
What PC models have a speed of at least 150?
Find the model number and price of all products (of any type) made by Acer.
Find the model numbers of all colour laser printers.
Some of the sales process queries could be:
Details of sales that are handled by an individual sales person.
List of printers which have been sold on a particular day.
Details of the purchases a particular customer has made.
HELP ME WITH THIS PLEASE!
I don't know where to start.
10-28-13, 14:03 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
start at the beginning
do an ERD
analyse the problem
normalise your tables
then define your reports/queries
if you wish to be a smart aleck and use a front end that generates ad-hoc queries such as your first 3 requirementsI'd rather be riding on the Tiger 800 or the Norton