DBMS Difference Between E-R Model and Relational Model
DBMS
0% Completed
Detailed Content of Database Management System
DBMS Syllabus for Diploma
Video - 00:00 mins
Database
What is Database?
Video - 00:00 mins
Related Definitions to Database
Video - 00:00 mins
Database System
Video - 00:00 mins
Introduction To DBMS
What is DBMS?
Video - 00:00 mins
Advantages & Disadvantages of DBMS
Video - 00:00 mins
DBMS Users
Video - 00:00 mins
Data Models
Classification Of Data Models
Video - 00:00 mins
Relational Data Model
Video - 00:00 mins
Network Model
Video - 00:00 mins
Hierarchical Model
Video - 00:00 mins
Object-Oriented Model
Video - 00:00 mins
Difference Between E-R Model and Relational Model
Video - 00:00 mins
Data Modeling Using E-R Model
What is E-R Model?
Video - 00:00 mins
Components of ER Diagram
Video - 00:00 mins
Integrity Constraints of Relationships in E-R Model
Video - 00:00 mins
Difference Between Entity, Entity Set and Entity Type
Video - 00:00 mins
Difference between Strong Entity & Weak Entity
Video - 00:00 mins
Attributes and Domains
Video - 00:00 mins
Relational Model
What is Relational Model?
Video - 00:00 mins
Advantages & Disadvantages of Relational Model
Video - 00:00 mins
Relational Algebra Operations
Video - 00:00 mins
Types of Keys in Relational Model
Video - 00:00 mins
Anomalies in Relational Model
Video - 00:00 mins
Difference Between DBMS and RDBMS
Video - 00:00 mins
Normalization
What is Normalization?
Video - 00:00 mins
Reasons Why We Require Normalization
Video - 00:00 mins
What is Dependency and Type of Dependencies
Video - 00:00 mins
FD8 Normalization OR Normal Forms in DBMS
Video - 00:00 mins
SQL Query
Types of SQL Query
Video - 00:00 mins
Announcements Course Info

Difference Between E-R Model and Relational Model:

Sr. No.TitleE-R ModelRelational Model
1.TypeE-R Model is the high-level Conceptual Model.It is Representational and Implementational Model.
2.Used ByWho don’t know how database is Implemented.It is used by Programmer.
3.RelationshipIt is representing Collection of Entities and Describe Relationship between them.It is representing data in the form of Tables and describe Relationship between them.
4.ComponentsIt Consists of Components like Entity, Entity Type, Entity Set.It Consists of Components like Domain, Attributes, Tuple.
5.BasicIt’s used to describe a set of objects known as Entities, as well as the Relationships between them.It’s used to describe a collection of Tables as well as the Relationships between them.
6.MappingThis Model explains how to map cardinalities. The uniqueness of data values in a row is referred to as cardinality.This model does not describe mapping cardinalities.
PreviousNext