Database Management
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
GTU Previous Year Papers
Database Management Syllabus — Unit-wise Content
The official GTU curriculum for Database Management (subject code 4331603) as prescribed for Information Technology · Semester 3 divides the course into 5 units, covering 76 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 (4331603)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 Database Management Course Code: 4331603 Unit Unit Outcomes (UOs) above level) Topics and Sub-topics
- 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 relationshipset
- 2.2. Mapping Cardinality
- 2.3. Key Constraints
- 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
- 2.8. Structure of Relational Databases
- 2.9. Operations and Queries of Relational algebra
- 2.9.1. The Select Operation
- 2.9.2. The Project Operation
- 2.9.3. The Union Operation
- 2.9.4. The Set Difference(Minus) Operation
- 2.9.5. The Set Intersection Operation
- 2.9.6. The Rename Operation
- 2.9.7. The Cartesian Product Operation Database Management Course Code: 4331603 Unit Unit Outcomes (UOs) above level) Topics and Sub-topics
- 2.9.8. The Natural Join Operation
- 2.9.9. The Outer Join Operation
- 2.9.10. The Assignment Operation
Unit 3 Structured Query Language
- 3.1. SQL Data types
- 3.2. DDL Commands
- 3.3. DML Commands
- 3.4. Privilege command
- 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
- 3.18.2. union all
- 3.19.1. simple join
- 3.19.2. equi join
- 3.19.3. non equi join
- 3.19.4. self join
- 3.19.5. outer join
- 3.21. Domain Integrity constraints
- 3.21.1. Not null Database Management Course Code: 4331603 Unit Unit Outcomes (UOs) above level) Topics and Sub-topics
Unit 4 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 5 Transaction Management
- 5.1. Transaction concepts, properties of transactions.
- 5.2. Serializability of transactions 5.3Concurrent executions of transactions and related problems. 5.4Locking mechanism, solution to concurrency related problems, deadlock. Note: The UOs need to be formulated at the ‘Application Level’ and above of 'Revised Bloom’s Taxonomy’ to accelerate the attainment of the COs and the competency.
Study on Android App:
