SUBMISSION A:

Using a UML modeling tool of your choice create an Entity-Relationship diagram (ERD) with the data model for the MedicalData2 database to reflect the following business rules:

Hospitals employ many physicians and physicians may work at several hospitals (use associative entity PHYSICIAN_ROSTER)

Physicians have many patients and patients can have many physicians (use transactional entity APPOINTMENT)

Medical plans cover many patients and patients may be covered by several medical plans (use associative entity COVERAGE)

Many patients may undergo many operations (use transactional entity OPERATION)

A schedule of one or more procedures can be performed in an operation (use dependent/weak entity SCHEDULE)

Implement overall ten (10) entities:

APPOINTMENT

COVERAGE

HOSPITAL

MEDICAL_PLAN

OPERATION

PATIENT

PHYSICIAN

PHYSICIAN_ROSTER

PROCEDURE

SCHEDULE

Differentiate the types of entities in your diagram by using the following colors:

Regular/strong yellow

Dependent/weak blue

Associative red

Transactional green

or explicitely specify the types of entities.

Note that the database from the previous assignment HAS NOTHING TO DO with this one.

SUBMISSION B:

Implement the data model described by your ERD (create requisite entities, implement all constraints).