• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Shockwave Music ltd Information Technology Investigation

Extracts from this document...


GCSE Coursework Report Choice of problem Shockwave Music ltd. Is a Music shop in the south of London. It started off as a Family run shop in 1980, and has since expanded to a 2-storey premise with a total of 20 people employed as salespeople. It has the records of its employees stored in 3 separate filing cabinets; one for employee information, one for payroll information, and one for records of sales. However, retrieving these records takes a lot of time and energy, as each sale has to be logged on to the individual employee's sales history. . As most of its purchases involve large amounts of money, the sales person has each major sale they make put on their sales history, in order to increase sales. The managers have set up a bonus scheme for its employees, where sales targets are set, and bonuses are awarded to those employees with the most sales. I have decided to choose this problem because I wish to highlight the amount of time in the workplace that can be saved with the use of I.T. I would also like to develop my experience of spreadsheets and databases. Description of problem There isn't really a problem with the old system; it's just that it would save a lot of time and pay, so it would make the firm more efficient. ...read more.


Specification The program developed to solve the problem should be widely compatible with most widely available platforms, so that the records can be viewed on other computers, in case the shop computer is inaccessible. The new system should also be easy to use and straightforward to operate. This will mean that the shop assistants can use the system quickly and easily, and so reduce operating time and shop stress. So, I think a windows '98 system (stable, and needs a modest spec to run) with access XP or 2000, whichever is cheaper. After a sale is made, the quantity of each product available is reduced by the appropriate amount, and the product number is added to the employee data. This way we can easily find who sold what, and how many sales each employee has made. The solution program must be: 1. Easy and intuitive to use 2. Able to operate on a low spec - The firm may want to keep the spending on hardware to a minimum. 3. Able to search for records, for quick access to data. 4. Protected by a password + anti-virus software, under the data protection act. 5. Easy to backup: i. Must support floppy disk backups ii. Must be a standard format (e.g. must be able to be read on most machines, etc.) Design Name of value Data Type Employee I.D Autonumber (primary key) ...read more.


This wont cost much, and is expandable, so adding more computers isn't a problem. What might be a problem is the initial start-up period, where the staff will adjust to the new system, and the initial cash outlay may disrupt the normal processes of the shop. Software resources required For this sort of application, we really have no choice but to use a database/ spreadsheet program. As for an operating system, it seems windows has a much larger user base than Linux or Macs, so we will get technical support more easily. Since we are looking for ease of use and flexibility Implementation To create the system we are after, we will need to create relationships between the data, and use these to cross-refer our data. But first, we need our data. We already have the stock amounts and names, so we put these in a table first. This gives us the main data, which will move around the most in the database. Now, we put all the employee's details on a similar table. This allows a lot of information to be shown clearly, as well as providing an easy to use primary key, in the form of the employee key. There is also an automatic validation check that the primary key must contain a valid number, or it gives the user an error message: This stops incorrect data from being put into the database, which might cause problems with cross-referencing later on. ?? ?? ?? ?? Thomas O'Neill 10BR ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    wages paid to the employee if this activity takes place other than the first day of the month. It should be noted that if an employee goes on a temporary deputation from India and if he/she was paid India Allowance in India then he/she will not get his/her "India Allowance" till the time he/she stays abroad on deputation.

  2. I have been given the task to design a database for a company called ...

    To make the parameter query work I need to specify the criteria by which the computer will search the records. In this case the criteria is as follows: This formula means that the computer has to look in the destination table and under the Name of Recipient company, as shown

  1. Smart Card System

    4. When an end node receives the Incoming control signal, it prepares to receive a packet by stopping the transmission of requests and listening on the media for the data packet. 5. Once the repeater has decoded the destination address, the packet is delivered to the addressed end node or end nodes and to any promiscuous nodes.

  2. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    These disadvantages are not directly visible to the customer. * Paper - The system produces a lot of paper as an output and it is generally difficult and takes up a lot of valuable time organising a vast amount of paper.

  1. Definition-nature of the problem solved - Car Mechanic business

    Yes, if that's possible it'll just make it look a bit more professional but the company has no unique colour scheme so you would probably have to make one. That's fine; I'll give you a rough copy to check over before I use it properly Q: What paperwork would you like to keep in a new system?

  2. Introduction to spreadsheets

    the entry spread sheet 1 See if product button works Clicking on the button To see if it takes me to the products page. It did take me to products page. 2 See if offers button works Clicking on the button To see if it takes me to the offers page.

  1. Estate Agents I.T. Problem

    with a modem and internet access s will be able to search the database whenever they choose. INVESTIGATION & ANALYSIS Planning To improve the system I will first have to find out about the current system in use so I will send a questionnaire to ward and partners asking them about the system they are using.

  2. Explain the different techniques of gathering information to answer an IT Technical problem or ...

    FAQ, you would log onto the system and go onto the internet. Once you are onto the internet you would go onto a relevant website that has your information. You would then go onto the Internet source FAQ which would then have the relevant information that you would gather in order for you to answer a problem.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work