• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  • Level: GCSE
  • Subject: ICT
  • Word count: 2621

Creating an IT system for an electrical appliance shop.

Extracts from this document...

Introduction

Analysis Introduction Mr Gafoor Saab owns a video shop, which deals with electrical appliances such as Televisions, videos, satellites and digital receivers. His main part of the business is renting Video's and DVD's. As this part of the business is vastly growing He feels the urge to do something with his manual renting system that is not helping him keep track of rentals. Due to his age Mr Gafoor Saab has not got the memory that he used to have and keeping track of overdue rentals is a problem for him as he feels that he is loosing out. He requires a new system that will help him keep track of his business and his customers. Background / Problem Mr Gafoor Saab had a collection of videos that he recorded and bought. He started collecting classic Bollywood movies as a hobby, Gradually the number of movies kept on growing, when friends visited him they would see this collection and ask if they could borrow the movie, so he started lending them to friends. 12 years ago Mr Gafoor Saab lived on Whalley range, not many video shops were open so he decided to open a small video shop in his front room. As popularity through the Asian community grew so did Mr Gafoor Saabs business. Due to such vast growth he has had to keep up to date with technology, as he has started renting out DVDs. In order to keep his business running efficiently and effectively he urgently needs a solution to keep him up-to-date with the running of the business because the old renting system is not working for him, as he feels he cannot keep on top of the system. ...read more.

Middle

Overview Now looking back at the interview with Mr Gafoor Saab I can summarise what I have found out: * Mr Gafoor Saab runs his own business within a growing Asian community and needs to update his manual system * He buys his own videos. * His Shop consists of Hollywood, Bollywood and Pakistani Movies that he rents out to the community. * He keeps record of all videos (new and old) in a book, which he writes over in ink. * Each customer's details are taken each time they rent out a video. * Every weekend he looks for any overdue rentals manually. * He sends letters to the customers, fining them for overdue rentals and asking them to return the videos * His DVD renting system works exactly the same as the video renting. * He also has a selling side to the business and has difficulty remembering what is in stock. * He likes the simplicity of the system but finds it difficult to remember everything. Problems with existing system There are many problems within this present system: * Making sure that you don't misplace the loans book and all the other books containing details of rentals. This could lead to not recording details of customers and loosing out money. * There is no security toward the loans books; any one could alter the records. * Keeping track of overdue rentals is difficult as there is no printed list. The overdue letters are sent via inspection of the Loans book. ...read more.

Conclusion

Deal with the return process by: * Decreasing the no of videos on loan in the correct customer record in the customer file. * Removing the customer reference in the appropriate video record in the video file. Produce reports for the following: * Monthly income information generated by video loans. * Overdue video lists. * Full video lists. * Full DVD lists. * List of videos and DVD's out. * Selective lists based on actors. * Selective lists based on release date. * Selective lists based on genre. * Membership cards for new customers All of the above reports should take only a few minutes to print in either a sorted or selective fashion. Validate the loan by: * Checking that the video and customer exists. * Checking that the video is not already on loan. * Checking that the customer has not exceeded his maximum loan limit. * Checking that the customer is not under the age limit for a particular film. Make Mail merge Menu form Security: * Data Flow Diagrams User skills and requirements Design Entity relationship Diagrams Step 1 Step 2 Step 3 Table Members Fields Member_id Title First_ame Surname Gender Date_of_birth House_No Address Post_code Validation Auto Number Drop down box 15 20 m/f Date 4 30 6 Description Key field Films Fields Film_No Film_name Format Age_Rating Main_Actor Genre Date_Released Validation Auto Number 30 VHS/DVD Drop box 20 Drop box Date Description Key field Rental Fields Date_out Date return Member_id Film_No Validation Date Date Number Number Description Rental Line Fields Video_id Member_id Validation Number Number Description Key field Abdul Basit Farhat Analysis 23/09/03 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Creating a computer system for a video rental shop

    There are no links. All the different files are all kept separate from each other and so there are no links between: The video the person who rented the video and the staff member who rented the video out. If these files were linked relevant data and information could be retrieved.

  2. IT system for local video store.

    The second thing that is also highly inefficient is that fact that staff have to look through records manually to see if a customer has not brought their title back in time for the due date. This is highly inefficient as mistakes can be made and the fact that you

  1. Benefits of using my IT system in the Travel Agents.

    Creating Forms * First, you should go on Microsoft Access. * Then, you should click on Create and click on Form Wizard. * After that, you should choose the Available Fields and they will automatically be inside Selected Fields. * Furthermore, you should click next twice.

  2. Spreadsheet Project - computer system for a video hire shop.

    It also requires training to use, which will have to be paid for. It is a very complicated program and does not contribute to my needs. Quoted from the Gnumeric website: 'The gnumeric spreadsheet is part of the GNOME desktop environment: a project to create a free, user-friendly desktop environment.

  1. Create an IT system for my karate club.

    Also my system should be quite efficient as there is a time factor involved. So when doing a search, say for a persons address, the search shouldn't take too long e.g. if only locating one address it should take no longer than one minute to find the information, but if

  2. Design and Produce a Monthly Account System For the Hazeldene Sub-Aqua Club.

    Anyone born after 1 April 1959 is in the 40 and under age group. People in this group who has not had a medical check up since 1 April 1995, have an outstanding medical inspection. Those that were born between after 1 April 1949 and 1 April 1959 are in the 41 to 50 age group.

  1. Designing a database to manage stock in a clothes shop.

    1.8 Advantages and disadvantages of PC way Advantages *More organization *Better product information *Quick research *Easier to change, add or delete products Disadvantages *Difficult to create such database *Problematic for people who don't know how to use access *Any miss-type may lead to serious problems 1.9 Advantages and disadvantages of

  2. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    MovieZone rents videos out to customers who have completed an application form and become members. MovieZone currently has 90 members and a collection of 200 videos. To do this work and provide these services information is collected and stored about videos and members.

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