Database Management System
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 System Syllabus — Unit-wise Content
The official GTU curriculum for Database Management System (subject code BE03000091) as prescribed for AI & DS · Semester 3 divides the course into 10 units, covering 64 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 (BE03000091)Unit 1 Introductory concepts of DBMS
- Purpose of database system
- View of data
- Database Languages
- Relational Databases
- Database Architecture
- Database users
Unit 2 Relational Model
- Structure of relational databases
- Database Schema
- Schema Diagrams
- Relational algebra operators
- relational algebra queries. 4 10
Unit 3 Introduction to SQL
- Overview of SQL Query Language
- Basic structure of SQL Queries, DDL, DML, Additional Basic Operations
- defining constraints – Primary key, foreign key, unique
- not null
- Set operations
- Null values
- Aggregate functions
- Built-in functions –numeric
- string functions
- nested sub- queries
- Modification of the Database
- DCL and TCL
Unit 4 Entity-Relationship Model
- Design process
- Removing redundant attributes in Entity Sets
- Reduction of E-R database schema to Relational schema
- Design issues
Unit 5 Relational Database Design
- Features of good relational designs
- Dependency preservation
- Functional Dependency–definition
- Trivial and Non-Trivial FD, Closure of FD set, Closure of attributes
- Irreducible set of FD, Decomposition using FD, Normalization – 1Nf, 2NF, 3NF, BCNF
- Multivalued dependency, 4NF
Unit 6 Transaction Management
- Transactions: Transaction concepts
- transaction model
- ACID Properties of transactions: Serializability of transactions
- testing for serializability
- Concurrency Control: Lock based protocols
- deadlock handling
- Timestamp protocols
- Recovery System: Types of failure
- Recovery and atomicity
- Recovery Algorithms
Unit 7 Query Processing & Optimization
- measures of query cost
- selection and join operation
- evaluation of expressions
- Transformation of relational expressions
- estimating statistics of expression results
- evaluation plans
- materialized views
Unit 8 Database Security
- Security – Security and Authentication
- authorization in SQL, access control, DAC, MAC and RBAC models
- Intrusion detection
- SQL injection
Unit 9 Indexing and Hashing
- Basic Concepts
- Ordered Indices
- B+-Tree Index Files
- Multiple-Key Access
- Static Hashing
- Dynamic Hashing
- Comparison of Ordered Indexing and Hashing
- Bitmap Indices
- Index Definition in SQL
Unit 10 PL/SQL Concepts
- Stored Procedures and Database Triggers 3 5 Program Name: Bachelor of Engineering Level: UG Subject Code : BE03000091 Subject Name : Database Management System w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page no. 3 of
Study on Android App:
