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

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    By creating sophisticated interactive prototypes, it's even possible to model use-cases and operational sequences through a design. This allows for particular operations to be tested and refined without the enormous effort that would be required if a design were to be implemented without prototyping.

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

    The selection screen captures the following information: - 1. The PTax report can be generated for a PTax grouping created for the Personnel Subarea. 2. The report is printed in the relevant format for each state as applicable and for those employees for whom the PTax and return is applicable.

  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. Video Club Database Project

    Loss of records. Solution A. Use of a cupboard. Advantage All the records will be arranged in the cupboard drawers. Disadvantage It takes a lot of place Solution B. Used of a computerised database. Advantage Access to the information is rapid and there is less likelihood of the data becoming lost.

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

    These time-slots are then distributed between the slower channels. If there are three channels a, b and c to be sent they can be divided into one channel for example as follows: |-a-|-c-|-a-|-b-|-a-|-c-|-a-|-b-|-a-| TDM is the technique used in today's optical fibers but will probably is changed to WDM.

  2. I have been given the task to design a database for a company called ...

    The note is mainly for the recipient and delivery person, this means that it won't need to carry very much information. For instance it will not need to carry the price of the parcel delivery. The recipient will need the information on the customer sending the parcel and the delivery person needs the information on the destination.

  1. Spare Parts Database Project

    When a client comes to fetch his order, he must spend time in searching for it. 1.4 Objectives of the new system. The objectives may be stated in both quantitative and qualitative terms. 1. The system should consist of a proper database to hold records, so as to minimize loss of records.

  2. How to minimise the chance of project failing

    important if the mangers warns the client if any further requirements are needed, otherwise the client will be warned that no changes will be carried out during the process of the project. Not enough proper time to research and plan Before starting any project, planning is extremely important to be

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