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

    Information Age

    3 star(s)

    Source Information * ZD net (life without an internet) an article * Anonymous written on 20 august 2008. If we didn't have supply of internet or no e-ticketing facilities we can go up to the ticket office, the airport itself or go to the agency and get a ticket.

  1. 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

  2. Threats to Data

    If it cannot it will put the file into quarantine where the virus can do no harm. Running without a virus checker is unthinkable because the effects of viruses can be devastating but they do have their drawbacks and limitations.

  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. The Impact of Mobile Phones on social Interaction

    it important to purchase a mobile phone and are therefore very well suited for the pre-pay plans as they remain in control of how much they spend. This growth in pre-pay is reflected through figures from Vodafone in 2000 which claim that they now have more pre-paid customers (53%)

  1. 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

  2. ICT revision notes - IT project management

    âThere is no looping back to a previous stage. âThe problem with this is that it can be too rigid a method because it is hard to achieve in practice. Advantages âIt offers a simple, disciplined approach to systems development. âEach task is completed fully so you do not need to go back to them later.

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