
- 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
Types of Entity Relationships in DBMS
Entity in DBMS can be a real-world object with an existence, For example, in a Company database, the entities can be Employees, Department, Project, etc. In a College database, the entities are Profession, Students, Result, Activities, etc.
An entity is represented as a single rectangle, shown below
The following are the entity relationships −
One-to-One Relationship
Under One-to-One (1:1) relationship, an instance of entity P is related to instance of entity Q and an instance of entity Q is related to instance of entity P.
Let us see an example −
A person can have only one passport, and a passport is assigned to a single person.
One-to-Many Relationship
Under One-to-Many (1:N) relationship, an instance of entity P is related to more than one instance of entity Q and an instance of entity Q is related to more than one instance of entity P.
Let us see an example −
A Person can have more than one Bank Accounts but a bank account can have at most one person as account holder.
Many-to-Many Relationship
Under Many-to-Many (N:N) relationship, more than one instance of entity P is related to more than one instance of entity Q. For more than one instance of entity Q is related to more than one instance of entity P.
Let us see an example −
A person can have more than one skills. More than one person can attain a skill.
- Related Articles
- Identifying Entity Relationships in DBMS
- What is an Entity relationship model in DBMS?
- Types of dependencies in DBMS
- Various Types of Keys in DBMS
- Explain Mapping the ER diagrams with binary and ternary relationships(DBMS)?
- Types of DBMS Entities and their examples
- What are the different types of DBMS?
- What are different types of DBMS languages?
- What are the different types of schedules in DBMS?
- What are different types of recoverability of schedules(DBMS)?
- Explain attributes and the different types of attributes in DBMS?
- Types of Two Phase Locking (Strict, Rigorous & Conservative) in DBMS
- Difference between Strong Entity and Weak Entity
- Explain difference between Strong Entity and Weak Entity
- Explain the different types of users who play different roles in DBMS?
