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
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesDatabase Management System Syllabus — Unit-wise Content
The official GTU curriculum for Database Management System (subject code DI04032011) as prescribed for Marine · Semester 4 divides the course into 3 units, covering 57 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 (DI04032011)Unit 1 Introduction to Database Systems
- 1.1.1. Data and Information
- 1.1.2. Database and Database Management System
- 1.1.4. Data items,fields & records
- 1.1.5. Data Dictionary
- 1.2. Purpose of Database System
- 1.3. File oriented System versus database system
- 1.4. Application of DBMS
- 1.5. Database Administrator
- 1.5.1. Roles and responsibilities of DBA
- 1.6. Schema, Sub-Schema, Instances
- 1.7. Data Abstraction
- 1.7.1. Internal Level
- 1.7.2. Conceptual Level
- 1.7.3. External Level
- 1.8. Data Independence
- 1.9. Database Architecture
- 1.9.1. ER Model
- 1.9.2. Relational Model
- 1.9.3. Object oriented data model
- 1.9.4. Network Data Model
- 1.9.5. Hierarchical Data Model
- 04. 15 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma Engineering Level: Diploma Branch: Information & Communication Technology Subject Code : DI04032011 Subject Name : Database Management System w.e.f. 2025-26 http://syllabus.gtu.ac.in/ Page 3 of 6
- 1.10. Role of databases in smart cities & renewable energy tracking
Unit 2 ER Model and Relational Algebra
- 2.1. Basic concepts of E-R
- 2.2.3.2. Recursive relationships
- 2.2.3.3. Degree of relationship set
- 2.2. Mapping Cardinality
- 2.3.1. Primary, Foreign, Super, Candidate
- 2.4. ER Diagrams
- 2.5. Weak Entity Sets
- 2.6. Enhanced ER Model
- 2.6.1. Subclass & Super Class
- 2.7. Converting ER Diagrams to database
- 05. 20 Unit-III Structured Query Language
- 3.1. SQL Data types
- 3.2. Data Definition Language Commands: create, alter, truncate, drop
- 3.3. Data Manipulation Language Commands: insert, select, update, delete
- 3.4. Privilege command: grant, revoke
- 3.5. SQL views
- 3.6. Single row function
- 3.7. Date functions
- 3.8. Numeric &Character function
- 3.9. Conversion function
- 3.10. Miscellaneous function
- 3.11. Group function
- 3.16. Logical Group by
- 3.17. Having and order by clause
- 3.18. Set operators: Union, union all, intersect, minus
- 3.19. Joins: simple join, equi join, non equi join, self- join, outer join
- 12. 32 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma Engineering Level: Diploma Branch: Information & Communication Technology Subject Code : DI04032011 Subject Name : Database Management System w.e.f. 2025-26 http://syllabus.gtu.ac.in/ Page 4 of 6 Unit–IV Refining database design through Normalization
- 4.1. Importance of Normalization
- 4.2. Functional Dependencies4.2.1 Partial Functional Dependency
- 4.2.2. Full Functional Dependency
Unit 3 Transaction Management
- 5.1. Transaction concepts, properties of transactions.
- 5.2. Serializability of transactions
- 5.2.1. Conflict Serializability
- 5.2.2. View Serializability
Study on Android App:
