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