大象传媒

Analysis 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

Requirements

During the analysis phase, it is necessary to determine:

  • end user requirements
  • functional requirements

End user 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, three different end user groups exist - reception staff, medical staff, portering 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

Portering staff report that they must be able to:

  • know patient whereabouts
  • know the level of patient mobility (independently mobile or mobile with assistance)
  • know if need assistance with communication (e.g interpreter)
  • access where patients appointments are (e.g. x-ray, physiotherapy)