Figure 2: Quaternary Relationship
Table Name Column Name Data Type Length Key Status Required Indexed Column Description
EMPLOYEE PersonID Integer 4 Pkey, Fkey Yes Yes Unique identifier for each person, link back to table PERSON
EmpSSN Text 12 Eventually Yes SSN for employee, required by tax law
HireDate Date Date (mm/dd/yyyy) that employee was hired and began work
TASK TaskID Integer 4 Pkey, Fkey Yes Yes Primary key, unique identifier for each task
SkillIDInteger 4 Fkey Yes Yes Foreign key, link back to table SKILL
TaskDscr Text 50 Yes Yes Description of the task
ARTICLE ArticleID Integer 4 Pkey Yes Yes Unique identifier for each article
PublicationID Integer 4 Fkey Yes Yes Link back to table PUBLICATION, each article can be related to a Publication
ArticleTitle Text 100 Yes Article title
DateSubmitted Date Yes Date article was submitted
NbrWords Integer 4 Number of words in the article
PUBLICATION PublicationID Integer 4 Pkey Yes Yes Primary key, unique identifier for each publication
PubID Integer 4 Fkey Yes Yes Foreign key, link back to table PUBLISHER
PubCatIDInteger 4 Fkey Yes Yes Foreign key, link back to table PUB_CATEGORY
PublicationName Text 50 Yes Descriptive name of the publication
PUBL_ACTIVITY PublActivityID Integer 4 Pkey Yes Yes Primary key, unique identifier for each instance of PUBL_ACTIVITY
PersonIDInteger 4 Fkey Yes Yes Foreign key, link back to table EMPLOYEE
TaskIDInteger 4 Fkey Yes Yes Foreign key, link back to table TASK
PublicationIDInteger 4 Fkey Yes Yes Foreign key, link back to table PUBLICATION
ArticleIDInteger 4 Fkey Yes Yes Foreign key, link back to table ARTICLE
DateStart Date Yes Yes Date this task started
DateEnd Date Date this task was completed