• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61

Database Coursework on a Rental System: Design

Extracts from this document...

Introduction

Breakdown of Tasks Description of tasks Expected Date of Completion Consideration of possible solutions 19th October Features of Access 21st October Normalisation 24th October Entity Designs 2nd November Relationship Design 4th November Data input form design 12th November Query Designs 20th November Report Designs 25th November Menu Designs 1st December Macro Designs 7th December Code Designs 11th December Mail-Merge Design 15th December Gantt Chart For Design Tasks 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Consideration of Possible Solutions Features of Access Hardware and Software Specification Entity Design Relationship Design Data Input Form Design Query Designs Report Designs Menu Design Macro Design Code Design Mail-Merge Design Consideration of possible solutions As outlined in the Analysis stage, there are many problems with the current manual system in use for recording, storing and manipulating data. A computerised solution would be the most effective way to tackle these problems inherent in the current system. Obviously, there many types of computerised solution that one can use and different types of software that can be used to design and use the package on. However, firstly I shall discuss the ways one can go about obtaining such a package. These ways include: * Purchasing an off-the-shelf package at a reputable computer retailer * Getting a bespoke package developed specifically to the organisation's needs using a team of in-house developers * Getting a bespoke package specifically developed to the organisation's needs using a team of external developers * The customisation of an generic package Due to the various constraints of the project, namely time and money limitations, and the nature of it being an A level project, using a team of in-house or external developers to develop the package is simply out of the question. It is also not worth it if the task is merely not sufficiently complex to justify a having a specific piece of software developed for the purpose. ...read more.

Middle

The user can select one of these Surnames to display that particular customer's record onscreen. There will also be a "Find Next" button beside the combo box that will be used in the event of customers with the same surnames. Next record, Previous Record, Add record, delete record, save record, archive record and Close buttons will be placed on the form, all with appropriate macros attached to perform these particular commands. A sub-form is included in this form that displays the current rental of that particular customer. This enables the user to check at a glance the details of this said rental, without having to take the time to exit the form and go to the rental form. Code will be incorporated into particular fields in this form, but I shall outline these further on in the code design section of my Design. The customer form will be used every time the manager employs a new member of staff, and the required details must be entered into the system. A Date and Time formula will be displayed on the top-left hand corner of the form for the convenience of the user. A combo box will be used to limit the user's responses to "Male" or "Female" in the Sex field. A combo box will also be used to limit the user's choices in the Working Hours field to "Part-Time" and "Full-Time". Taking away the freedom of the user to enter what they will, by restricting the response to the only two valid ones, means less data entry errors will be made. It also speeds up the data entry process. There will also be combo box from which, upon being clicked, a list of the staff Surnames are displayed. The user can select one of these Surnames to display that particular staff member's record onscreen. There will also be a "Find Next" button beside the combo box that will be used in the event of staff members having the same surnames. ...read more.

Conclusion

Mail Merge Design Fred's Car Rentals 25 Bridge Street BT65 3HU <<Current Date>> <<Forename>> <<Surname>> <<StreetAddress>> <<Town>> <<Postcode>> Dear <<Forename>> <<Surname>> On behalf of the staff of Fred's Car Rentals I would like to wish you a Merry Christmas! 'Tis truly the season to be jolly as, for the duration of yuletide, loyal customers such as yourself will be rewarded with a 10% discount on all vehicle rentals! There are certainly no cries of "Bah Humbug!" coming from the offices of Fred's Car Rentals this winter! So wrap up well and get yourself down to Fred's Car Rentals to take advantage of this goodwill befitting of ol' Saint Nic himself! I look forward to seeing you. Yours sincerely, Fred Breakdown of Completed Tasks Description of tasks Date of Completion Consideration of possible solutions 19th October Features of Access 21st October Normalisation 24th October Entity Designs 2nd November Relationship Design 4th November Data input form design 12th November Query Designs 20th November Report Designs 25th November Menu Designs 1st December Macro Designs 7th December Code Designs 11th December Mail-Merge Design 15th December Design Agreement with End-User Now that the Design 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 Design section of the project is completed to my satisfaction and to the standard that I expect, with all of the features outlined in the analysis designed to my satisfaction. I want you to implement this system to Fred's Car Rentals. I am unsatisfied with the Design part of the project and I don't feel that it has been completed properly. I do not want you to implement this system to 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

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

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    The business six employees, including the manager, assistant manager, stock controller and floor staff. Gantt Chart for Overall Project Number of weeks Tasks 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Analysis Design Software Development

  2. Feasibility Report

    o They will need to create some method for backing up the system and all work on the systems at the end of every working day. The Benefits Of Development Include o The new computer system will mean that invoices can be created instantly when orders are processed into the

  1. transmission of care values

    Illness may affect communication as the service user may have a condition that affects speech, restrict body language and cause messages to be misunderstood (Moonie, 2005). Emotional Barriers Service users may be stressed or depressed due to illness or personal situation.

  2. System Analysis and Design Assignment

    Pick a time and place which is suitable. Detailed questions may be asked with the opportunity to discuss further points. The answers given may be incomplete, misleading or not relevant. The answers given may be as expected (but not what really happens).

  1. Threats to Data

    When the data is retrieved a reverse algorithm is used to make it make sense again. Most encryption algorithms are based on a key, a secret number which must be supplied along with the algorithm. This means a hacker would not only need to know the algorithm but also the key before he could translate the data.

  2. ECOSYSTEMIC PSYCHOLOGY

    gives a context to all behaviours no matter how mad, bad or sad they might be. There is a reason (albeit not always a consciously acknowledged one) driving each seemingly random act. Within their system, a person responds to each situation in the best possible way for them.

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

    Other problems are: Customers would not get the facility to ship, track, and calculate shipping rates as well of making queries of their package online. They had to physically go to the UPS office or make phone calls, emails etc., which would actually make the shipment process long, complex and costly.

  2. ICT revision notes - IT project management

    The waterfall method âIn this methodology one stage of the system is perfected and completed before the next stage is started. âEach task is separate and leads on to the next task. âThere is no looping back to a previous stage.

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