Working with databases/Database design/Planning a database/Model answer

From WikiEducator
Jump to: navigation, search
OtagoPoly Logo S.png

Model answer

Suggested fields for patient database (Dr Fixit Medical Centre):

  • First name
  • Last name
  • Address
  • Home phone number
  • Work phone number
  • Mobile phone number
  • Date of birth
  • Doctor's name
  • Prescription details
  • Cost of last visit

Please note
This is a suggestion only - there is no single right answer, although some of the fields above are probably essential!

Return to Planning a database