• 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

Database Coursework on a Vehicle Rental System: Analysis

Extracts from this document...


Introduction I am a student starting my second year of A levels at a College of Further and Higher Education and one of these A levels is ICT. The A2 part of the ICT A level consists of three modules, one of which is coursework and it is worth 40% of my overall A2 grade. The coursework requires me to identify and conduct research into an open-ended problem that exists for a real end-user. From results of this preliminary research, I must design an appropriate ICT-based solution for the problem using the skills and knowledge that I have acquired throughout the duration of my course. After designing such a solution, I will develop the actual software to be used to address the problem along with the technical documentation. This software will then undergo extensive testing so that I may identify and correct any bugs that may be present within the system. Plans on how the system will be implemented will then be made, including any training the staff will need and how existing data will be transferred into the new system. Finally, the User Documentation will be produced and I will evaluate the system on a number of various criteria to see if it meets the requirements outlined at the analysis stage. Throughout the whole process, I will be using the skills and experience that I've acquired in the first year of the course (and what I will be learning this year) to incorporate a wide range of advanced features and functions into the system, and to complete the project to the best of my ability. Background Information The business that I will be developing a database for is a car rental firm known as Fred's Car Rentals. It is a small, family-run business that rents out automobiles to customers for a period of time in exchange for a fee. Its customers include travellers from other countries that need a set of wheels to get around for the duration of their stay and owners of destroyed or damaged vehicles that are waiting on repairs to be conducted or insurance compensation. ...read more.


However, this means that theoretically anyone could just walk in and help themselves to the company's data. Furthermore, in the event of a break-in, a criminal with appropriate tools would not have much of a problem breaking through a flimsily locked filing-cabinet. However, with a computerised system, the criminal would have to guess a password and username, which, whilst there are ways it can be done, is significantly more difficult than smashing a lock. * Inaccurate Data: - For a multitude of reasons (many of which are mentioned above) data in this system can be inaccurate. One reason that data can be inaccurate is due to plain human error. Although we have come along leaps and bounds since our tree swinging days, and achieved so much collectively as a species; the human animal is fundamentally flawed as an information processor. This is because we make mistakes, varying in folly and severity, on a regular basis. Mistakes such as transcription errors, or the misreading or mishearing of information when recording data lead to inaccurate data being entered into the system. In a computerised system, these mistakes can be minimised using data validation methods that narrow the field of acceptable data that can be entered into the system. * Inconsistent and Redundant Data: - Data in the current system can be inconsistent and redundant, because the same data may have been entered into the system more than once. In a computerised relational database system, data has only to be entered once and then linked to the other entities via relationships between the files. End-User Requirements During the interview with Fred, and my hours of observing the working environment of Fred's Car Rentals, a number of user requirements have been identified, which I shall now list below. The system must: UR1: enable manufacturer details to be added/edited/deleted/ displayed onscreen/printed; UR2: enable staff details to be added/edited/deleted/ displayed onscreen/printed; UR3: enable the return date of the rental to be calculated automatically; UR4: enable rental details to be added/edited/deleted/ ...read more.


There will be a user guide produced at a later stage in this project that will assist the users in their understanding of how the system works and the acquisition of the skills necessary to operate it. This will include step by step instructions on how to perform reports, queries and input data into the system via forms as well as a troubleshooting section to assist the user with commonly encountered errors. In the event that the user guide is not sufficient in teaching the users how to use the system, or that the basic ICT skills of the staff are simply not up to scratch, it has been arranged with Fred that a series of one day training sessions will be provided at a cost of �500 per day. Breakdown of Completed Tasks Description of Task Date of Completion Identify Problem 20th September Investigate Current System 25th September Analyse Findings 30th September Analyse Current User Activities/Data 2nd September Analyse Problems with Current System 6th September Identify End-User Requirements 8th September Identify System Requirements 12th October Create Performance Criteria 17th October Consult with User 18th October Breakdown of Completed Tasks Analysis Agreement with End-User Now that the analysis stage has been completed, I am presenting it to Fred, the manager of Fred's Car Rentals, so that he can inspect it to see whether it meets the standard that he expects. If Fred does not agree that this section is completed to the standard that he expects, then my assignment will end here. Having studied the analysis: I agree that the analysis section of the project is completed to my satisfaction and to the standard that I expect, with all of the features included. I want you to design this system for Fred's Car Rentals. I am unsatisfied with the analysis part of the project and I don't feel that it has been completed properly. I do not want you to design this system for Fred's Car Rentals. Signed: _______________________ Date: _____________ Manager of Fred's Car Rentals ?? ?? ?? ?? 1 ...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 Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Here's what a teacher thought of this essay

5 star(s)


Undoubtedly this is an A grade analysis. It contains the various components that are required and goes into a great deal of detail about all the elements one would expect to find in an analysis. The student has also avoided the pitfall of waffling and most of what is written is succinct, accurate and relevant.

Some suggestions for improvements to perfect this...

1. Depending on the specification requirements (and these could be easily checked) the following things need to be checked:

a) Is there a requirement to evaluate other solutions to the problem? For example, the assumption all the way through is that this is going to be a database (and obviously this is the case) but some boards expect to see evaluation of other techniques for example, a spreadhseet to solve this.
b) Whilst the field lists for each table are shown there are no entity-relationship diagrams and there is quite a "jump" to the list of fields. It would be useful to highlight the key fields in each table but I suggest that this is tricky without the aforementioned ER diagrams; for example, there may be some combined key fields.

The writer has clearly got a grasp of the systems life cycle process and I have every confidence that they will complete the rest of the project successfully provided they continue as they have started. The URs and QOs give a good opportunity to underpin the development of the system with real criteria that are meaningful and provided they are referred to throughout (along with frequent discussions with the client) the finished solution should be one that is exactly what they are looking for.

Overall this is a 5 star piece of work.

Marked by teacher Ad Son 04/10/2013

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 Information Systems and Communication essays

  1. Peer reviewed

    Verbal and Non - verbal Communication

    4 star(s)

    There are many ways of communicating. Different parts of the world have their own set of nonverbal cues. Different cultures have different ways of interpreting and understanding non-verbal cues. For example when meeting a person for the first time, Americans put high value on eye contact and usually limit their touch to firm handshake (Kimberley, 2003, p.182)

  2. Some advantages and disadvantages of information technology

    Creation of new jobs - Probably the best advantage of information technology is the creation of new and interesting jobs. Computer programmers, Systems analyzers, Hardware and Software developers and Web designers are just some of the many new employment opportunities created with the help of IT.

  1. Unit 21: Working with ICT Hardware and Equipment

    * If protective clothing needs to be worn, the customer needs to be able to know when and what needs to be worn at specific times. Customer Acceptance When installing software it shows up a box (like below) telling us the terms and conditions of the software.

  2. ICt coursework evaluation

    So, there will not be any problems like duplication of data, etc. d. It should be relatively easy to add, delete or make new records. For example, add or delete, a customer form the database. Also make simple changes in the database, such as correcting the name of a customer.

  1. Business and Information Technology, What are the input, processing and output of UPS package ...

    What technologies are used by UPS? How are these technologies related to UPS's strategy? UPS uses Cisco Systems to track and calculate costs of the packages. It also uses GPS systems to track shipments. It built up a strong IT network and database in order to collect and track data for every single package.

  2. How will ICT affect education, employment and transport of the future?

    All these additional factors are already being used nowadays. Regarding to paper-and-pencil, ordinary stationary will cause our hands very tired and the outcome of our work could be messy and scrappy. People sometimes write scribbles on paper and it can be irritating.

  1. Evaluate the use of e-commerce in a brick and click organisation

    This may cost a lot of money and customers may feel uncomfortable putting their details on the website knowing the risks. This wouldn?t happen in a brick store, the only security risks they have are usually theft or violence which can easily be solved and prevented with security guards.

  2. Generate valid, accurate and useful information and justify the information selected to support a ...

    I decided to only use the information that was relevant from both data sets and merge them together to make the data easier to finalise a result. I took the percentage of those aged 25-34 from the ?Local area? data set and then took the annual pay from the Local

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