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

    "Behaviours are embedded in inextricably linked contexts, such that their particular nature may be knowable only within their native context" (Hanson, 1995, p.20). And the behaviour is always fitting. The symptom is in fact necessary to insure the stability of the system (McCourtney, n.d)

  1. According to Weber, what makes bureaucracies efficient? Do you agree?

    Thus, it could be seen that instead of "simple means, procedural regulations become ends in themselves."15 In a sense, the formal aspects of bureaucracy is more important than the substantive ones (serving the client well), and the effectiveness of the whole system suffers accordingly.

  2. Feasibility Report

    o Due to the company going computerised, the Perfect Pie Company will have to shut its doors, until the new system is up and running and in place. Due to this, the company will lose money and maybe regular customers.

  1. Threats to Data

    This not only reduces the number of opportunities for someone to use the data illegally but reduces the number of suspects should the worse happen. It makes sense therefore to restrict the access to the machines holding the data to those people who need it to do their jobs.

  2. System Analysis and Design Assignment

    Stage 3 - Systems Analysis This stage is only performed if there is a positive decision from the feasibility report. This involves the detailed examination of the existing system using various methods, with the aim of obtaining a complete

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

    Again, the information system helps UPS saving money and time by providing information to managers and workers. It provides useful information to the UPS delivery and pick-up van drivers about the vehicle routes and traffics updates. So travel time becomes less and wrong turns are never made; saving the company millions of dollars in fuel costs each year.

  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