Share
Explore BrainMass

Administrative Appointments and ERD

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.

Solution Preview

The ERD to accomplish the required task is presented below. We have the following tables:
• Employees - in ...

Solution Summary

The solution examines administrative appointments ERD for all primary keys, foreign keys and main attributes.

$2.19