Chapter 6 & 7 of Database Management System by Coronel & Morris (2015) 11th. ed

Normalized Entities and Class Diagram

In this unit, you will work with your group to refine and normalize your list of candidate entity types. You will represent this list in a UML class diagram. 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.

Assemble the group's completed entity list and UML diagram into a Word document. Attach and identify the individual entity lists.