ADBMS (3340701)

Syllabus

Link to download click here

Study Material

Unit – 1 Advanced SQL click here
Unit – 2 PL / SQL and Triggers click here
Unit – 3 Functional Dependency and Decomposition click here
Unit – 4 Normalization click here
Unit – 5 Transaction Processing click here

Assignment

Link to download click here

IMP Questions with Answer

Link to download click here

GTU Exam Paper

Summer – 2018 Winter – 2017 Summer – 2017
Winter- 2016 Summer – 2016 Winter – 2015

Video

  • Closure Set of Functional Dependency

  • Remove Redundant Functional Dependency (Irreducible Form)

  • Lossless Join Decomposition

  • Normalization : 1NF (First Normal Form)

  • Normalization: 2NF (Second Normal Form)

  • Normalizatoin: 3NF (Third Normal Form)