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

Introduction

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.

Middle

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.

Conclusion

> 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. Creating a computer system for a video rental shop

    Concluding Remarks Mr Elgayar the end user is used to his position and is suffering from a paper based management system that is inefficient. Abdullah realises his problems and is very willing to become more efficient in his workplace. Objectives for the New Systems Qualitative 1.

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

    We realized that at present the end user would need to manually sort each transaction into transaction types to find out how much income was from each different transaction type: video sale, video rental, food sales, late fine. This resulted in a change to the monthly income worksheet.

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

    This is very useful if used on a template as a template opens a new copy every time so it will always keep updating the time. If statements allow you to create scenarios, for example in the game rental service you can say 'if' the game becomes overdue then say overdue.

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

    a video; * If a particular video isn't in the right place on the shelves its difficult to tell a customer if its on loan without searching through the loans box; * Staff spend a lot of time answering questions about which types of films are available to rent.

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

    POST_CODE ADDRESS POST CODE TEXT (10) CONTACT_# HOME OR MOBILE NUMBER TEXT (11) DATE_JOINING MEMBERSHIP JOIN DATE DATE() EXPIRED_DATE MEMBERSHIP EXPIRED DATE DATE() + 1460 DVDs TABLE ENTITY NAME ATTRIBUTE NAME ATTRIBUTE DESCRIPTION FIELD SIZE DEFAULT MODE CONSTRAINS DVDs DVD_ID UNIQUE DVD IDENTIFIER AUTONUMBER (LONG INTEGER)

  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. I have been employed as an ICT consultant for DVD rentals, a business that ...

    Date Released Date/Time General Date e.g. 01/01/2000 None - These cant be used in this field This field holds the release date for each DVD. Cost Currency Currency e.g. �7654.32 None - These cant be used in this field This field holds the price of each DVD.

  2. Implementation of my database for Emma's DVD rental shop.

    The pin is not written on the card but I keep a record of it. I now have around 500 members on my data base and books that I have recorded. And over 10,000 DVD's for hire, with about 200 given out on hire at any given time.

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