Question

Consider the scenario where the company has to automate its systems and wants to store details of its employees where their empno, name, salary, DoB, age, gender and panNo . empno is the primary key, phNo has to be stored. Age is a derived attribute . panNo is a simple attribute Each employee belongs to one the various departments (dno, dname) in the organization. It is mandatory for each employee to get the medical insurance. The insurance details are also maintained (InsNo, Ins Name, InsType, Premium, duration) . Each Insurance is associated with dependent/s (depno, depname, gender, dob, age, relationship). Relationship can be spouse, parent or sibling. Within each Insurance, the dependents are identified by depno. Draw the ER diagram with appropriate notations, relationships with cardinalities and participation constraints. (Note: Make no new assumptions regarding the design and strictly adhere to the given details only)

Answer 1

Solution:

ER Diagram:

The entity relationship diagram represents the various entities and the relationship between them which helps us in understanding how the system works.

The entities are nothing but the real world objects.

These entities are connected using the relationships that are present between them.

Their attributes are mentioned with them and are the properties of the entities.

The ER diagram is represented as shown below.

ER Diagram: