Database

This is a simplified Entity Relationship Diagram of the Ease Database.

All data tables are joined with TermTeachers on:

	Sessionals	Researchers
matching	email, department term contractno	email, department startingdate
term	is valid term (> 1)	invalid term < 1

Sessionals

Researchers

matching

email, department
term
contractno

email, department
startingdate

term

is valid term (> 1)

invalid term < 1

erd