Section 2

This section of the assignment requires elaborating a description of a plausible scenario and actions that would need to be performed to justify the database analysis and design that you worked on part 1.

I have developed a database for a health care organization. The database has the following tables: Patient, Doctor, Consultation, Prescription, Drug, Prescription Drug, Patient Drug Allergy, Office, pharmacy, Nurse, Nurse School, Ingriedient, Drug Ingridient.

The description must include

• The type of organization that may take advantage of a database design like this, so you will have to
  • Provide a mission statement for the organization
  • Describe a possible organizational scenario that supports the implementation of the database design
• Techniques that could be used to gather requirements and types/profile of type that should be involved along with the rationale for selecting them
• Context and data flow diagram level-0 supporting the logical design/implementation of the implemented database model