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
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesDatabase Management Syllabus — Unit-wise Content
The official GTU curriculum for Database Management (subject code DI03016041) as prescribed for Biomed · Semester 3 divides the course into 5 units, covering 12 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 (DI03016041)Unit 1 Introduction to Database Systems
- 1.1 Introduction 1.1.1 Data and Information 1.1.2 Database and Database Management System 1.1.3 Purpose of Database System and Application 1.1.4 Metadata 1.1.5 Data items
- fields & records 1.1.6 Data Dictionary 1.2 File oriented System versus database system 1.3 Database Administrator 1.3.1 Roles and responsibilities of DBA 1.4 Schema
- Instances 1.5 Data Abstraction 1.5.1 Internal Level 1.5.2 Conceptual Level 1.5.3 External Level 1.6 Data Independence
Unit 2 Entity Relationship Model
- 2.1 Basic concepts of E-R 2.1.1 Entity 2.1.2 Attributes 2.1.3 Relationship 2.1.3.1.Participation 2.1.3.2 Recursive relationships 2.1.3.3 Degree of relationship set 2.2 Mapping Cardinality 2.3 ER Diagrams 2.4 Weak Entity Sets 2.5 Enhanced ER Model 2.5.1 Subclass & Super Class Program Name: Engineering Level: Diploma Branch: Information Technology Course / Subject Code : DI03016041 Course / Subject Name : Database Management w.e.f. 2024-25 http://syllabus.gtu.ac.in 3 of 9 2.5.2 Generalization 2.5.3 Specialization 2.5.4 Aggregation 2.6 Converting ER Diagrams to database
Unit 3 Structured Query Language
- 3.1 Introduction and basic commands 3.1.1 SQL Data types 3.1.2 Data Definition Language Commands : create
- truncate and drop 3.1.3 Data Manipulation Language Commands: insert
- update and delete 3.1.4 Data query Language: select 3.1.5 Privilege command : grant and revoke 3.1.6 Other Miscellaneous: describe
- order by, group by and having 3.2 SQL Views 3.3 SQL Functions 3.4 SQL Operators 3.5 Set Operators: union
- union all, intersect and minus 3.6 Joins 3.7 SQL Constraints 3.7.1 Need of Constraints 3.7.2 Domain Integrity constraints: Not null and Check 3.7.3 Entity Integrity constraints: Unique
- Primary key, 3.7.4 Referential integrity Constraints: Foreign key, Reference key
Unit 4 Normalization
- 4.1 Anomalies created by poor database design 4.2 Normalization 4.2.1 Definition and its importance 4.2.2 Goals of Normalization 4.3 Functional Dependencies 4.3.1 Prime Vs Non-Prime Attributes 4.3.2 Functional Dependency Program Name: Engineering Level: Diploma Branch: Information Technology Course / Subject Code : DI03016041 Course / Subject Name : Database Management w.e.f. 2024-25 http://syllabus.gtu.ac.in 4 of 9 4.3.2.1 Partial Functional Dependency 4.3.2.2 Full Functional Dependency 4.3.2.3 Transitive Dependency 4.4 Normal Forms 4.4.1 First Normal Form 4.4.2 Second Normal Form 4.4.3 Third Normal Form 4.4.4 Boyce Codd Normal Form
Unit 5 Transaction Management
- 5.1 Basic Transaction Concepts 5.1.1 Definition 5.1.2 State transition diagram 5.1.3 ACID Properties 5.1.4 Transaction Log 5.2 Concurrency Control 5.2.1 Definition 5.2.2 Problems of Concurrency Control 5.2.3 Schedule and its types 5.3 Serializability of transactions 5.4 Locking methods for Concurrency Control
Study on Android App:
