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

    This could happen if the different between the old version and the new version is very big.

  1. Video Rental System

    Price effective date Date/Time dd/mm/yyyy hr:min:sec am/pm ITEM_PRIC_CHGBY_ID Item price charged by ID Number Long Int 0-99999999 STORE STORE_ID Store ID Autonumber Long Int 1-99999999 Y PK STORE_ADDRESS1 Store Address Text 100 X(100)

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

    and assigns them to cost centers or to other cost assignment objects (additional account assignment). Posting to accounting allows you to post costs to the following account assignment objects: - * cost center * Order * Further account assignments: * Cost object * Work breakdown structure element * Network number

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

    This diagram is shown below: The twisted uses two pairs of insulated, solid copper wires, twisted about each other. The twists serve to limit the crosstalk between adjacent pairs, since usually there are between two and several hundred pairs bundled inside a single sheath.

  2. Evaluation of a computerised system

    The main menu is easy to follow. True / False 10 0 Comments towards this statement indicated that the main menu was very easy to follow and needs no improvement. It is easy to navigate around the whole system. True / False 10 0 Comments on this question also indicated that it needed no improvement.

  1. ICT Sample Work Welcome Centre Requirements

    Calculate Beverage Costs per Delegate by multiplying this price by the No. of Servings. Calculate the Total Beverage Costs as Beverage Costs per Delegate multiplied by No.

  2. Betting Shop computer investigation

    Although it must be said if any of the rules are not followed correctly this wouldn't even get as far as the presenting Evidence rule, as there could be no successful prosecution. Preparation Knowing this is a retail betting shop, the first decision to be made is the time that we will serve our warrant to search the premises.

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