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


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.


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.


* 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. This project is designed to help non-computerized library to easily keep track of their ...

    For the use of a computer a monitor is needed, so the monitor is a vital part of a computer. ?Printer It is a computer peripheral that puts text or a computer-generated image on paper or on another medium, such as a transparency.

  2. GCSE Calculator Project

    Is the calculator big enough? Is this calculator better than the Microsoft calculator? Can any improvements be done? Please state below Evaluation User Feedback & Possible Improvements After reading the Silver Surfer's response to my questionnaire I have made a summary in bullet points shown below.


    * Finally, the new system should not be used by anyone else except Ms Gammon, so I will make sure her system is safe by creating security code. Source Documents The source document that I have provided is a copy of marks book that Ms Gammon uses to record her student marks.

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

    It also requires training to use, which will have to be paid for. It is a very complicated program and does not contribute to my needs. Quoted from the Gnumeric website: 'The gnumeric spreadsheet is part of the GNOME desktop environment: a project to create a free, user-friendly desktop environment.

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

    These are some of the features it offers: * Automatic removal of many viruses without interruption. * Script Blocking detects script-based threats, even before new virus definitions are created for them. * Scans and cleans outgoing email messages to prevent sending infected files from the PC.

  2. I will design a new video database for the video shop that will also ...

    The system should also have a large memory capacity, as there are a large amount of Customers that need to have their details stored. The system is required to be reliable so no data is lost and there should be a low amount of duplicated data so time is saved.

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

    Our first and most important problem is that it takes too long. When someone wants to take a game out we have to have to take the card out of the games case. Then we write all the appropriate information on it and store it away.

  2. Brent would benefit from new technologies because they would solve majority of the difficulties ...

    been used to combat 'anti-social behavior', including many such minor offences as littering, urinating in public, drunkenness, and evading meters in town parking lots. They have also been widely used to intervene in other 'undesirable' behaviour such as underage smoking and a variety of public order transgressions.

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