Working with databases/Database design/Planning a database/Model answer
From WikiEducator
Working with Databases
Basic skills applicable to planning, creating and using an Access database.
An OP Online course from the National Certificate in Computing (Level 2) programme.
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
