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

Database Project - on a Video Shop based in South London, called 'GoggleBox'.

Extracts from this document...


Database Project - Identify This Video Shop is based in South London, called 'GoggleBox'. At the moment, the manager has three assistants. The shop has been established for over three years now and is looking for a way to improve its business with new technologies. GoggleBox currently uses a large manual filing system to store all information about customers, videos and loans. Customers need to become members to rent videos. Each video is catalogued and its details are stored in a filing cabinet. Each customer fills out a form to become a member. A membership number is then assigned to them and this form is filed in a filing cabinet - alphabetical order by surname. These forms are taken out if member details need to be changed or when their address is needed to send out an overdue notice. All the rental information is written down in a logbook. Overdue items are checked daily and details are cross-referenced with member and video files. Calculators are used to work out the overdue fees. Sales assistants are often asked about whether particular films are in stock, or when new releases come out. ...read more.


The fee then has to be calculated...all of this takes time. Mistakes are often made, and letters have even been known to be sent to the wrong people! There are a number of possible solutions that could be considered: The first one is to simply improve as far as possible their existing manual filing system. One improvement is to make a log book of backup details incase any records are lost. These could include minimal detail - simply information such as name and address, or telephone no. and if need be further details could be taken later, should the record disappear! Another solution could be to computerize the Logbooks - This way, the system would be partially computerized, partially manual. Loans would be recorded on a computer application such as excel, word or access so that it would be a less tedious job to check for overdue items. The records of members and video info would remain in their filing cabinets. The advantage of this is that overdue items are easier to identify and fees can be automatically calculated (if the right software is used). ...read more.


It seems to solve all the current problems that have occurred through the manual filing system, including no backup strategy, loss or damage to records, time consuming methods, extensive use of paper and storage space. One more disadvantage of this solution is that some of the staff are likely to be computer-illiterate, however as long as the system is simple to use, it won't take long to train the staff so that they get to know the basics. User Requirements The user would want the system to: - store all details of the videos. - store all details of every member. - store all information in alphabetical order. - be very simple to use. - be extremely accurate and pick up on any typing errors that could be made. - be able to search for overdue items and easily calculate overdue fees. - print out this information in a presentable format. - be able to retrieve specific information that the user asks for. - to have a simple backup strategy so that if in any case the file goes missing, it can easily be saved or replaced. - Be a very quick and simple way to retrieve information. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. ICT Coursework Two - Database Project

    The OCR may not recognise a certain character and convert it differently or not at all. I could also use a barcode scanner to scan in the video information on the package and automatically fills in the correct fields with the videos information.

  2. Spreadsheet project

    I could also receive and give stock orders between the branches more easily by linking with the other branches via Internet or another networking system. Finally spreadsheets are a more accurate representation of real life unlike manual methods. This in affect means being able to view the data in

  1. My business idea is to open a fish and chip shop.

    The results have clearly justified the potential for my shop. Since there is vast competition, this indicated by my secondary research from the local Civic centre web site and also from Yell.com. I will use the method of distributing leaflets to attract valuable customers as there is so many suppliers for the customers to chose from.

  2. I am studying a business called McDonalds. It is a franchise in Corby, Northamptonshire. ...

    There are two major sets of ways to find out this information. There is primary and there is secondary Primary- discovers customer's needs through market research, for e.g. telephone interviews and questionnaires. Secondary- advises customers of production through promotion e.g.

  1. The purpose of this document is to define the Context of Cain Motors Information ...

    Supporting Documentation: Signature: Date: _______________________ ___/___/____ PLEASE FORWARD TO THE CHANGE MANAGER FOR CHANGE APPROVAL GROUP SUBMISSION 3.2. Change request/evaluation 3.3. Change request number 2 The request to develop an interactive web site for the purpose of advertising and booking appointment for MOT's, servicing and crash repairs.

  2. Converting a Formerly Paper Based System to Excel

    can be transferred onto the computer, so that the computer could work out for her, what needs to be ordered, as well as what she is ordering the most of, and vice versa. Hence enabling her to see successful and unsuccessful dishes.

  1. A feasibility study for Grott Video.

    Solutions: Once all the problems have been identified, Jean has the 3 generic system options of a) Do nothing b) Change part of it c) Change all of it If he chooses option b) or c) the following may be of use: By discarding with the need for credit cards anyone would be eligible for membership.

  2. I have decided to create a database for mega video and it is to ...

    I will make the system easier to use and easy to maneuver around the site with clearly labeled buttons. These buttons will open queries, forms and reports. Other buttons will be used to open the user guide that I will make and other Office features such as Word and Excel.

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