Currently pursuing B.Tech (IT) from College of Technology, Pantnagar. 

Srishti Srivastava

This course introduces you with the database management system and its various models. It then discusses in detail the ER model (relationships, attributes, notations) and RDB model (terminologies, constraints) and how to convert ER diagram to RDB.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

English

ER and RDB Models: GATE

ER Model

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

Introduction to DBMS

Different levels of modelling in database management system is explained here.

Models in DBMS

Explanation of entity set, keys and relationship in ER model

Terminologies related with ER Model

Discussing the one-to-one relationship using an example, finding the degree, participatation and cardinality and drawing the ER diagram for the same.

One-to-One Relationship

Discussing the many-to-many relationship using an example, finding the degree, participatation and cardinality and drawing the ER diagram for the same.

Many-to-Many Relationship

Discussing the one-to-many relationship using an example, finding the degree, participatation and cardinality and drawing the ER diagram for the same.

One-to-Many Relationship

Discussing the recursive relationship using an example, finding the degree, participatation and cardinality and drawing the ER diagram for the same.

Recursive Relationship

Discussing weak entity, identifying relationship and its representation.

Weak Entity

Learning the notations that are used to represent ER Model.

Notations for ER Diagram

Introduction to Relational Model and terminologies related to it.

Relational Model

Explaining the different types of constraints that are followed while designing the Relational DB schema

Constraints on Relational DB Schema

How the integrity constraints can be violated and what are the actions that are performed when violation occurs. Also, some examples on counting the number of superkeys are discussed here.

Actions upon Constraint Violation

Steps 1 - 3 are covered here for converting an ER diagram into RDB.

Conversation of ER Diagram to Relational Model (Part 1)

Conversion of ER diagram to RDB (Part 2)

Code HELLOSONU01 | 8+ Years Teaching Exp. in GATE CS IT & GATE DS AI on Unacademy | Mentored 2 Lakh+ Students | Produced Rankers Under 500

Sweta Kumari

This course will cover complete Concepts of ER Model with relevant PYQs.

(Hindi) ER Model Concepts With PYQs - GATE (CS and IT)

Gate- 2012,2013. Net -2019. M.Tech. Teaching GATE, NTA NET, DSSSB, KVS, NVS,HTET. YouTuber - channel name - my NoteBook by priyanka kalra. e

Priyanka Kalra

This course will consists of the concept of ER Modelling in DBMS and will contain the practice questions in last.

(Hindi) Quick Revision for ER Modelling in DBMS for GATE/RRB JE

My name is Monika Dubey. M.Tech(CSE).Worked  as Asst. Professor. Currently, working as Research Scholar   

Monika Dubey

In this course, the educator discusses the Concept+ Practice Problem helpful for GATE 2019 exams.,

(Hindi) ER Diagram - Concept+ Practice Problem: GATE

Teaching experience of 4+ years as GATE faculty with some prestigious GATE institutions,Qualifying GATE from 2014,Qualifyied UGC NET 2018(ju

Megha 

This course will describe the basic concepts of relational data model and various questions on ER data model and relational data model

Relational Data Model: GATE

M.Tech @ NSIT Delhi/GATE (CS) 2017&2018 qualified ...Not a teacher but a medium of sharing my knowledge 

Akshay Mandhare

In this course we will solve previous years question from GATE.

GATE Previous Year Question - ER Diagram

This course will cover Big Data Tutorial in 60 Minutes. The course will be GATE Aspirants.

Lessons

15 lessons • 2h 45m

Invalid Date

NaN

Introduction to DBMS

Invalid Date

NaN

Models in DBMS

Invalid Date

NaN

ER Model

Invalid Date

NaN

Terminologies related with ER Model

Invalid Date

NaN

One-to-One Relationship

Invalid Date

NaN

Many-to-Many Relationship

Invalid Date

NaN

One-to-Many Relationship

Invalid Date

NaN

Recursive Relationship

Invalid Date

NaN

Weak Entity

Invalid Date

NaN

Notations for ER Diagram

+ See all lessons