Identifying another Relationship Type and Understanding Attributes of a Relationship Type
For Complete YouTube Video: Click Here
In this class, we will understand Identifying Relationship Type and Understanding Attributes of a Relationship Type.
We have already understood how to identify a relationship type between the entity types.
Table of Contents
Identifying another Relationship Type and Understanding Attributes of a Relationship Type
Identifying another Relationship Type
We will consider the same two entity types that we believed in our previous class, the employee entity type, and the department entity type.
The image below is the result we have obtained in the previous class.
Now, you can identify any relationship type.
If you closely observe the manager attribute of the department entity type.
A manager is an employee, so an employee manages the department.
The manager attribute in the department entity type is a manages relationship, as shown below.
We will remove the manager attribute from the department entity type as it converted into a relationship type.
The image below is the ER-Diagram after the conversion.
Understanding Attributes of a Relationship Type
So far, we have seen the attributes for an entity type.
But we can also give the attributes to the relationship type.
From the above image, the manager_satart_date is an attribute related to the manager relationship type, so assign the ‘attribute’ to the manager relationship type, as shown below.
