What is an E-R model? Draw an E-R Diagram for the company database with following
Descriptions:
The company is organized into departments. Each department has a unique name and a unique number with several locations.
A department controls a number of projects, each of which has a unique name, unique number and a single location.
We store each employees name, social security number, address, and salary. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same departments.
We want to keep track of the dependents of each employee for insurance purposes. We keep each dependent's name, age and relationship to the employee.