Video Rental System: analysis

Authors Avatar

        

Identify a problem

Video shop

 The owner of a video rental shop asked me to organise his business.

 He is completely disorganised and he is always losing important files and scraps of paper.

The owner of the video rental shop bought a computer and asked me to devise a system for him.

 I decided to use a database system, which will help his business to be more efficient.

. A record of all the videos has to be kept so that if a customer comes in and make

  enquires about a specific video, shop assistants can immediately inform them

  whether they have it in the shop at that time.

Join now!

. A record of customers has to be kept with the video they have on hire so that

   overdue notices can be sent if required.

. The various pricing strategies have to be calculated so that special offers such as

   ‘hire three get one free’ and other can be applied.

 

I have talked to the owner of the video shop

and he has given me these requirements.

The database system must allow him to see details

of customers quickly and easily.

The new system must be able to give me information

of all the video’s ...

This is a preview of the whole essay