Show entities, relationships, and primary key attributes. Do not split an m:n relationship into entities and 1:m relationships; however, if the construct is an event, it needs to be shown as an entity with an id along with the participating relationships. Do not list nonkey entity attributes. Indicate the cardinality of the relationship but do not show minimum cardinality. Do not display the relational (tabular) representation. If you still have doubts, look up the case solutions available under modules.

------------------------------------------------------------------------------------------------------------------------

Humanitarian Action Club (HAC)

Recipient

The Humanitarian Action Club is a hypothetical charitable organization located serving the

essential medical (e.g., dental, nutritional) and counseling needs of the less fortunate in our

society. The beneficiaries of the services are called recipients. Each recipient is given an

identifier along with the name, contact, and other relevant information.

Members

The club currently has approximately 200 members. Each members id, name, address, phone

number, fax number, e-mail address, and membership status are recorded.

Recipient Appointment

When a recipient calls/asks for an appointment or is accepted for a walk-in, an ApptId is

assigned. The date and time, the recipients stated reason, the member, and the attending

provider for the appointment are recorded. For each provider, we store the Provider Id and

name.

Immunization

A standard immunization list using codes and descriptions is maintained. From the list, we can

link a recipient Id with the immunizations. For each immunization entry, the event date is

recorded. A recipient may have some immunizations taken multiple times (e.g., flu or a tetanus

vaccine). Thus, a recipient might have been immunized for the same immunization code at a

later date. The updated information is recorded as a new event.

Game

For encouraging informal meetings and socials among the members, each member is placed in

one of the several teams. Currently, the teams play softball games on certain weekend days and

holidays. Each game is identified by a GameId and is played by two teams. Attributes of a game

include date, field location, team one score, and team two score. Each team is identified by the

team id and described by name.

Course

HAC offers courses for its members. A course is qualified by course id and description. A course

can be offered as classes. A class is qualified by class id, day/time, and room, and pertains to

only one course. A member can take many classes. A course can have many prerequisites, and a

course can be a prerequisite to many courses. The history of course prerequisites, which

indicates the start and end date, needs to be maintained in case the prerequisite discontinues,

and restarts later.