• 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

    Plus passwords can be put in place to restrict unauthorised access to sensitive areas. The system can be easily backed up using storage devices such as compact disks and flash memory sticks. Both storage mediums provide quick and effectual data transfer.

  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

    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.

  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. Data handling - ICT.

    Investigation and Analysis Before starting on my database I decided to research some other Job centres to see how they functioned, the easiest way to do this would be through a search engine on the net. Here are some of the other ways I found to run your Job centre;

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

  2. System administration report

    use and so only license will have to be applied to those computers who are going to use it. If a new application wants to be installed on the server, then a license will have to be issued. The problem with IGS booking software is the capability of the software

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