• 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. GCSE Database Project ICT

    26/08/1965 Other Details Text 250 (BLANK) You Have Exceeded 250 Character Please Abbreviate Details. Specialist Appointments Appointment ID Auto number 6 AP0000 Incorrect Data. AP2596 Appointment Status Lookup 20 In Process.../Late/Unkept/Cancelled/Completed/Due/Booked Please Choose From: In Process.../Late/Unkept/Cancelled/Completed/Due/Booked Due Patient ID Auto number 5 P0000 Incorrect Data. P1526 Staff ID Auto number 5 S0000 Incorrect Data.

  2. ICT Project 1A

    I resized and added more contrast to this picture. This is again because I wanted it to be placed onto a dark background. The picture that I changed the most was one of the whole band. Here is the original. Because this picture had many contrasting colours it was very hard to edit and not make it look very odd.


    She is an average user, which means she does not understand most of the advanced features. Such as Vlookup, IF Statement, Macros, etc. Project Constraints Ms Gammon uses school standard PC that I will be using to calculate percentages and grades for the new system.

  2. Creating a computer system for a video rental shop

    will need buy, and the advantages and disadvantages of buying these computers. Midi-Tower Case ATX This is a stylish steel case. Both side's are spring loaded and easily removed by pulling the handle on the side panel. It is more compact and takes less space compared to old cases.

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

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

    He/she looks through every card starting at the back of the box. He/she will flick through the cards at the back looking and checking if any games are overdue e.g. back yesterday or back today etc. Once that card is taken out it is then placed into an overdue box.

  1. Computer project Alevels

    The entry must be 6 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be D followed by 3 numbers. E.g.: MCD123 APPOINT ON Date/time APPOINT TIME Date/time DOCTOR'S CHARGES Currency HOS CHARGES Currency TOTAL_CHARGES Currency Table -

  2. Database Coursework

    Its best to go with the 1GB RAM because it's very unlikely that it would freeze. Printers: There are two main types of printers: Inkjets, and lasers. Inkjets are much less expensive than lasers, and tend to produce better quality on inkjet colours.

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