Database Management Systems
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 Systems Syllabus — Unit-wise Content
The official GTU curriculum for Database Management Systems (subject code 2130703) as prescribed for Information Technology · Semester 3 divides the course into 9 units, covering 56 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 (2130703)Unit 1 Introductory concepts of DBMS
- Introduction and applications of DBMS
- Purpose of data base
- Database System architecture- levels
- users and DBA
Unit 2 Relational Model
- Structure of relational databases
- Relational algebra – fundamental operators and syntax
- relational algebra queries
- tuple relational calculus
Unit 3 Entity-Relationship model
- Basic concepts
- Design process
- Design issues
- weak entity sets
- extended E-R features – generalization
- reduction to E-R database schema
Unit 4 Relational Database design
- Functional Dependency – definition
- trivial and non-trivial FD, closure of FD set, closure of attributes
- irreducible set of FD, Normalization – 1Nf, 2NF, 3NF, Decomposition using FD- dependency preservation
- Multi- valued dependency, 4NF, Join dependency and 5NF
Unit 5 Query Processing & Query Optimization
- measures of query cost
- selection operation
- evaluation of expressions
- transformation of relational expressions
- estimating statistics of expression results
- evaluation plans
- materialized views
Unit 6 Transaction Management
- Transaction concepts
- properties of transactions
- serializability of transactions
- testing for serializability
- System recovery
- Two- Phase Commit protocol
- Recovery and Atomicity
- Log-based recovery
- concurrent executions of transactions and related problems
- Locking mechanism
- solution to concurrency related problems
- two-phase locking protocol
- Intent locking
Unit 7 Security
- Discretionary access control
- Mandatory Access Control
- Data Encryption
Unit 8 SQL Concepts
- Basics of SQL, DDL, DML, DCL, structure – creation
- defining constraints – Primary key, foreign key, unique
- not null
- IN operator
- Functions - aggregate functions
- Built-in functions – numeric
- string functions
- set operations
- correlated sub-queries
- Use of group by, having
- order by, join and its types
- Exist, Any, All, view and its types. transaction control commands – Commit
Unit 9 PL/SQL Concepts
- Stored Procedures
- Stored Function
- Database Triggers
Study on Android App:
