• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  • Level: GCSE
  • Subject: ICT
  • Word count: 8529

Creating a computer system for a video rental shop

Extracts from this document...


sis Introduction ABZ World is a video rental shop, located in Stoke Newington town centre. It is a relatively small shop and has 300 members, who live in and around Stoke Newington. The shop is owned and managed by Abdullah Elgayar. He set up the business two years ago and has two other staff working in the shop on a part time basis. Abdullah currently has a filing system that occupies a great deal of space and is very time consuming to analyse. He gives his members cards and has to manually record which video members are hiring. The old paper filing system is very inefficient in notifying when members are overdue with bringing the videos back. This in turn means other customers are unsatisfied when the video they want isn't in stock and so Abdullah loses out on revenue. His shop has not got much space and the filing system is taking 1/4 of the shop floor, more spaces are needed for videos and the shop at the moment is looking crap and tight costumes feel isolated and do not get to look around and look at covers of videos as the shop can get cramp, card board standing posters have been scraped this makes advertisement of movies hard. Costumers will not know when the new videos have arrived this make business in his shop go down. More and more children are coming to the shop and Abdullah says "I have very little movies for young children if I don't sort it out they will go someplace else. He is also opening another Abz World in wood green centre about 15 miles away and he would like to link up both shops. Abdullah possesses greater than average IT skills and is keen to introduce a computer-based system for the rentals of his videos. If we make both shops have a computerized system Abdullah will be able to link both shops and have plenty of space for videos and advertisements and costumers can return videos in both shops. ...read more.


Evaluation of possible software solutions I have decided to recommend the use of Access to the clients as being most suitable because it seems to offer more facilities and features, which will help me in designing a program for the, clients. Access is more usable than both Excel and Pascal and the end users will find the system easier to use as the system will save time by cutting out repetitive tasks and will give them quick access to the information they need. A system designed is Access should give a very user-friendly interface and will function in the way the client's want in to. Access is a quick database and is quick to open files and change to new pages. Access will really provide a solution to the client's needs, as it is a diverse program, which can be used in many different ways. Another very good thing about Access is that it will be very easy to upgrade, introduce new functions and make modifications as and when they are necessary. Comparison of Possible Solutions A number of possible solutions could be considered: * Use of Excel Spreadsheet * Use of Access Database Excel is a spreadsheet of considerable power including database facility. However the relationships required would be difficult to implement in the time scale available. The final solution might also be difficult for the end user to understand and maintain. Access has all the capabilities required and is the preferred option for the end user. I have experience of using Access and some Visual Basic knowledge that can be used for enhanced customisation. Using Access it will be possible to: * Create and edit tables * Create and edit relationships * Create forms and reports based on tables * Create customised input screens and using Visual Basic facilitate searches and validation procedures * Create queries to find specific data * Create a menu driven system * Implement security provision. ...read more.


Encryption Encryption is where data appears garbled unless you know how to decrypt the data. Other Security Recommendations I would suggest the user have various security measures for the system, these include: - * A security manager who can oversea and monitor all terminal activities. * Keyboards and monitors to be locked via a password when they are not being used or are left unattended. A screen layout for a user interface screen Screen layout design for open all data input forms Screen layout design for open all data output reports Screen lay out for all data input forms Member Form 1 Book Form Borrowing form Reserving form Specification of the query criteria including any sorting This query is designed for a report to be sent to the borrowers who did not return the borrowed videos in time and also show how many days these videos been delayed. Three tables will be used in this query: member table to get member details, borrowing table to get borrowing date and transaction table to get transaction ID and member ID. A calculated field will be generated called days: Date Diff("d"),{Date of borrowing},Now)) In the criteria row of the QBE >14 will be inserted, where 14 are the allowed time for borrowing. This query will calculate the number of delayed days A simple example of the use SQL When a user create a query , Access automatically convert his action to programming language called Structured Query Language (SQL) For example the table blow shows different video with different prices This SQL allows selecting all videos price more than �20 SELECT: video, cost FROM; Table1 WHERE. cost)>"20" video cost Computing 17 Access 97 45 Database design 35 Web design 18 The result after this query is applied will be all the books which cost more than �20: Access Database design Report layout designs Overdue books report Books out. Not ification report Test Plan The reason for the test plan is to see that the designed library database is able to function well with different operations 1-member record ...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. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    Specific for Word processing that is what I need it for, in this write up. It incorporates many advanced features, e.g. table of contents, that otherwise would take along time to produce. Excel A very advanced spreadsheet program, which will enable me to make a accounting package, with the use

  2. Video Rental Shop I.T. System

    INVESTIGATION: The shop assistants have great difficulty with overdue videos, new member additions and seeing weather a video is on rent and who to, this is why the video shops owner Barry has to employ ten members of staff. With the aid of a computer all the tasks above could be very simple to carry out.

  1. Database advantages and disadvantages for a user.

    Database you can bin information if you don't need it and it can saved a lot of space.

  2. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    I printed what I wanted. There should have been pictures inside it to show it more easily I am testing to save my work. When you want to save your work you go to file which is in the top left hand corner and the click on save as, then you choose where you want to save your work, then it is saved.

  1. ICT Leisure Center

    We need the LAN network, some wires, Network Laser printer & some graphic cards. Network Laser printer needed. Gaming zone In the gaming zone we need the communication system for linked the computers with each other. We need IT system for special effects of lightening.

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

    charts, make predictions etc Justification of Chosen Solution For my project I could use a number of spreadsheet programs, which include: > Quantrix 2.0 > Gnumeric > Microsoft Excel Quoted from the Quantrix website: 'with its extensive compatibility, plain English formulas, comprehensive API, and multiple views, Quantrix is one of the most powerful spreadsheets available today.

  1. ICT car insurance quotation System Coursework

    formulas to store the multiplier figures so the quote can be calculated. Below shows what the spreadsheet looks like once all the VLOOKUP functions have been entered. Column G produces the information in words and column H produces the multiplier figures.

  2. Computer study project outline - library and book club database.

    Planning of my Method- Project Planning- First I made a clear idea about my database by writing what am I going to include in my database and what all problems I am going to solve. First I researched the problem by going to the library and by asking questions to the book lovers.

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