AnalysisEnd user requirements

Inputs, processes and outputs are identified for further design as forms, queries and reports. Specific end user needs are considered when analysing the requirements prior to database development.

Part of Computing ScienceDatabase design and development

End user requirements

During the analysis phase, it is necessary to determine end user and functional requirements.

End user requirements should clearly state the tasks that users wish to perform.

For example, if creating a database for a doctor's surgery, it would be necessary to speak to the employees who would make use of the database.

Developers could ask that each user group lists the tasks that they wish to be able to complete. In this example, two different end user groups exist, reception staff and medical staff.

Reception staff report that they must be able to:

  • enrol patients
  • search for basic patient data
  • output appointment letters
  • output a summary of patient details

Medical staff report that they must be able to:

  • add medical notes
  • generate onward referrals
  • access confidential medical records
  • output prescriptions