Attributes of Relationship Types
In this lesson, we will take a look at relationships with attributes.
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 ...