Advanced Database Management System
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesGTU Previous Year Papers
Advanced Database Management System Syllabus — Unit-wise Content
The official GTU curriculum for Advanced Database Management System (subject code 3340701) as prescribed for Auto · Semester 4 divides the course into 5 units, covering 30 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.
Download the official syllabus PDF (3340701)Unit 1 Advanced SQL
- 1.1. Transactional Control: Commit, Save point, Rollback
- 1.2. DCL Commands : Grant and Revoke
- 1.3. Types of locks : i. Row level locks ii. Table level locks iii. Shared lock iv. Exclusive lock v. Deadlock
- 1.4. Synonym : Create synonym
- 1.5. Sequences: Create and alter sequences
- 1.6. Index : Unique and composite
- 1.7. Views : Create/Replace, Update and alter views
Unit 2 PL / SQL and Triggers
- 2.1. Basics of PL / SQL
- 2.3. Advantages 2b.Use different Control Structures
- 2.4. Control Structures : Conditional, Iterative, Sequential
- 2.5. Exceptions: Predefined Exceptions ,User defined exceptions
- 2.6. Cursors: Static (Implicit & Explicit), Dynamic
- 2.7. Procedures & Functions
- 2.8. Packages : Package specification, Package body, Advantages of package
- 2.9. Fundamentals of Database Triggers
- 2.10. Creating Triggers
- 2.11. Types of Triggers : Before, after for each row, for each statement Advanced Database Management System Course code: 3340701 GTU/NITTTR/Bhopal/13-14 Gujarat State 3 Unit Major Learning Outcomes (in cognitive domain) Topics and Sub-topics
Unit 3 Functional Dependency and Decompositio n
- 3.1. Basics of Functional Dependency
- 3.2. Functional dependency diagram and examples
- 3.3. Full function dependency (FFD)
- 3.4. Armstrong’s Axioms for functional dependencies
- 3.5. Redundant functional dependencies
- 3.6. Closures of a set of functional dependencies
- 3.7. Lossy Decomposition
- 3.8. Lossless join decomposition
- 3.9. Dependency-Preserving Decomposition
Unit 4 Normalization
- 4.2. 4.1 Basics of Normalization
- 4.3. 4.2 Normal Forms i. First Normal Form (1NF) ii. Second Normal Form (2NF) iii. Third Normal Form (3NF)
Unit 5 Transaction Processing
- 5.1. Introduction to transaction concepts
- 5.3. Methods for Concurrency control i. Locking Methods ii. Timestamp methods iii. Optimistic methods
Study on Android App:
