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

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