• 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...


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.


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.


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 of creating a system for a hospital to ...

    This all takes time and if you change more than one page's name it will take a very long time. * With the labels of the graph they will not change with the data so you end up having to go over the whole process of making a graph again.

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

    RECORD STRUCTURE Customer Records The customer records will be in a table called 'Customer'. The following table shows the field names, their type and field size. Field Name Field Type Field Size (maximum number of characters you can enter into a field)

  1. Evaluation of a computerised system

    deleted The same applies for deleting a customer as applies to adding a new customer. The data is not shown as a table but is immediately accessible via the Customers form. * Generate a unique ID for each product added into the database A unique ID for each product that is entered into the database is automatically generated.

  2. You need to discuss the advantages and disadvantages of someone in your

    This database can then be judged accordingly based on my evaluation criteria. Evaluation criteria How it will be judged success The database should enable me to add data I will attempt to add a new client's details to the database.

  1. Introduction to spreadsheets

    7 Text box After clicking the button the text in the textbox will change to the different products The text was not showing the first time but it was a typo. After that text box was working fine. 8 Images box After clicking the button the image in the image

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

    (See the diagram below) It is important to note at this point that because the measurement is represented by a limited number of digits, there may be some slight loss of accuracy (in our analogy, the depth of the harbour is indicated by whole numbers of knots under water, not by fractions or parts of the distance between knots).

  1. White Soul System Designs - creating a computer system.

    Stock records can also be misplaced. This may lead to the staff members thinking they had ordered new stock but to have it never arrive. This is a problem when a customer has specifically requested that item of stock and has to find out that it will not be delivered till the next stock delivery.

  2. Develop a system for use by a fitness centre to store and organise the ...

    easy and quick to use Data stores, Input, Process and Output DATA STORES (what files are used?) Customer Files Instructor Files Timetable for use of facilities INPUT (what data is inputted into the system?) Membership details Instructor details Equipment use details PROCESS (how the system handles the data)

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