Database Management System
Get the full GTU study material for this subject: official syllabus, textbook links (Gujarati-medium books included where available), and 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 UpdatesDatabase Management System Syllabus — Unit-wise Content
The official GTU curriculum for Database Management System (subject code 1333204) as prescribed for ICT · Semester 3 divides the course into 4 units, covering 65 listed topics. This curriculum applies from the July-2023 intake. 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 (1333204)Unit 1 Introductionto 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
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
Unit 3 Structured Query Language
- 3.1. SQL Data types
- 3.2. Data Definition Language Commands: create, alter, truncate, drop
- 3.3. Data Manipulation Language Relational Database Management Systems Course Code: 1333204 Commands: insert, select, update, delete
- 3.4. Privilege command: grant, revoke
- 3.5. SQL views 3b.Use SQL functions fordifferent Operations
- 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
- 3.21. Domain Integrity constraints: Not null, Check
- 3.22. Entity Integrity constraints
- 3.22.2. Primary key
- 3.23. Referential integrity Constraints
- 3.23.1. Foreign key
- 3.23.2. Reference key Unit–IV Refining database design through Normalization
- 4.1. Importance of Normalization
- 4.2. Functional Dependencies
- 4.2.1. Partial Functional Dependency
- 4.2.2. Full Functional Dependency
- 4.2.3. Transitive Dependency
- 4.3. Normal Forms
- 4.3.1. First Normal Form
- 4.3.2. Second Normal Form
- 4.3.3. Third Normal Form
Unit 4 Transaction Management
- 5.1. Transaction concepts, properties of transactions.
- 5.2. Serializability of transactions
- 5.2.1. Conflict Serializability
- 5.2.2. View Serializability Note: The UOs need to be formulated at the ‘Applcation Level’ and above of Revised Bloom’s Taxonomy’ to accelerate the attainment of the COs and the competency. Relational Database Management Systems Course Code: 1333204
Study on Android App:
