Design a computer system for a video hire shop.

Authors Avatar
I work for a video shop called 'Vinnie's Vid's' and he has been moaning about the files. He is complaining that he needs a better way to store files about the users, videos and who has what video on loan. I will make a database for each of the problems and connect them. I will collect the information about users and videos from Vinny. His current system is a paper and pen system, which is too slow and inefficient. It could be lost at any time with only the one copy he will have to start the records all over again. A PC based system is fast, accurate and good for presentations. He has asked me to create a database by using Microsoft Access

Objectives:

* Make a database, which can find a certain type of film in 30 seconds.

* Make a database which can automatically show who has the rented videos.

* Make a database which shows who has overdue videos and how much they owe

Introduction

Choice of Problem:

I have noticed that keeping customer records on paper can be time consuming and neither practical or easy to use. The aim of this project is to create a database for a company or an organization; I have chosen Vinnie's videos. My database will include customer information to make organization and customer relations simpler; the new system will be more practical. An electronic database will make life easier as it will be superior to a card filling system and will save time and money.

A computer system is better than the old card filing method for many reasons. Example, searches can be carried out instantly rather than many manual records being waded through, customer information for a hundred people can be copied almost instantly to a standard letter. Vinny will be able to keep customer information lists, detailing contact information, stats on the customers videos, lists of regular jobs that need to be performed i.e. check who has videos out; in order that notices can be sent using mail merge. This will help Vinny keep up to data and on top of customer relations and business. A search function for my database will make it simple for letters detailing special offers which are customer specific to be sent out easily.

Feasibility:

Both systems have advantages;

Paper (card filling):

* Does not need electricity to run.

* Does not suffer from computer errors, or viruses.

* Does not need trained staff to use.
Join now!


* Contains all the information.

* Can be locked away securely.

* Not easy to search for information.

* You cannot bring up one specific field.

* Uses paper.

* Very time consuming to create a back up copy.

* Easy to damage records.

* It can't be edited, changed amended easily.

* Very difficult to change the record structure.

* Takes up a lot of space.

Electronic:

* Easy to search for information

* You can bring up one specific field.

* Does not ...

This is a preview of the whole essay