• 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. The purpose of this document is to define the Context of Cain Motors Information ...

    This phase is where all future requirements and expectations of the project to be undertaken should take place and be fully documented. It is as this stage draws to conclusion, that you can fully examine the life cycle objectives of the project and decide whether to proceed with the full-scale development.

  2. A feasibility study for Grott Video.

    Introduction of a computer system network will mean any number of staff can access the member files at the same time (as long as there are sufficient servers). It will also put an end to anyone's struggle to decipher handwriting.

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

    The results that I obtained were more a less expected as people consider the price of chips to be a �1 and a typical bag of fish and chips to be �3.90. I have produced a menu with all the prices the location and the lunch time special deals.

  2. Transcript with Assistant from video shop about record keeping

    We look through all the pages until we find the customer we need information on. How do you add a new customer to your system? New customers, as well as videos or DVDs, are written on pieces of paper and put at the end of the pile.

  1. Business Studies Coursework - start up video rental and buy shop

    to the business registrations office and to do this you must have a solicitor which will cost between �100- �200. Public Limited Company It's not appropriate if I was a Public Limited Company because the company has just started and it is far too small.

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

    IT could also be used to keep records of all suppliers that has to be or has been paid. It could also be used to check the bank statements of McDonalds.

  1. I am opening a new shop in my local area; this shop is going ...

    I have decided to set 3 aims which will help my business run smoothly. My aims and objectives will be: 1. Survive the first year. I will be able to achieve this if I at least break even. This means that my business neither a profit nor a loss.

  2. At present, the owner (Mr Chohan) has a pizza outlet in West Bromwich. He ...

    > Methodology Mr Chohan has decided to open a second shop in the Handsworth area. I have now got to decide upon research methods that I will use to obtain the data. My first objective implies investigating whether there is sufficient demand within the food take-away market.

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