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

Creating an IT system.

Extracts from this document...

Introduction

Identification My local newsagent, Cannon Hill Newsagents, has a problem. Its owners Mr and Mrs Shiva have a newspaper and magazine delivery service. With over 500 customers, the task of managing deliveries, cancellations, modifications, can be very time consuming using a manual method, such as entering data into a ledger. When customers go on holiday, they want to cancel their normal deliveries. It can get very untidy in their book and, even though they write in pencil, to help it get less messy, it still gets untidy and can get quite confusing. If papers become completely cancelled then this adds to more confusion as papers cannot be removed completely. As a result of all the above, their account management system is quite poor. As mentioned before, they have over 500 paper rounds to deliver. They always have new customers coming in to ask for deliveries. Therefore this service is getting quite large and will not be able to cope with many more customers if they carry on using the same manual system which is used now. ...read more.

Middle

It is not suitable for use as a database because of its lack of search or sort function. Microsoft Excel is like word except a table can be used for storing information. Therefore again, for the lack of good quality search or sort functions, it is not a suitable application to use. A database program is the best option to use because it can create queries, reports, and data entry forms. With this data can be entered in easily and quickly without any hassle. For this an application called NewStar will be used. It is a program made especially for this purpose. There are many more advantages of having a computerised system: > A computer can work 24 hours a day continuously. > There is no need for a ledger; it can all be stored on a computer ready for use whenever it is needed. > Computers are accurate. > There is a low risk of data being lost as it can be stored on back ups. > This information is easily and quickly accessible. ...read more.

Conclusion

Another thing is that updating the manual back ups would be rather difficult. Also with a computer, the information that is backed up can be done so using a CD re-writer or a zip disk. This means that a CD re-writer must be bought and installed. Knowledge of how to use it must also be provided to the staff. The hardware needed to set up this database is as follows: A main processing unit, a monitor, a keyboard, a mouse and a printer would be helpful for printing receipts and reports. I am going to create a database for Cannon Hill Newsagents, which will allow the user to: > Access customer details quickly and easily. > Update customer subscription information rapidly. > Easily add/remove customer accounts. > Store hundreds of customer accounts on one easily accessible database. My aims are to: > Clear up all the books underneath the counter. > Make Cannon Hill Newsagents much more efficient and make their service the best it can be. ?? ?? ?? ?? Nayan Patel 10A2 Identification - 3 - ...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. I have been given the task to design a database for a company called ...

    Below is the overall design view of the two queries as explained above. CONSIGNMENT NOTE As a Report The consignment was produced using the report wizard and pervious discussion explains the layout and design of the note. This is the first design of my consignment form, which will be given to both the deliveryman and the customer.

  2. Introduction to spreadsheets

    It did take me to Main Menu page. 2 Send - Button Clicking on the button This does send the information. Test No. Purpose of test Method of testing and test data Expected result of test and result Testing the formulas and macros on the entry spread sheet Month sales:-

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    Other common forms of wireless media include microwave and infrared signaling. The different types of transmission media identified here may be used to support a range of different LAN transmission needs. While a small network may only use one type of transmission media, a large network will likely employ a mix of media types.

  2. Smart Card System

    Since the user must have a different key for every person they communicate with, they must trust each and every person with one of their secret keys. This means that in practical implementations, secure communication can only take place between people with some kind of prior relationship, be it personal or professional.

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

    High-level Program languages include C or Pascal. The main advantage of high-level languages over low-level languages is that they are easier to read, write, and maintain. Ultimately, programs written in a high-level language must be translated into machine language by a compiler or interpreter on the computer.

  2. Creating a computer system for Wooten Basset Rugby Club

    The Rival Players-Fixtures data store is similar to Players-Fixtures, however it stores data about rival players as opposed to players for Wooten Bassett rugby club. Each record will be uniquely identified using the foreign keys of rival player code to determine which player, and fixture code to determine the fixture.

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

    Interview with manager Input Requirements Requirement Evidence The company logo must be automatically present on every document before anything is written Interview with Manager System must be easy to operate for novice users Interview with Manager The owner must be able to secure the customer details with a login and password known only to him.

  2. Estate Agents I.T. Problem

    The information about the house will be a short description, the asking price , a picture and a number to contact for further information. Research I have researched the current system available at ward and partners a local estate agent and have found that the current system consists of the

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