AnalysisCategorising 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 ofComputing ScienceDatabase design and development

Categorising requirements

There is no absolute standard in how to collate or categorise end user and functional requirements.

However, it can be helpful to take the view that:

  • end user requirements can be summarised for each user group
  • functional requirements take account of the inputs, processes and outputs necessary for the database to function properly

End user requirements

There are two groups of end-users in the doctor's surgery example, each with different needs:

  • reception staff who must be able to:
    • enrol patients
    • search for basic patient data
    • output appointment letters
    • output a summary of patient details
  • medical staff who must be able to:
    • add medical notes
    • generate onward referrals
    • access more sensitive patient data
    • output prescriptions

Functional requirements

Input (Forms)Processes (Queries)Outputs (Reports)
Receptionist group
Enrol patientSearch/sort by surname, DOB, address, patient IDPatient details
Edit patient detailsAppointment
New appointment
Medical group
Add medical notesSearch/sort by test results, known illness, surname, DOB, patient IDPrescription
Full history
Generate referralReferral confirmation
Input (Forms)Receptionist group
Processes (Queries)
Outputs (Reports)
Input (Forms)Enrol patient
Processes (Queries)Search/sort by surname, DOB, address, patient ID
Outputs (Reports)Patient details
Input (Forms)Edit patient details
Processes (Queries)
Outputs (Reports)Appointment
Input (Forms)New appointment
Processes (Queries)
Outputs (Reports)
Input (Forms)Medical group
Processes (Queries)
Outputs (Reports)
Input (Forms)Add medical notes
Processes (Queries)Search/sort by test results, known illness, surname, DOB, patient ID
Outputs (Reports)Prescription
Input (Forms)
Processes (Queries)
Outputs (Reports)Full history
Input (Forms)Generate referral
Processes (Queries)
Outputs (Reports)Referral confirmation