iring Example

You wish to develop a database to keep track of new instructor hires for

departments within a university: who they are and when they were hired. An

instructor can be hired by more than one department, not necessarily at the

same time. Each instructor has a set of skills. The university wants to be able to

track which skills an instructor possesses, as well as basic data about instructors

and departments. It is not necessary to include a University entity, but if you do$,$

make some reasonable assumptions about what attributes to include in the

database.

Draw a conceptual model $($entity$-$relationship model$)$ to represent this real$-$

world situation. Use both the Chen notation and the Crow's Feet notation.