Difference between revisions of "Member Directory:2011 Spring:UML Class Diagram"

From Openitware
Jump to: navigation, search
(Relational Model Entities and Attributes Definitions)
(Relational Model Entities and Attributes Definitions: Added in the entity definitions - Scott)
Line 1: Line 1:
 
==Relational Model Entities and Attributes Definitions==
 
==Relational Model Entities and Attributes Definitions==
 
====MEMBER COMMITTEE====
 
====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.
 
*'''MemberId''' - MemberId is the composite key that keeps the Member Committee table records unique.
 
*'''Committee''' - No sure what this one does. Still under construction.
 
*'''Committee''' - No sure what this one does. Still under construction.
  
 
====MEMBER====
 
====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.
 
*'''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.
 
*'''ContactID''' - ContactId is the ID given to the Member who signs up to NHHTC.
Line 13: Line 15:
  
 
====CONTACT====
 
====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.
 
*'''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.
 
*'''LastName''' - LastName is the last name of the contact person for the Member.
Line 26: Line 29:
  
 
====SECONDARY CONTACT====
 
====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.
 
*'''MemberId''' - MemberId is the composite key for the Other Contact table.
 
*'''ContactId''' -ContactId is the contact unique number for other contacts for the Member.
 
*'''ContactId''' -ContactId is the contact unique number for other contacts for the Member.
  
 
====INDIVIDUAL 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.
 
*'''MemberId''' - MemberId is the unique number given to Members in this table, it is also a composite key.
 
*'''EmploymentStatus''' - The Members employment status.
 
*'''EmploymentStatus''' - The Members employment status.
  
 
====ORGANIZATION MEMBER====
 
====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.
 
*'''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.
 
*'''TypeId''' - TypeId is the number given for the type of member the Member is at time of sign up.
Line 41: Line 47:
  
 
====ORGANIZATION TYPE====
 
====ORGANIZATION TYPE====
 +
*'''ORGANIZATION TYPE''' - A characterization of an Organization, I.E. 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.
 
*'''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.
 
*'''Name''' - Name is the name of type of membership.
  
 
====SALES LEVEL====
 
====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.
 
*'''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.
 
*'''LevelDescription''' - LevelDescription is the description of the different sales levels for the Member.
  
 
====MEMBER COMMITTEE====
 
====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.
 
*'''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.
 
*'''CommitteeId''' - CommitteeID is the ID given for the Members Committee at sign up.
  
 
====COMMITTEE====
 
====COMMITTEE====
 +
*'''COMMITTEE''' - The names of available committees of NHHTC.
 
*'''CommitteeId''' - CommitteeID is the ID given for the Members Committee at sign up.
 
*'''CommitteeId''' - CommitteeID is the ID given for the Members Committee at sign up.
 
*'''Name''' - Name is the name of the Committee.
 
*'''Name''' - Name is the name of the Committee.

Revision as of 13:48, 11 May 2011

Contents

Relational Model Entities and Attributes Definitions

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, I.E. 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 committees of NHHTC.
  • CommitteeId - CommitteeID is the ID given for the Members Committee at sign up.
  • Name - Name is the name of the Committee.

Relational Model Diagram

NHHTC 1.png