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
	SkillID	Integer	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
	PubCatID	Integer	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
	PersonID	Integer	4	Fkey	Yes	Yes	Foreign key, link back to table EMPLOYEE
	TaskID	Integer	4	Fkey	Yes	Yes	Foreign key, link back to table TASK
	PublicationID	Integer	4	Fkey	Yes	Yes	Foreign key, link back to table PUBLICATION
	ArticleID	Integer	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