designing a database for a Wellness Clinic

Step $3\mathrm{.}1$: Make a list of all entities and their associated attributes.

Step $3\mathrm{.}2$: Make a list of relationships to be represented, and any descriptive attributes for

them.

Step $3\mathrm{.}3$: Draw an ER diagram to represent the enterprise. Be sure to identify relationship

participation and cardinality constraints, any weak entity sets, and rolenames, if needed. Use

Figure S$\mathrm{.}3\mathrm{.}1$ in the sample project as a model for your diagram.

Step $3\mathrm{.}4$ Update the data dictionary and list of assumptions as needed.

Step $3\mathrm{.}5$: Modify the ER diagram and draw an EER diagram to represent the enterprise. Use

generalization and union as necessary to express entity set relationships, adding appropriate

constraint notation. Identify relationship participation and cardinality constraints using

$($min$,$max$)$ notation. Use Figure S$\mathrm{.}3\mathrm{.}2$ in the sample project as a model for your diagram.