• 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. ICT Project - Statement of the Problem

    is done manually and the member's information is not kept on a database. So for example the members fill out a form on paper that is then place alphabetically the members file ling cabinet. Additionally the restaurant bookings are also done manually on pieces of paper., which has consistently lead


    This system will therefore make her work more accurate and easy to use. * It will enable her to make the management decisions that she uses to support student learning. * I will create a system, which will automatically convert total marks into a percentage and from the percentage automatically generate an overall grade.

  1. GCSE Calculator Project

    In access it's possible to allow privileges to different user groups. The groups can be "Users" and "Admin". This is very complicated process .For the purpose of this calculator it's acceptable to simply hide the design options from the silver surfers.

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

    * She goes about doing this by looking for the book in mention on the various book lists she has of different publishers and then writing in the order sheet the name of the supplier who sell the book, the name of the book and the price.

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

    The guide needs to be easy to understand with a minimal amount of technical jargon. This will hopefully mean that anyone who needs to use the system will be able to. The video shop has a manual book system, as it is a manual system I will need require to

  1. Database design.

    The screen will change to the required screen The screen was changed to the required screen Made more macros for the menus 2. Customer and Video table Can letters be typed into the telephone number field I will enter a letter into the field There will be an error message

  2. Database Analysis and Database Design Project - DVD library for moving images.

    POINTS TO REMEMBER > Design for DVD library. > Each title must have a least one copy. > Each title must have a category > Only registry members can loan DVDs > Must keep records of all members. If a DVD is return late, a late surcharge must be applicable.

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