• 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

Computing Project

Extracts from this document...


Analysis 1. Background to/identification of the problem I came up with my project idea through a problem my friend, a shop clerk, who runs a DVD rental shop, had faced. He used to rent out DVDs to his registered customers for the price of �1.50 for old DVD's and �3.00 for DVD's which are pretty new but the problem was that he had to do everything without a computer system which made his job quite difficult for him. So I have decided to make a system for his video rental shop as my project which would make it easier for him. The general environment is him behind a counter surrounded by loads of DVDs so he is the only person who works in the shop, there is no staff but sometimes when required, he may get someone to cover for him if needed. The current system in operation works by a customer registering with the rental shop first they then receive their unique membership number which they then quote every time they want to rent a DVD out and then pay the rental price for that DVD. The shop clerk then looks for this membership number through a file which contains all the registered customers and their membership numbers, arranged in order from smallest to biggest and every time a new customer registers they get the next available membership number with in the file. The problem with the current system is that everything is done manually which is really time consuming and may get much difficult to maintain when and if the total number of members for that shop exceeds over 500, as looking for the membership numbers through a list of over 500 can take along time to find. For a solution to this problem I am aiming to come up with a system which will try to reduce the amount of time being spent while dealing with rentals and come up with a computerised system. ...read more.


rest of the fields have data entered in them And error message should pop up As expected 26 Rent Out A DVD When a DVD is not selected but the rest of the fields have data entered in them And error message should pop up As expected 27 Rent Out A DVD When a Price for a DVD is left blank but the rest of the fields have data entered in them And error message should pop up As expected 28 Rent Out A DVD When A Member is trying to rent out more than 3 DVDs And error message should pop up As Expected 29 Rent Out A DVD Renting out a DVD that is already on loan And error message should pop up As Expected 30 Rent Out A DVD Printing the receipt A confirmation message pops up As Expected 31 Returning A DVD Returning A DVD A confirmation message should pop up and the record should be deleted As Expected 32 Returning A DVD When a member has not been selected An error message should pop up As Expected 33 Loans Overdue Testing whether the button to activate a query works. A confirmation message should pop up and a list of all the overdue loans should be listed As expected 34 Loans Testing whether the overdue loans list prints out A confirmation message should pop up and the overdue loans list should print out. As expected 35 Register A Member Testing whether the input masks work The input mask should only accept the data in the format its setup to accept A As expected System maintenance 1. System Overview This is a DVD Rental System which is used by a user who owns a DVD renting shop. Though a username and password facility the user/shop clerk is able register members to the shop giving them the opportunity to rent DVD's from his shop. ...read more.


This will allow me to use the benefits of both solutions. * Setup tables in Access and relate to the Delphi program * Create fields and adjust them easily in Access, an also create validation rules. * It will give me more contrail with the Delphi programming language to carry out complicated tasks. * More freedom with display and layout of the program in Delphi. * Don't have to worry about complex file handling The disadvantages: * Will still need to purchase a copy of Microsoft Access * Need to know how to link both programs together Justification of Chosen Solution The solution I've decided to use is to use both the software developing program together with Microsoft Access. I reached my decision after concluding with the shop clerk who said this was the better than the other 2 solutions. Using this solution will give me more control on the size and layout of the system. It will give me the opportunity to make it user friendly and make it easier to use. Delphi will allow me to use more programming code and I will be able create much more complicated processes using this programming language. Using an application package would give me limited control on the layout and structure of the program which in turn will reduce the user friendliness of the system, but how ever this could be overcome this using Delphi. I can use the application package to easily create related tables with the required fields and then link them to the Delphi program. I will need to create tables which will store member details, DVD details, and Loan details. Handling the tables and validating is easier and simpler in Access. I can use the inbuilt validation options in Access to make sure data is valid before it's stored in the tables. So in conclusion I think using a mix of Access and Delphi I will be able to come up with a solution which best meets the user's requirements. ?? ?? ?? ?? AQA Computing Coursework Kamrul Hassan ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. 140 Computing A-Level Revision Questions

    32. Explain the difference between compilers and interpreters. What are the advantages of one over the other? 33. Write in Reverse Polish notation: i) (A + B)/C*D - B ii) B + G*H -B*C/6 34. Give the advantages and disadvantages of a laser printer over an inkjet printer 35. Describe, with examples, a linear and a binary search.

  2. Justify a particular installation or upgrade. I have installed a Microsoft Visio because ...

    have to connect the manufacture and get a patch for the software that will fix the problem. The user may be used to the old version of the software the for he or she may not like the new software or it may be too difficult to operate the new version.

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    Professional Tax (PTax) Reports Payroll-India caters to the PTax Reports for the following states: - 1. Andhra Pradesh (Monthly) - Not applicable for Mastek 2. Gujarat (Monthly) - Not applicable for Mastek 3. Karnataka (Monthly) - Applicable for Mastek 4. Maharashtra (Monthly) - Applicable for Mastek 5. West Bengal (Monthly)

  2. Video Rental System

    EMP_CITY Employee City Text 100 X(100) Y EMP_ZIP Employee Zipcode Text 11 X(11) Y EMP_STATE Employee State Text 2 X(2) Y STORE_ID Store ID Number Long Int 1-99999999 Y FK STORE EMPLOYEE_HISTORY EMP_ID Employee ID Number Long Int 1-99999999 Y PK, FK EMPLOYEE EMP_LINE_NUM Employee Line number Number Long Int 1-99999999 Y PK EMP_COMP_NAME Employee Company Name Text 255 X(255)

  1. ICT Sample Work Welcome Centre Requirements

    be produced immediately based upon the booking information being entered, * Produce a Quotation that is professionally formatted, and looks very similar to the quotations he uses today. It must be displayed on the screen with an option to print a hard-copy.

  2. Smart Card System

    If the access list is outbound, after receiving and routing a packet to the outbound interface, the software checks the access list's criteria statements for a match. If the packet is permitted, the software transmits the packet. If the packet is denied, the software discards the packet.

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    that the receiver knows when to ``read'' the next bit of the data. In most forms of serial Synchronous communication, if there is no data available at a given instant to transmit, a fill character must be sent instead so that data is always being transmitted.

  2. System I designed in order to produce a promotion package for her newly formed ...

    All the user has to do is type in a birth date and it will give a list of birthdates. This depends if the user uses AND, OR, LIKE or NOT in their search. They can also do this to find the customer address or the way in which the customer wants to pay.

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