Q1. Make an E-R diagram for the given problem definition:

Each company operates 4 departments, and each department belongs to 1 company. Each department uses one or more employees, and each employee works for 1 department. Each of the employees might or might not encompass one or more dependants, and each dependant belongs to the 1 employee.

Q2. Illustrate the various kinds of constraints imposed on the Generalization in an E-R diagram?

Q3. describe how you would map the given ER constructs into relations. prepare down appropriate illustration?

a) Aggregation

b) Ternary relationship

c) Inheritance

Q4. Describe the various possible states of the transaction with the assist of a diagram.