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

DVD/Video game rental shop

Extracts from this document...


Analysis The database that I'm going to create is for a small DVD/Video game rental shop. The shop is very small and all their records were created by hand on paper. 'DVDVG' (name of shop) has expanded and now has several branches. Their old method of storing records has become very impractical. Introduction DVDVG have been selling and renting DVD's and Video Game's for almost 2 years now. Their new system will have to include: > Data on products they currently own, such when was it last rented, how many times it has been rented, certificate, number of players, running time and other information that is related to the product > They will need to store data on all their customers so that they know what special offers they should give them. ...read more.


DVD's The information that needs to be stored on the DVD's is: > DVD Name > Certificate > Genre > DVD ID > DVD Publisher > How times been rented Video Games Information that has to be stored on the Video games are: > Name > ID > Certificate > Publisher > Number of times rented Customers > Customer name > Address > Telephone number > Date of birth > Number of products rented (Total) > Number of products rented (Current) > Last product rented > Membership Number Rentals > Customer name > Address > Any videos they are currently renting > Date due back for each video > Current date > Whether its overdue > Amount due if overdue Problems Their current system is very old and inefficient. ...read more.


> It takes a lot of time to find a specific piece of data because the entire database has to be searched. Problems specific to their database: > When the want to find customers that fit a certain criteria, for example when they want to send out offers/advertisements to customers, they have to sort through their entire database manually to find the customers that fit the criteria. This means customers sometimes do not receive information that may otherwise have led to more customs. > Some of their records might have been rendered illegible due to poor data maintenance. Since their databases are on paper, some they have been ripped or have had tea and other stuff spilled on them. > Their database relies completely on human input, which also makes their manual system highly susceptible to human error. ?? ?? ?? ?? Pedram Emrouznejad 11L 2 ...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. Spreadsheet Project - computer system for a video hire shop.

    / Backup / Security The worksheets need to be validated for several reasons. Examples of validations that have been put on the Monthly Income Worksheets are: > Membership number I will put an input message validation on this column. The validation will be that a membership number must be added unless the only purchase is a food purchase.

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

    If you need more sophisticated form processing than FrontPage provides, you can still use Transform or custom CGI programs with the forms you create in FrontPage. * Web searches: FrontPage Server Extensions provide a simple web search engine. Searches are confined to your FrontPage web or subweb.

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

    enter the member number then all their details appear or when you enter the game number all of the games details appear. This can be very useful and quick as all you need to do is enter a number and all their details appear instead of typing out all of their details.

  2. The aim of this project is to propose a possible solution for information handling ...

    to meet the performance criteria requirements as validations can be inputted to identify redundant and duplicate data. Professional on-screen forms and reports printouts can be easily designed using a range of colours and fonts. Further sophistication can be added using macros to perform tasks such as non-standard data validation.

  1. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    The member details card is put back in the members box. The last due back date on the video details card is crossed out and put back in the video case, which is placed back on the shelf. At the end of every day the loans box is searched to see any videos that were due back haven't been returned.

  2. Creating a computer system for a video rental shop

    Basically everything including customers, videos, staff and rentals are all written out manually onto a standard form every time something needed to be updated. There are a few problems with this filing system: Keeping track of when videos are due back.

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

    be backed up, if the computer is affect by a virus or the system crashes or if there is a fire, then no all files will be lost . It could be update or change more easily. The files could be found more easily.

  2. I have been employed as an ICT consultant for DVD rentals, a business that ...

    This field holds each DVD's unique ID number. DVD Name Text 50 Characters None - These cant be used in this field This field holds each DVD's name. Category Text 50 Characters Combo Box - List Box for Category This field holds the category for each DVD.

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