Results 1 to 2 of 2
  1. #1
    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.


    I don't know where to start.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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 requirements
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts