I am Btech Student from Computer Science branch. I have a great interest in teaching and educating others. My areas of interest are DBMS,DAA

Aniket Gupta

This course covers various topics of DBMS  like basic knowledge of DBMS, ER diagrams, ACID properties, Transaction System etc which are frequently asked in various exams, placement tests, interviews etc

English

Database Management Systems

This lesson contains basic description about following topics:-
- DBMS
- Advantages of DBMS & Drawbacks of File Based systems
- Three Schema Architecture
- Basic Terminologies of DBMS

Introduction to DBMS

This lecture contains description about Keys , their importance and their Types and Types of Attributes

Types of Keys and Attributes

This  lesson covers topics such as - ER diagram basics
- Notations in ER diagram
- Degree , Cardinality, Participation in ER diagram 
- Types of Entities -Strong and Weak

E R Diagram

This lessons covers brief knowledge about types of relationship based on the Cardinality of entities

ER Diagram || Types of Relationships

This lesson contains rules to convert ER diagram into Table

E R Diagram to Table

This lesson contains further rules that how the ER diagram will be converted to Table

E R Diagram to Table || Part 2

This lesson covers topics such as Super key , candidate key and Functional Dependency.


Also subscribe to the Plus Subscription of Unacademy using 
referral code "aniket.16bcs1024" to gain following benefits:- 

- Live structured courses delivered by the Best Educators

- All topics and subjects will be covered by the Educators
 
- Attend unlimited live classes anytime, anywhere

- Take quizzes and track your learning journey

- Doubt clearing sessions in all courses
 
- Classes will be interactive and engaging

Use the referral code "aniket.16bcs1024" while signing up

CONCEPT OF SUPER KEY CANDIDATE KEY AND FUNCTIONAL DEPENDENCY

This lesson covers the method to calculate candidate key.

Also subscribe to the Plus Subscription of Unacademy using 
referral code "aniket.16bcs1024" to gain following benefits:- 

- Live structured courses delivered by the Best Educators

- All topics and subjects will be covered by the Educators
 
- Attend unlimited live classes anytime, anywhere

- Take quizzes and track your learning journey

- Doubt clearing sessions in all courses
 
- Classes will be interactive and engaging

Use the referral code "aniket.16bcs1024" while signing up

HOW TO FIND CANDIDATE KEY?

This lesson covers basic knowledge about normalisation. 
It's necessity and types of normal forms

Also subscribe to the Plus Subscription of Unacademy using 
referral code "aniket.16bcs1024" to gain following benefits:- 

- Live structured courses delivered by the Best Educators

- All topics and subjects will be covered by the Educators
 
- Attend unlimited live classes anytime, anywhere

- Take quizzes and track your learning journey

- Doubt clearing sessions in all courses
 
- Classes will be interactive and engaging

Use the referral code "aniket.16bcs1024" while signing up

Lessons

9 lessons • 1h 21m

Invalid Date

NaN

Introduction to DBMS

Invalid Date

NaN

Types of Keys and Attributes

Invalid Date

NaN

E R Diagram

Invalid Date

NaN

ER Diagram || Types of Relationships

Invalid Date

NaN

E R Diagram to Table

Invalid Date

NaN

E R Diagram to Table || Part 2

Invalid Date

NaN

CONCEPT OF SUPER KEY CANDIDATE KEY AND FUNCTIONAL DEPENDENCY

Invalid Date

NaN

HOW TO FIND CANDIDATE KEY?

Invalid Date

NaN

NORMALISATION IT'S TYPES AND NECESSITY