ER Diagram in DBMS
Offered By: Great Learning via YouTube
Course Description
Overview
To implement a database we need a blueprint and we can create this blueprint using Entity-Relationship or ER diagram. The Entity-Relationship diagram describes the structure of a database. As its name indicates, the Entity-Relationship diagram shows the relationship between different entities or entity sets of the database.
An entity is the object or component of the data and is represented by a rectangle in the Entity-Relationship diagram. similarly, we have different shapes to represent different components of the data. For instance, an attribute is represented by an oval.
In this tutorial, we will be discussing in brief the various components involved in a database and Entity relationship diagram. It is a core part of the Database Management system. To know more about this interesting topic, watch the video till the end.
Syllabus
Introduction.
What is an ER Diagram?.
History of ER Diagram.
Facts of ER Diagram.
Why ER Diagram is Used?.
Components of ER Diagram .
What is Entity? .
What is a Weak Entity?.
Strong Entity Set Vs Weak Entity.
What are Attributes?.
Types of Attributes.
What is Simple Attributes?.
What are Composite Attributes?.
What is Divided Attributes?.
What is Multivalued Attributes?.
What is Cardinality?.
What is One To One Relationship?.
What is One To Many Relationship?.
What is Many To One Relationship?.
Example of ER Diagram.
Taught by
Great Learning
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity MongoDB for Developers
MongoDB University MongoDB for DBAs
MongoDB University MongoDB for Java Developers
MongoDB University