Database Revision 1 (3E1 COM)
Look at the database above and answer the following questions
- State the number of fields shown above.
- State the number of records shown above.
- List suitable field types for all fields in the database.
- A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
- Describe how the dentist can find out which patients live in the town of Lomond.


