A tiny college wants to keep track of the history of all administrative appointments (date of appointment and date of termination) (hint: time variant data are at work)
The tiny college chancellor may want to know how many deans worked in the college of business between january 1, 1960 and january 1 2008 or who the dean of the college of education was in 1990:
Given the information, create the complete ERD containing all primary keys, foreign keys and main attributes.