My example will be using Doctor, Hospital, Patient. I need the entity type including an appropriate identifier (primary key) and attributes. The following will be entity type conforms to 3NF. No repeating groups, no partial dependencies, and no transitive dependencies.

To prepare for this assignment, review the scenario and the group's comprehensive entity list. For each one, suggest at least 3 attributes that describe aspects important to the organization (for example, each patient has a name). Determine whether any of these attributes constitute a natural unique identifier, or whether the entity type requires an arbitrary (surrogate) key. As a group, complete the following tasks:

Share and discuss all of the individual lists.

Based on the discussion, revise the comprehensive list and agree on candidate attributes for each entity type.

Ensure that each entity type is in third normal form (3NF). To do so, evaluate whether any entity has repeating groups (1NF), that every attribute of an entity depends on the entire primary key (2NF), and that no non-key attribute can determine the value of another non-key attribute (3NF). Split entities into two or more parts if necessary.

Create a UML class diagram that represents your normalized entity list.

Determine relationships (or associations) needed among the classes. Add these relationships to the UML diagram.