Database Management
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
Database Management Syllabus — Unit-wise Content
The official GTU curriculum for Database Management (subject code 3341605) as prescribed for Biomed · Semester 4 divides the course into 5 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 (3341605)Unit 1 Data Management Concepts
- 1.1.1. Data and Information
- 1.1.3. Data items or fields
- 1.1.6. 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 of DBA
- 1.5.2. Responsibilities of DBA
- 1.7. Data Abstraction
- 1.7.1. Internal Level
- 1.7.2. Conceptual Level
- 1.7.3. External Level
- 1.8. Database Architecture
Unit 2 Integrity Constraints and Ms-Access 2.a Describe various database constraints
- 2.1. Need of Constraints
- 2.2. Domain Integrity constraints
- 2.2.1. Not null
- 2.3. Entity Integrity constraints
- 2.3.2. Primary key
- 2.4. Referential integrity Constraints
- 2.4.1. Foreign key
- 2.4.2. Reference key Database Management Course code : 3341605 GTU/NITTTR/Bhopal/13-14 Gujarat State 3 Unit Major Learning Outcomes (in cognitive domain) Topics and Sub-topics
- 2.5. Introduction to MS Access
- 2.6. Creation of Data sheet
- 2.7. Field and Records
Unit 3 Relational Algebra and E-R Model
- 3.5. Operator and Syntax
- 3.6. Basic concepts of E-R
- 3.6.3. Attributes (single,composite,multivalued,Derive)
- 3.7. Mapping cardinality
- 3.9. Design issues
- 3.10. weak entity set
Unit 4 Structure Query Language
- 4.1. SQL Data types
- 4.2. DDL Commands
- 4.3. DML Commands
- 4.3.2. select Database Management Course code : 3341605 GTU/NITTTR/Bhopal/13-14 Gujarat State 4 Unit Major Learning Outcomes (in cognitive domain) Topics and Sub-topics
- 4.4. Privilege command
- 4.5. SQL views 4.b Use SQL Functions for different operations 4.c Write queries to use various SQL functions.
- 4.6. Single row function
- 4.7. Date functions
- 4.8. Numeric functions
- 4.9. Character function
- 4.10. Conversion function
- 4.11. Miscellaneous function
- 4.12. Group function 4.c Use SQL complex queries and Sub queries to retrieve data
- 4.16. Logical Group by
- 4.17. Having and order by clause
- 4.18. Set operators
- 4.18.2. union all
- 4.19.1. simple join
- 4.19.2. equi join
- 4.19.3. non equi join
- 4.19.4. self join
- 4.19.5. outer join
Unit 5 Relational Database design 5a Describe the concept of Normalization of a database 5b Design database table at different
- 5.1. Functional Dependencies
- 5.2. Importance of Normalization
- 5.3. Different Normalization
- 5.4. Comparision of BCNF and 3NF Database Management Course code : 3341605 GTU/NITTTR/Bhopal/13-14 Gujarat State 5
Study on Android App:
