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

Authors Avatar

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. The assistant either answers these from memory or retrieves the information from files.

Join now!

The current system has a lot of problems. GoggleBox uses a large manual filing system which is a very time consuming way to enter and retrieve information.  The extensive use of paper has a damaging effect on the environment as a lot of paper is wasted. It takes a lot of time to fill in forms and create records by hand for new members. Mistakes are often made, records easily get lost if they are put back in the wrong place and they can also get damaged. Large filing cabinets need to be bought to store all these records ...

This is a preview of the whole essay