
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)




