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

    Features to be implemented in each time box were agreed in advance and this game plan rigidly adhered to. The strong emphasis on this point came from unhappy experience with other development practices in which new requirements would tend to be added as the project was evolving, caused massive chaos and disrupting the already carefully prepared plans and development schedules.

  2. System Analysis The aim of the Jewellery store system is to make the work ...

    Conversion of the system may proceeds in four ways: o Direct implementation: The entire system is replaced with the new system in one go. o Parallel implementation: Both systems, i.e., the new and the old systems are executed in parallel for a certain defined period of time.

  1. Video Rental System

    Y CUS_ADDRESS2 Customer Address Text 255 X(255) CUS_CITY Customer City Text 100 X(100) Y CUS_STATE Customer State Text 2 X(2) Y CUS_ZIP Customer Zipcode Text 10 X(10) Y CUS_SSN Customer SSN Text 12 X(12) CUS_CREATED_DATE Customer Created Date Date/Time dd/mm/yyyy hr:min:sec am/pm CUS_CREATED_BY Customer Created By Number Long Int 1-999999999 FK1 EMPLOYEE CUSTOMER_RENTAL CUS_ID Customer ID Number

  2. How to minimise the chance of project failing

    Using the wrong kind of tools In order to stop confusion from ordering the wrong kind of tools, managers will have to explain clearly to members of staff what exactly is needed, the tools will then have to be researched and studied in order to find out if it has the requirements to create the project they are working on.

  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. ICT Sample Work India Red

    Quotation can be printed for hard copy. INPUT, PROCESSING AND OUTPUT REQUIREMENTS INPUT REQUIREMENTS Customer Details Fields to be inputted: Title, First Name, Surname, Telephone, Company Name, Address Line 1, Address Line 2, Town, County, Postcode Source of Data: From customer over the phone or face to face.

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

    You need to make sure that the system requirements of your computer meet the needs this will save you time if you do this before installing or upgrading us you will not have to uninstall.

  2. Computing project - testing my library system

    was requested by another member? Highlight member code of member who requested that book ________________ Comments : When return for member code 1003 was confirm, the message shown above was displayed. This message contains the member code of the member who has requested that book.

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