The Book Database Management System book is Written by A. A. Puntambekar and published by Technical Publication. Database Management System GTU Technical Book Pdf Free Download. DBMS GTU Technical Book PDF Free Download.
Database Management System contains Basic concepts, Advantages of DBMS over file processing systems, Data abstraction, Database languages, Data models, Data independence, Components of a DBMS, Overall structure of DBMS, Multi-user DBMS architecture, System catalogs, Data Modeling: Basic concepts, Entity, attributes, relationships, constraints, keys.
ER and EER diagrams: Components of ER model, Conventions, Converting ER diagrams into tables.
Relational Model: Basic concepts, Attributes and Domains, Codd’s rules.
Relational Integrity: Nulls, Entity, Referential integrities, Enterprise constraints, Views, Schema diagram.
Characteristics and advantages SQL Data Types, Literals, DDL, DML, SQL Operators Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updation using Views, Indexes, Nulls.
SQL DML Queries: SELECT query and clauses, Set operations, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database Modification using SQL Insert, Update, Delete Queries, Stored Procedure, Triggers, Programmatic SQL: Embedded SQL, Dynamic SQL, ODBC.
Relational Databases Design: Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies. The process of Normalization: 1NF, 2NF, 3NF, BCNF.
Introduction to Query Processing: Overview, Measures of Query cost, Selection and Join operations, Evaluation of Expressions.
Introduction to Query optimization: Estimation, Transformation of Relational Expression.
Transaction Management: Basic concept of a Transaction, Properties of Transactions, Database Architecture, Concept of Schedule, Serial Schedule.
Serializability: Conflict and View, Cascaded aborts Recoverable and Non-recoverable Schedules. Concurrency Control: Need Locking methods Dead locks, Time stamping Methods. Optimistic Techniques, Multi-version Concurrency Control.
Different crash recovery methods: Shadow-Paging, Log-based Recovery: Deferred and Immediate, Check Points.
Database Architectures: Centralized and Client-Server Architectures, 2 Tier and 3 Tier Architecture, Introduction to Parallel Databases, Key elements of Parallel Database Processing, Architecture of Parallel Databases, Introduction to Distributed Databases, Architecture of Distributed Databases, Distributed Database Design.
Emerging Database Technologies: Introduction, No SQL Databases – Internet Databases, Cloud databases, Mobile Databases, SQLite database, XML databases.