Database Design Prototype

The basic database will capture the following core information.

• Children

  • ID
  • First Name
  • Last Name
  • Date of Birth

• Parents

  • ID
  • First Name
  • Last Name

• Symptoms

  • Medical Term
  • URL to description in Medline

• Growth

• Children ID

• Weight

• Height

• Head Circumference

• Date

• Symptoms History

  • Children ID
  • Symptom ID
  • Date

• Clinicians

  • ID
  • First Name
  • Last Name
  • email

• Expertise interest

  • Symptoms Set
  • Clinician ID