Undergrad @ IIIT Gwalior. Machine Learning enthusiast. Qualified JEE Mains and Advanced. Gate Aspirant.
Excellent orator.

Surya Pratap Singh

This course covers a Complete theory plus problem solving approaches to be used while dealing with questions related to Functional Dependence. You'll become an expert at FDs by the end of this 1 hour course.

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 & ESE

Hindi

(Hindi) Functional Dependence: GATE

Constraints

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

Definition of FD ; How to determine an FD for a relationship; How to check if an FD exists or not; Cardinality for FDs.

Introduction (in Hindi)

Trivial and non trivial dependence; Armstrong's Inference Rules

Armstrong Inference Rule (in Hindi)

What is closure and how to calculate closure of an FD and an attribute or set of attributes; what are the uses of attribute closure.

Closure Set (in Hindi)

How to check if two FDs are equivalent; How to check if an attribute or FD is redundant; and how to calculate canonical cover of an FD set (simply by removing redundant FD and attributes)

Tests on FD and Canonical Cover (in Hindi)

Example to calculate canonical cover; non loss and lossless join decomposition- what it actually is? ; How to calculate candidate keys (note : to calculate all candidate keys find closure for all possible subsets of a relation and if a closure has all the attributes then it a candidate key. Note: don't find closure for supersets of already found candidate keys as they are superkeys)

Decompositions (in Hindi)

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 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)

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

(Hindi) 25 Awesome Tricks for Finding Keys in Databases - GATE 2020

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

Divyanshi Mangal

In this course, learn easily about the Functional Dependencies in database management systems.

Functional Dependencies in DBMS : 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'll learn about What is keys and its types and how to find primary key and others keys and about the functional Dependency

Database (DBMS) - Keys and Functional Dependency

I am gate qualified, Net qualified and persuing PHD. I am interested in teaching, reading, surfing internet. I'm also interested in blog wri

Hukam Panchal

This course deals with Functional Dependency, Normalisation

(Hindi) Data Dependency, Normalisation

In this Course, Sweta Kumari will Cover Previous Year Questions on SQL & Relational Model.

Lessons

5 lessons • 47m

Invalid Date

NaN

Introduction (in Hindi)

Invalid Date

NaN

Armstrong Inference Rule (in Hindi)

Invalid Date

NaN

Closure Set (in Hindi)

Invalid Date

NaN

Tests on FD and Canonical Cover (in Hindi)

Invalid Date

NaN

Decompositions (in Hindi)