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

This project will aim to solve the information handling problems of Mario's Game and Video Masters Rentals.

Extracts from this document...

Introduction

This project will aim to solve the information handling problems of Mario's Game and Video Masters Rentals. Mario's Game and Video Masters Rentals is a rental store that rents videos, games, and now DVD's (newly added) and is run by a man named Mario Anderson. To provide these services information is collected and stored about the items, and the members. Information about each member is written on a card, which is then put in to a card index box, which is sorted out by the member surname, then forename, then member number. Information about the items is put onto a card, which is then put in its case. After each day, a shop assistant writes loans list of all the items that have been rented out, along with the member number and video number, and name. What happens in Normal circumstances? When a member wants to rent out a copy, the customer must take it from an empty case from the shelf with the item card inside it. When he/she hands it into the counter, the shop assistant takes the card out and looks at the video number, and then takes the member number from the customer. If the member has lost their membership card, then they must pay a fee of �2.00, and will receive a new card. ...read more.

Middle

A member's card or an item card could be misplaced and could take a lot of time to find It is very time consuming when a shop assistant must look through the loan lists and write the reminder letters. When customers ask the staff whether a particular title is available, the staff will not be able to know it unless they have a particularly good memory. How could Mr Anderson solve the information-handling problems? Mr Anderson could solve their information handling problems by using a filing cabinet to store their information about members and items using detail cards. The advantage of this system is that much more information can be stored using this system. But the disadvantages are that these could be misplaced, lost or damaged, just like the existing system. Unauthorised people can take some records. It would also be quite time consuming. Another way of solving the problems would be to use a computer to store information about members, rentals, and items. The advantages of this system are that it can store a lot of data in a small space, searches through it very quickly. But computers can be quite expensive. There are two ways a computer can be used. You could write a program to solve all the information-handling problems, but I do not know how to write programs on the computer and it is very expensive to pay a programmer and it would be time-consuming. ...read more.

Conclusion

* Produce reminder letters to members with overdue items. The following criteria will be used to evaluate the success of the new system: * The system must be able to store at least 10 member records * The system must be able to store at least 20 item records * The system must be able to store at least 10 rental records * It must take no longer than 30 seconds to find and display a rental, item or loan record. * It must take no longer than two minutes to answer customer's enquiries by entering search criteria and finding matching item * It must take no more than one minute to find and delete a member, item or rental record * It must take no more than two minutes to find and edit a member, item or rental record * It must take no more than two minutes to create a new member, item or rental record * On-screen data entry forms must be clearly laid out to make data entry easy * On-screen data entry forms must use automatic data validation to reduce data error on input * It must take no longer than 5 minutes to search for members with overdue video and produce a summary report * Reminder letters to customers with overdue videos should be clearly laid out and include all the details of the videos that need to be returned. Viren Shah LVM GCSE Access Coursework Project ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. a level ict project

    Calculations will be automatically made by the system using the various formulas, which can be inserted. Templates can be created and saved before hand, for example the questions asked for customers, e.g. name will already be laid out in a spreadsheet.

  2. Spreadsheet Project - computer system for a video hire shop.

    As every other component of GNOME, Gnumeric is free software and it is licensed under the terms of the GNU GPL' I will not be using the Gnumeric software, as it is very simplistic and does not produce graphs, which I will need for my project.

  1. Creating a computer system for a video rental shop

    number and have forms which are filled out when a video is taken out and returned and they will also have the history of the customer. e.g. To add a new member they use this form: Constraints Hardware This report explains the specification of the proposed Computer that the library

  2. Moviezone video rental system.

    � It takes a long time to look through the loans box to find out which videos are overdue. � It takes a long time to write out reminder letters by hand which are sent to customers who have videos that are overdue for return.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    If after 1 week the member has still not returned the game then the employee/manager writes another letter to the same person. Problems with the current system: Our company operates functional at the moment however there are a lot of problems with our system.

  2. Data handling - ICT.

    It took a considerable amount of time to find my clients card. As the cards were hand written I often found them hard to read; I was in danger of not being able to get in touch my clients. In addition to this, because I did not have the use

  1. I will be analysing the problems defined by the management in the old system ...

    This backing up of data will ensure that there is no loss of important files. The printer is meant for producing hardcopies of the data. Some items such as reports are meant to be printed so the printer is capable of handling this job.

  2. GCSE Calculator Project

    On excel you can present data well but you can not make buttons or add textboxes and buttons to add functionality but you cannot present the calculator well. The software I will use is Microsoft word, Access and Visual basic.

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