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)