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

The aim of this project is to propose a possible solution for information handling problem for a local independent video rental shop in Birmingham. Xpress video rents out videos to approximately 300 members

Extracts from this document...


Xpress Video Rental Introduction The aim of this project is to propose a possible solution for information handling problem for a local independent video rental shop in Birmingham. Xpress video rents out videos to approximately 300 members and has a collection of 500 videos. The owner Mr. A.Malik (client) feels that in order to expand the business they require a new system to collect all the data. The proposed information system is based upon Xpress Videos existing manual system. Current System At present all information is collected manually. Each video has a card that holds information about the video and is kept inside the video case. Information regarding the member is stored on a different coloured card that are in ascending order by member's unique number and is stored in a different box and the loan information is also stored in a different box, which is indexed. Members need to show proof of identity before they can join and then they receive a unique ID card, which enables them to get discount and special offers every time they bring it to the store with them. When a member wants to rent a particular movie the assistant (user) needs to take the video details out of the case and then search for the member details in the member box. For security purpose all members are asked to show their ID card number or confirm their details. ...read more.


The system should be able to control unauthorised access * Provide data security * Train assistants and issue them with a user ID and password * Data Protection should be applied as Xpress videos are collecting members personal data 6. Allow back up copies to be made * Consider recovery & backup procedures when purchasing the hardware & software * Use data storage disk as this will save space and could be recovered if the system fails 7. Information regarding member, video or loan should be accessed easily * The on screen data entry must be clearly laid out to allow data to be entered * The design format of the system should be consistent 8. The system must identify duplicate and redundant data * Computer program controlling the input should perform various validation checks on the data * The system should use presence check, format check or file lookup check to validate data * Relationship between tables will identify redundant data as each table will have primary fields Method We can use program such as Microsoft spreadsheets package, which is like a database and can be used to set-up a system. This software package could be set-up to store information and search for different records and to print the lists out. The advantage of this is that the program is cheap to purchase and therefore is very cost effective however, it may not execute some of the client's requirement. ...read more.


Implement design, test database, involve end user and make all the necessary changes, perform risk analysis, write user manual etc. Risk & Constraints I will need to establish a feasibility of what I have set out to do, by identifying risks and constraints will provide me the time to mitigate those problems that can be fixed or notify Mr. A.Malik both verbally and in writing if the problem is serious. A critical analysis of the project is crucial to get it off to an acceptable and workable start. * Funding-may not get the full amount of capital that the project might need * Time-may find things are taking longer than originally planned. Thus, may risk running out of time * Client relations-if Mr. A.Malik does not have the time to work with me and assist in defining the attributes of the solution to the project problems. I may risk having a dissatisfied client as the project proceeds * Resource-what inside and outside resource is required A security incident can lead to loss of data confidentiality, integrity or availability when in turn may give rise to impacts of direct or consequential harm. The main difference between computerised and non-computerised database is the speed with which data can be accessed. A computer database also makes it possible for Xpress Video rentals to analyse data using graphs and other methods of analysis. ?? ?? ?? ?? Enterprise & IT Project Development 222IS Coursework 4 1 ...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. Marked by a teacher

    Social Impacts and Threats of IT

    However, behind the scenes this is not good, it is a huge problem. The question many people in our society today forget to ask ourselves is where does the old computer equipment that we no longer need or use go?

  2. ICT Project - Statement of the Problem

    Another problem they have problem with ordering though the phone and mail they have found that it wastes a lot of time because they are constantly looking up the codes in the ordering books when ordering. Also the club Mrs Elone has a file on the members, but all this

  1. Video Rental Shop I.T. System

    The potential users of the system will be Barry and the ten shop assistants. I went into Quick Rentals and asked Barry some questions. Below are the questions and the answers. Have you any knowledge of Microsoft Access? Yes I do know how to use Microsoft Access, but I'm pretty sure not all of the shop assistants do.

  2. a level ict project

    More secure and effective means of security cannot be implemented to insure integrity. This is due to the system's simplicity, the best security is to place the documents under lock and safe, or place security guards, which cost money. Solely tedious forms of backup are available, which includes copying out, or photocopying information.

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

    Identification of the Users Jack is the only employee at the video shop. This means that I will be showing my project only to him at various stages of development. He will be the person who gives me feedback after the project has finished.

  2. Creating a computer system for a video rental shop

    Because all the data is kept in files you must continuously check if people are not bringing data back. Obviously this can be very time consuming and errors are likely to be made, resulting in lost videos, lost assets and revenue.

  1. Moviezone video rental system.

    Thank you for taking the time to complete it. Please hand it in to receive your free rental voucher (one per customer only). Interview questions Sample documents Problem Description This project will aim to solve the information handling problems of MovieZone Video a video rental service based in Kidsgrove, Stoke-on-Trent.

  2. System requirements analysis

    that they have very high resolution and that are very fast and they are very quiet. However the disadvantages of a laser printer are that they are very expensive to buy and to repair and also they cannot be used continuously.

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