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. Explain how you would map the given ER constructs into relations. Write 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.