Table 1: The Logical Model: Table Descriptions Arranged in Alphabetic Order by Table Name

Table Name Table Description
ARTICLE A table that contains a list of articles that have been or will be published
ARTICLE_CATEGORY A table that contains a list of categories which are used to classify an article
AUTHOR A subtype of the Person table, contains data specific to authors who write for the company
AUTHOR_ARTICLE_PAY An intersection table that correlates Authors and Articles, retaining a record of which author wrote which article
AUTHOR_ARTICLE_WRITE An intersection table that correlates Authors and Articles, retaining a record of which author was paid for which article
EMP_SKILL An intersection table that correlates Employee records to Skill records, retaining a record of who possesses which skill
EMPLOYEE A subtype of the Person table, contains data specific to an employee of the company
PERSON A table that contains a list of people who are part of this organization
PERSON_PUBLISHER An intersection table that correlates Person records to Publisher records, retaining a record of who works for which publisher
PUB_CATEGORY A table that contains a list of categories which are used to classify publications
PUBL_ACTIVITY An intersection table that correlates Employee records, Article records, and Task records, retaining a record of who did what for which article
PUBLICATION A table that contains a list of publications
PUBLICATION_STORE An intersection table that correlates Publication records and Store records, retaining a record of which publications were sent to which stores
PUBLISHER A table that contains a list of publishers
SALE A intersection table that correlates Publication records and Store records, retaining a record of where publications were sold
SALE_ITEM A detail table to sale that itemizes the publications that were part of any single sale
SKILL A table that contains a list of job skills that are important to the running of this organization
STORE A table that contains a list of stores or sale outlets where publications are sold
TASK A table that contains a list of tasks that are done as part of the job within this organization