Attributes of Relationship Types
In this lesson, we will take a look at relationships with attributes.
We'll cover the following...
We'll cover the following...
Attributes of relationship types
Relationship types can also have attributes, similar to those of entity types. Hence the relationship WORKS_ON between EMPLOYEE and PROJECT has an attribute Start_Date. This is illustrated in the diagram below:
Generally, it is not recommended to give attributes to relationships if it’s not required because when we represent this ER diagram in the database, we don’t want to create a separate table for each relationship with attributes as this ...