YoVDO

ER Diagram in DBMS

Offered By: Great Learning via YouTube

Tags

Databases Courses Entity Framework Courses Database Design Courses

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 Databases
Meta via Coursera
Web Development
Udacity
MongoDB for Developers
MongoDB University
MongoDB for DBAs
MongoDB University
MongoDB for Java Developers
MongoDB University