Member Directory:2011 Spring:UML Class Diagram

DEFINITION
The relational model diagram is a database tool for Designer to use to keep track of the relationships between tables. It usually list all entities and attributes in the database. The diagram can help visualize the one to many relationships between tables.

MEMBER COMMITTEE
MEMBER COMMITEE - A listing of each committee that any Member wishes to belong.
 * MemberId - MemberId is the composite key that keeps the Member Committee table records unique.
 * Committee - No sure what this one does. Still under construction.

MEMBER
MEMBER - An organization or an individual whom has paid and is current with all NHHTC member fees.


 * MemberId - MemberId is the primary key for the member table. It helps keep duplicate records from happening.
 * ContactID - ContactId is the ID given to the Member who signs up to NHHTC.
 * MemberType - MemberType is the type of status for the Member when they sign up.
 * JoinReason - JoinReason is the Members reason for joining.
 * ReferralInfo - ReferralInfo is the Members referral information.
 * ExpirationDate - ExpirationDate is the date the Membership is out of date.

CONTACT
CONTACT - A person that which represents either an Individual’s or an Organization’s behalf, and to whom NHHTC can contact regarding member services.


 * ContactId - ContactId is the unique number given to the contact of the Member.
 * LastName - LastName is the last name of the contact person for the Member.
 * FirstName - FirstName is the first name of the contact person for the Member.
 * Address1 - Address1 is the Member's primary contact address.
 * Address2 - Address2 is the Member's secondary contact address.
 * State - State is the Member's contact state.
 * Zip - Zip is the zip code for the Members contact.
 * Email - Email is the Member's contact email address.
 * Phone - Phone is the primary contact phone number for the Member.
 * Ext - Ext is for the number that the Member can be contacted that uses extensions.
 * Website - Website is the Member's website address.

SECONDARY CONTACT
SECONDARY CONTACT - A person for whom a member contact has designated to be an additional point of contact for NHHTC.


 * MemberId - MemberId is the composite key for the Other Contact table.
 * ContactId -ContactId is the contact unique number for other contacts for the Member.

INDIVIDUAL MEMBER
INDIVIDUAL MEMBER - A type of Member that wishes to have himself or herself (and not the organization to which he/she works) affiliated with NHHTC services.


 * MemberId - MemberId is the unique number given to Members in this table, it is also a composite key.
 * EmploymentStatus - The Members employment status.

ORGANIZATION MEMBER
ORGANIZATION MEMBER - A non-profit or for-profit institution that has a desire to belong on the NHHTC directory.
 * MemberId - MemberId is the unique number given to the Members in this table, it is also a composite key.
 * TypeId - TypeId is the number given for the type of member the Member is at time of sign up.
 * SalesLevelId - SalesLevelId is the number given to the category of sales the Member makes on a yearly basis.
 * EmploymentStatus - EmploymentStatus is the status of employment for the Member.
 * NumberofEmployees - NumberofEmployees is the number of employees the member currently has employed.

ORGANIZATION TYPE
ORGANIZATION TYPE - A characterization of an Organization, e.g., telecommunications, agriculture, legal, education, etc..
 * TypeId - TypeId is the unique number given to the type of Member the Member signs up as, at the time of sign up.
 * Name - Name is the name of type of membership.

SALES LEVEL
SALES LEVEL - The amount, in dollars, of annual sales, indicated by levels of less than $1 million, less than $5 million, less than $10 million, and greater than $10 million.
 * SalesLevelId - SalesLevelId is the unique number given to the amount of sales the Member currently makes yearly.
 * LevelDescription - LevelDescription is the description of the different sales levels for the Member.

MEMBER COMMITTEE
MEMBER COMMITTEE - A list of each committee that any Member wishes to belong.
 * MemberId - MemberId is the ID given to the Member at sign up.
 * CommitteeId - CommitteeID is the ID given for the Members Committee at sign up.

COMMITTEE
COMMITTEE - The names of available NHHTC committees.
 * CommitteeId - CommitteeID is the ID given for the Members Committee at sign up.
 * Name - Name is the name of the Committee.

Member – Individual Member – Organization Member
This specialization relationship could be characterized in the following way: Any Member NHHTC must be classified as either an Individual Member or an Organization Member, but an instance of an Individual Member or an Organization Member is always a Member.

Member – Member Committee
This relationship exists because any instance of a Member chooses to belong on, at maximum, many Member Committees; additionally, any Member can opt not to associate with a Member Committee, indicating optional minimum cardinality. Conversely, any instance of a Member Committee specifies one and only one Member. This indicates a one-to-many relationship from Member to Individual Member, with optional cardinality by the Member Committee side.

Member – Contact
This relationship is a unique, one-to-one occurrence where any Member designates one person to act as the point of contact, and each contact is unique to any instance of the Member entity.

Member – Secondary Contact
A relationship which exists in case a Member contact additionally specifies another contact person (which would represent a first normal form violation if left in the Contact entity). So, any instance of Member might list, at maximum, many instances of an Other Contact entity. An instance of Other Contact belongs to, at maximum, one Member. Therefore, this is a one-to-many relationship. Minimum cardinality can be summarized as any instance of a Member entity designates an optional Other Contact, but an instance of an Other Contact mandatory on the Member side.

Contact – Secondary Contact
This relationship is best characterized by stating that any Contact additionally specifies, at a maximum, many Other Contacts; however, any instance of a Contact might, at a minimum, decide not to specify a Other Contact, indicating optional cardinality by the Other Contact side. The Other Contact to Contact relationship is a mandatory, meaning that for any instance of Other Contact, there is only one Contact that associates with that particular instance.

Sales Level – Organization Member
Any instance of a Sales Level describes, at maximum, many instances of an Organization Member. Any instance of an Organization Member is described as having, at maximum, one Sales Level. This indicates a one-to-many relationship. At a given point in time, for any instance of a Sales Level, there is potentially, at minimum, optional occurrences of a given sales level associated with any Organization Member. Any instance of an Organization Member makes enough sales to specify, at a minimum, one Sales Level.

Organization Type – Organization Member
Any instance of a Organization Type describes, at maximum, many instances of an Organization Member. Any instance of an Organization Member is characterized as having, at maximum, one Organization Type. This indicates a one-to-many relationship. At a given point in time, for any instance of a Organization Type, there is potentially, at minimum, optional Organization Member instances described. Any instance of an Organization Member is characterized by, at a minimum, one instance of an Organization Type.

Committee - Member Committee
Any instance of a Committee entity is declared on, at maximum, many Member Committee instances; however, any instance of a Member Committee joins, at maximum, one Committee. This characterizes a one-to-many relationship.

Relational Model Diagram



 * Member Directory Home