- 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
Explain Mapping the ER diagrams with binary and ternary relationships(DBMS)?
It is the relationship between the instances of two different entity types. Two entities will participate in the relationship.
Person and events are two different entity types which are related by using the relationship called “attends”.
Mapping ER diagram with binary relationship
Mapping one to many relationship
Create two tables for two entities.
Primary key of one side relation is a foreign key for many side relations.
One side relation is customer and many side relations is Order.
The primary key cutomerID of the customer is a foreign key of order.
The equivalent relations for the above ER diagram are as follows −
One-one, many-one, many-many can be done in a similar fashion.
A simultaneous relationship between the instances of three entity types with unique attributes is called a ternary relationship.
Consultant, client and contract are three different entities with different attributes.
These three entities are related with a single relationship called “signs”.
Three foreign keys of works in the table are empID, deptID, pID.
They refer to the primary key of an employee, department, project.
These attributes are the component of the primary key of works in table.
The primary key works in the table is (empID,depID,pID).
The equivalent relation for the above ER diagram is as follows −
- Related Articles
- Explain the conversion of ER diagrams to tables in DBMS?
- What are the components of ER diagrams in DBMS?
- Explain the components of the ER diagram in DBMS?
- Explain Extended or Enhanced ER model in DBMS?
- Attributes to Relationships in ER Model
- Identifying Entity Relationships in DBMS
- Explain the binary operations in relational algebra (DBMS)?
- Types of Entity Relationships in DBMS
- What is an ER model in DBMS?
- What are constraints on ER model in DBMS?
- Construct an ER diagram for the Banking system in DBMS?
- Construct an ER diagram for the Library management system(DBMS)?
- Construct an ER diagram for a company in DBMS?
- Explain the types of curves with appropriate diagrams.
- Draw an ER diagram for a University database application(DBMS)?