Create an er diagram for each of the descriptions

Assignment Help Database Management System

Reference no: EM13787219

Create an ER diagram for each of the following descriptions:

(a) Each company operates four departments, and each department belongs to one company.

(b) Each department in part (a) employs one or more employees, and each employee works for one department.

(c) Each of the employees in part (b) may or may not have one or more dependants, and each dependant belongs to one employee.

(d) Each employee in part (c) may or may not have an employment history.

(e) Represent all the ER diagrams described in (a), (b), (c), and (d) as a single ER diagram.

Reference no: EM13787219

Questions Cloud

Risk management in new technology deployment projects : Write a Dissertation on "Risk management in new technology deployment projects"

Factors helping corporate businesses to become sustainable : Write a Dissertation on Topic "Factors helping corporate businesses to become sustainable in supply chain logistics management in Qatar"

Debate is health care a right or a privilege? : Normal 0 false false false EN-US X-NONE X-NONE Debate Is Health Care a Righ..

Create an er diagram for each of the descriptions : Create an ER diagram for each of the following descriptions: (a) Each company operates four departments, and each department belongs to one company. (b) Each department in part (a) employs one or more employees, and each employee works for one depa..

Training needs for coca cola company : Training Needs Analysis Coca Cola Company

Where the offices are located : You need to create a fictional organization (or a real one) for which you will give a presentation. You should describe the organization in detail, providing necessary information such as the size of the organization, type of organization, where t..

Determine general security architecture for the company : Determine the most important assets of the company, which must be protected, Determine general security architecture for the company

How you assist organization in accomplishing their goals : Where they are: The organization's current security and how they handle emergency situations, Where they should be: Where the organization should be with the level of their security and emergency management, How you'll get there: How you will assist ..

User Account

All Pages