• Things of Interest in the Scope of the Data Mode :-
  1. Articles.
  2. Authors.
  3. Correspondence.
  4. Correspondence Elements.
  5. Correspondence Personalization Options.
  6. Departments
  7. Employees.
  8. Organizations.
  9. Positions.

• What are the relationships between these Things of Interest :-
  1. A piece of CORRESPONDENCE can contain one or many Correspondence Elements.
  2. Each CORRESPONDENCE ELEMENT can have zero or many Personalization Options.
  3. An EMPLOYEE can participate and have EMPLOYEE_MEMBERSHIP in zero or many ORGANIZATIONS.
  4. The EMPLOYEE_MEMBERSHIP will be associated with one particular INVOLVEMENT_TYPE.
  5. The EMPLOYEE_MEMBERSHIP will be associated with one particular MEMBERSHIP_ROLE.
  6. The EMPLOYEE_MEMBERSHIP will be associated with one particular MEMBERSHIP_LEVEL.
  7. Each ORGANIZATIONS can have zero or many EMPLOYEES as MEMBERS.

• What are the characteristics of these Things of Interest :-
  At present, the Model shows only the ID field, but in practice, each Entity will have many attributes, for example ...
  1. A DEPARTMENT has a NAME.
  2. An EMPLOYEE has a NAME.
  3. An ORGANIZATION has a NAME. Etc..

Barry Williams
Principal Consultant
Database Answers