🌟 Bachelor’s degree in Computer engineering 🌟 CGPA 9.14 🌟 GATE qualified 🌟 Unacademy Verified Educator 🌟 Software engineer 🌟 CS Passionate 🌟

Nisha Sajnani

This course focuses on need of Normalization, understanding Functional dependency and Candidate keys. What is 1NF, 2NF, 3NF and BCNF.
Also,solving all the GATE questions of Normalization.

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

Understanding Normalization with Previous Year GATE Questions - GATE(CS and IT)

Normalization

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

Course Overview - Normalization with previous year GATE questions

Normalization - Course Overview

Introduction to Normalization - what is Normalization and why it is required

Introduction to Normalization

Understanding Functional dependency. Formal Definition, Usages and Types of FD

Introduction to FDs

Understanding Functional dependency with examples and solving GATE 2000 question based on Functional dependency

FD Examples and GATE 2000 Question

GATE 2002 question on FDs

What are various Usages of FDs and understanding how we can use Inference rules to perform operations on FDs

Inference rules

Understanding closure set of attributes using example

Closure set of attributes

GATE 2006 question on closure set of attributes

GATE 2006 Question on Closure Set of Attributes

What is a key, super key and Candidate key. Basic example of Candidate key

Candidate Keys

How to determine Candidate key and number of candidate keys possible on a relation

Determining Candidate keys

GATE 96 question on Candidate keys

GATE 2014 question on Candidate key

GATE 2005 question on CK

GATE 2013 question on CK

Example on Candidate key

Determining CK of subrelation which will be used for finding CKs of the decomposed table

Determining CK of subrelation

GATE IT 05 question on Additional FDs

What is equivalence of FDs and an example on it

Equivalence of FDs

Example on Equivalence of FDs

What is minimal cover and procedure to find minimal set using an example

Minimal Cover

Example on Minimal Cover

GATE 2013 question on Minimal Cover

Lossy Decomposition with example. Lossless Decomposition with example. Also, the difference between the two.

Lossy vs Lossless Decomposition

Dependency preservation

Dependency preservation Example 1

Dependency preservation Example 2

Dependency preservation Example 3

First Normal Form

Understanding second Normal Form using an example

Second Normal Form

2NF Example

Third Normal Form

3NF Example 1

3NF Example 2

3NF Example 3

BCNF INTRODUCTION

BCNF Eg 1 - GATE 95 question on Normalization

BCNF Example 2

BCNF Example 3

BCNF Example 4

BCNF Example 5

GATE Questions on Normalization - 1

GATE Questions on Normalization - 2

Mentored 81,000+ Students | My Multiple Students secured AIR Below 100 in GATE | Joined top IISc, IITs & NITs | Joined PSUs | 5+ Years Exp.

Sweta Kumari

This course will cover Joins topic in SQL. I will describe type of joins in this course with important examples.

(Hindi) SQL Joins With Tabular Examples - GATE (CS/IT)

This course deals with Normalization in database explained with each type of Normalization with Numerical Examples.

(Hindi) Normalization in Databases

This Course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert. This Course is beneficial for 
GATE (CS and IT)
 aspirants.

(Hindi) 25 Previous Year Questions for Normalization in Databases - GATE (CS and IT)

Final year computer science student at VIT Vellore || Passionate about technology ||

Divyanshi Mangal

In this course we are going to discuss about normalisation. The prerequisite for this course is my Functional dependency course and Keys course. Check that out in my courses section.

Normalisation In Database Management System: GATE

Ridhi Bhat

This course will cover basic concepts of normalization, indexing, hashing and transaction in database management systems.

Database Management - Normalization

In this course, Sweta Kumari will cover 25 Awesome Tricks for Finding Keys in Databases.

Lessons

42 lessons • 2h 33m

Invalid Date

NaN

Normalization - Course Overview

Invalid Date

NaN

Introduction to Normalization

Invalid Date

NaN

Introduction to FDs

Invalid Date

NaN

FD Examples and GATE 2000 Question

Invalid Date

NaN

GATE 2002 question on FDs

Invalid Date

NaN

Inference rules

Invalid Date

NaN

Closure set of attributes

Invalid Date

NaN

GATE 2006 Question on Closure Set of Attributes

Invalid Date

NaN

Candidate Keys

Invalid Date

NaN

Determining Candidate keys

+ See all lessons