• 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
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  • Level: GCSE
  • Subject: ICT
  • Word count: 8529

Creating a computer system for a video rental shop

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    However, a lot of ATM machines in unsecure locations may put you at the risk of credit card fraud. So, while using them might be useful in terms of saving time and practicality, you are also put at the risk of being a target of criminals.

  2. Different types of technology How I use ICT at home and at school

    comedy TV series * Gives me an idea of what's happening around the world * Keeps me up on latest news events * A lot of programs can teach me new things * Keep up to date with latest music * Have stuff to talk about with friends and people

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

    Using Formats (in Dates) After you decided where you put your database then first you select on table after that you right click on information then you select design view and then you select 'subscribe start' after that you click on input mask. Using input mask (post code etc.)

  2. Explain the difference between primary and secondary sources of data, with examples.

    Agree Strongly Agree Neither Agree or Disagree Disagree Strongly Disagree Advantages of questionnaires Disadvantages of questionnaire Cheap and quick to conduct compared to other methods. Does not take so long because Fixed response questions mean that answers can be quickly and accurately analysed on the computer.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    This is done, when the member provides the librarian with two envelopes in which his name, address is written. The librarian than makes the reader card for him. In which the member's name, telephone number is written. The members ID# is not written for security.

  2. I will design a new video database for the video shop that will also ...

    The information stored on the paper is also lost easily meaning that rentals aren't kept track of and customer details are lost. Due to the information being unorganised it can be difficult to locate certain information and staff are often overbooking rentals.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Usually user-friendly, easy to understand. Eg projecting graph onto screen Digital representation of data: All data is in a central process unit is processed as electrical currents. Data is usually converted into binary decimals, consisting only 1 or 0, where 1 represents 'on' and 0 represents 'off'.

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

    Time Planning This will take a lot of time as this not just one project but it is a mix of two projects. 1. Choosing the topic- 7 days 2. Recognizing the problem- 3 days 3. Planning the project- this took me 10 days.

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