Computing

Just another Edublogs.org weblog


Database Revision 1 (3E1 COM)

Look at the database above and answer the following questions

  1. State the number of fields shown above.
  2. State the number of records shown above.
  3. List suitable field types for all fields in the database.
  4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
  5. Describe how the dentist can find out which patients live in the town of Lomond.

Database Revision 1 (3D1 COM)

Look at the database above and answer the following questions

  1. State the number of fields shown above.
  2. State the number of records shown above.
  3. List suitable field types for all fields in the database.
  4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
  5. Describe how the dentist can find out which patients live in the town of Lomond.