• 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)

    CCTV is generally used for surveillance. They are generally in places where there are risks of crime taking place. The metropolitan site is used to help capture crimes not seen by CCTV cameras or lacking evidence. People can report crimes and also stay confidential.

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

    A box will appear on the right of the screen. Select Blank Database. A window will appear asking you where you want to save your table. Then click create when you have found the right location. Using Formats (in Dates)

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

    Television distracts you, causes you to become lazy and inactive and engages you with all the shows it provides. While you can learn stuff from TV, you can also become negatively influenced. Sex, drugs, violence, these are all shown daily on TV.

  2. 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'.

  1. This report I will be writing, will be on the way I do activities ...

    * Nowadays they aren't very expensive to buy. Disadvantages Just as there are advantages there are also disadvantages to USB Pen Drive such as: * You have a limited amount of storage - some files may be too big to hold in the USB Pen Drive or you may have too many files on it.

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

    be handed out and are not as time consuming or expensive as interviews would be. Although cannot be as accurate because people do not have the chance to express themselves like they would in a interview so may just end up ticking a box that they don't agree with because there are no other options.

  1. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    This will have a validation rule of "Mr, Mrs, Miss, Dr, Mastr, Other" > Surname - This will be of the text format and be up to 25 characters long. > Forenames - This will also be of the text format and will be up to 20 characters long.

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

    Next I surveyed my friends to find out what all information does they need when they want information for a particular book. Software planning- When we were first told about this project, there were various software?s from which we could choose.

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