Based on the business scenario stated above you will identify the database needs, and then create a conceptual data model to support these needs.
As stated in the scenario we need to track the visits a patient makes to their doctor. Some patient visits are related to a new issue/illness, some are follow up visits to an existing diagnosis and some visits are routine “well patient” visits or checkups. We would like to be able to track which type of visit each instance is so we can keep specific information regarding the visit. For example:
Finally, modify the ERD using a supertype/subtype structure within the Office Visit entity.