Sketch the eer diagram for unique number and single location – Software Engineering
The next coditions explains firm who want to implement info system. Firm want to hold observe of its workers, departments, and tasks. Assume that MIS division of firm did necessities assortment and Assessment part and offer you specification report with following description:
“The corporate is organized into departments. Every division has unique title, unique number, and specific worker who manages division. We hold observe of begin date when that worker begin managing division. A division could have a number of areas.
A division controls number of tasks, every of which has unique title, unique number, and a single location.
We retailer every worker’s title, social insurance coverage number, deal with, wage, intercourse, and start date, Worker is assigned to at least one division however may fit on a number of tasks, which aren’t important managed by similar division.
We hold observe of number of hours per week which the worker works on every undertaking. We additionally hold observe of direct supervisor of every worker.
We want to hold observe of dependents of every worker for insurance coverage functions. We hold every dependent’s first title, intercourse, start dale, and relationship to the worker.”
a. Sketch the EER Diagram for this case.
