Describe the concept of the ternary relationship and how a ternary relationship is constructed in a relational database.

Describe the concept of the ternary relationship and how a ternary relationship is constructed in a relational database.