- 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
Converting E-R model into relational model
A given ER model can be converted into Relational model. A Relational model includes Relations, Tuples, Attributes, Keys, and Foreign keys.
Relation is a table made from tuples.
A Tuple is a row of data.
An Attribute is a characteristic of the relation.
There is a direct mapping between ER model and Relational model.
Consider the following example −
Rules of converting ER model to Relational Model-
Entity type is converted to a Relation table.
1:1 or 1: N relationship type is converted to foreign key.
M: N relationship type is converted to a relation with two foreign key.
Simple attribute converted to an attribute.
Value set converted to a domain.
Key attribute converted to a primary key.
Now for the above example we can create three relations-
Transform attributes to fields-
Employee will have E_ID, Name, Designation and Dob.
Works_On will have E_ID, Status and P_ID.
Projects will have P_ID, S_Date and E_Date.
Now we can create tables in DBMS.
Overall transformation summary is −
- Related Articles
- Difference Between E-R Model and Relational Model in DBMS
- Relational Database Model
- Relational Data Model
- Comparison between E-R Model and Object Oriented Model
- Examples of E-R model
- Object-relational Data Model
- Explain the Relational Model in DBMS?
- How to extract the model equation from model object in R?
- Extended Entity-Relationship (EE-R) Model
- How to create polynomial regression model in R?
- How to create a polynomial model in R?
- Difference between Waterfall Model and RAD Model
- Difference between V-Model and WaterFall Model
- Difference between Incremental Model and WaterFall Model
- Difference between Spiral Model and Waterfall Model