Video Store ICT Investigation

Authors Avatar

                 

ICT Coursework

Specification

Identification of Problem

A video rental store has been letting out videos for 2 years. At the moment the records are kept on paper. These records include, videos rented out, videos back in, members details and account details. The problem is that paperwork has been known to get lost and there is no way of recovering these details.

Also it takes a lot of time to rent out and return the videos and searching the records for overdue videos takes a lot of time.

Background

Letters video rental is a small time shop in Howe Green; it consists of 2 owners and the business is steady. It is open 8am to 8pm. It is also a general store and it sells the basics of milk, bread etc. There was a need in the village for video rental as the residents did not like going to Chelmsford and therefore the business is expanding

Statement of Problem

Paperwork has been going missing gradually over the two years, at first this was not a problem but then they lost financial information, this has encouraged them to get a computer.

The Current System and problems with the current system

At the moment each member has a membership card, this membership card has their name and their member number on. When they go to hire out a video there number is put down on paper and the number of the hired video/DVD is put down beside there name.

The current paperwork system is not very good as it is untrustworthy i.e. in the last six months some essential financial information went missing. The paperwork system can also be hard to read as Mrs Smith has poor handwriting and when it comes to Mr Smith to read who’s borrowed what it is very hard for him to read. The paperwork system is also very slow meaning if Mr Smith wants to check if there is a video in stock he has to search through lots of paperwork

Detailed Requirements Specification

The system must

  • Be able to keep a list of members and their details
  • Be able to keep track of videos and DVDs in stock
  • Be able to see what person has got what video
  • Be able to track of how much money a person owes
  • Be able to rent out and return videos quickly
  • Be able to print out lists of overdue videos
Join now!

Constraints – Hardware, Software and users IT knowledge and skills

The current computer system is a

AMD Athlon Xp 2000

80 Gb HDD

512ddr RAM

The system came with windows XP Home and Microsoft office XP Professional the user will just need to know how to use Microsoft Access. To install Microsoft office the user will need about 500mb of space. The current computer should be sufficient to run Access.

The system inputs and outputs

The inputs are:

  • Member Details – Member ID, Name, Address, ...

This is a preview of the whole essay