Member Directory:2011 Fall:Class Diagram Description

Member Directory

MembershipSignup RequestID(pk), FristName, LastName, Company, Jobtitle, street, pobox, address2, city, state, zip, phone, ext, cellphone, email, website, typeofbusiness, number of employees, busnessdescription, compnaysales, membershiptype, committee.

One requestID instances makes, at maximum, one pending Member

PendingMember MemberID(pk,fk) RequestID(fk) RequestDate

One pending member instance makes, at maximum, one member

Member MemberID(pk), ContactID(fk), RevenueID(fk), TypeID(fk), CompnayID(fk), OrganiaztionName, Profile Description, EmployeeCount, Referralinfo, ApprovealDate, Membershiplength, RenewDate.

One search instance makes, at maximum, many memberiD

MemberSearch MemberID(pk,fk), Company, LastName, City, State, Industry

One revenueID instance makes, at maximum one Member(revenueID)

Revenues RevenueID(pk), LevelDescription

One type instance makes, at maximum one Member(typeid)

Type TypeID(pk), Name

One member instances makes, at maximum many memberCommtte. MemberCommitte MemberID(pk,fk),CommitteID(pk,fk)

One membercommitte instance makes, at maximum one Committee.

Committee CommiteeID(pk), Name

One member instinace makes, at maximum many contacts.

Contact ContactID(pk), LastName, Fristname, Jobtitle, address1, address2, state, zip,email, phone, ext, website.

One contact instance makes, at maximum many secondary contacts.

Secondary contact MemberID(pk,fk) ContactId(pk,fk)

One member instance makes, at maximum many secondary contacts.

Company CompanyID(pk), ContactId(fk), Insdustry, Location, Numberofemployees, Descritpion

One member instances makes, at maximum one company.

One company instance makes, at maximum many contacts.