- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
Ternary Relationship in Database
In Ternary relationship three different Entities takes part in a Relationship.
Relationship Degree = 3
For Example: Consider a Mobile manufacture company.
Three different entities involved:
- Mobile - Manufactured by company.
- Part - Mobile Part which company get from Supplier.
- Supplier - Supplier supplies Mobile parts to Company.
Mobile, Part and Supplier will participate simultaneously in a relationship. because of this fact when we consider cardinality we need to consider it in the context of two entities simultaneously relative to third entity.
Cardinality in Ternary Relationship
- Say for a given instance of Supplier and an Instance of Part, can that supplier supply that particular part for multiple Mobile models.
Example − Consider a Supplier S1 that supplies a Processor P1 to the company and the uses the Processor P1 supplied by Supplier S1 in its multiple Models in that case the cardinality of Mobile relative to Supplier and Part is N (many).
- In case of Supplier’s cardinality we can say for a given instance of Mobile one of its Part can be supplied by multiple Suppliers.
Example − Consider a Mobile M1 that has a Part P1 and it is being supplied by multiple Suppliers in that case the cardinality of Supplier relative to Mobile and Part is M (many).
- Similarly, for a given instance of Supplier and an instance for Mobile does the Supplier supply multiple Parts.
Example − Consider a Supplier S1 supplying parts for Mobile M1 like screen, Processor etc. in that case the cardinality of Part relative to Supplier and Mobile is P (many).
- Related Articles
- Binary Relationship in Database
- Entity Relationship Participation in Database
- N-ary Relationship in Database
- Importance of Entity-Relationship diagram in database design
- Ternary Search
- Ternary Operator in Java
- Ternary Operator in Python?
- Ternary Operator in C#
- Ternary Operators in C/C++
- Ternary Expression Parser in C++
- Conditional ternary operator ( ?: ) in C++
- Ternary Operator in Dart Programming
- How Ternary operator in PowerShell Works?
- What is ternary operator in C#?