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

Introduction

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.

Middle

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.

Conclusion

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

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

    Here are the advantages and Disadvantages of a LTD. The main benefit of having a LTD is that they have Limited liability which means if there in debt they cant take your private property for example your car. The main disadvantage of having a LTD is that it is expensive to setup and the company have to be registered

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

    * Best customer service - arranges pension to some of its employees to be able to get the most keen on working staff, which will be better customer service.

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

    I will also try and keep my customers satisfied. The first year of a new business is really important because if you cannot survive it your business will end up going down hill. 2. Make a profit of any amount.

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

    From this foot-count, I could probably predict what kind of market I would be aiming the pizza shop at. I will also gather ward information from other sources to give me a background about the people within the two areas.

  2. System design for Hollywood Nights Video Rental

    rented on, for how long the video will be rented for and the postcode. He writes this information down in another logbook. Payment is made and the customer leaves the store with the video. Once the film has been brought back the next day, the person is crossed off the logbook.

  1. Excel Project - St. Dominic's Sixth Form College

    I asked him questions to find out what they needed improvement on and here is the outcome of this interview. Q1: Do you have quick access to your computer and have you got Microsoft Excel, also you know how to use the program?

  2. Will a game shop in the UK be successful?

    What price would you pay for a game? Under 10 pounds Under 20 pounds Under 30 pounds Depend on game 7. Who do you buy it for? Yourself Friends Brothers or sisters 8. Where do you find out information about new releases of games? Magazines Internet From others Other 9.

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