Relational database management system lecture notes,ebook,pdf download

Feb 8, 2015
Hi Friends,

I am sharing the excellent lecture notes for the subject RELATIONAL DATABASE MANAGEMENT SYSTEM (RDMS) which will help the CS/IT Engineering students. Relational database management system is one of the important subject. You can now download the ebook in PDF format.

The topics covered in this ebook of RELATIONAL DATABASE MANAGEMENT SYSTEM (RDMS) are as follows.

Module I
Database System Architecture, Data Abstraction, Data Independence, Data Definitions and Data
Manipulation Languages. Data models, Entity Relationship (ER), Mapping ER Model to Relational Mode, Network. Relational and Object Oriented Data Models, Integrity Constraints and Data Manipulation Operations.

Module II
Relation Query Languages, Relational Algebra, Tuple and Domain Relational Calculus, SQL and
QBE. Relational Database Design: Domain and Data dependency, Armstrong's Axioms, Normal Forms, Dependency Preservation, Lossless design, Comparison of Oracle & DB2.

Module III
Query Processing and Optimization: Evaluation of Relational Algebra Expressions, Query Equivalence, Join strategies, Query Optimization Algorithms.

Module IV
Storage Strategies: Indices, B-Trees, Hashing, Transaction processing: Recovery and Concurrency
Control, Locking and Timestamp based Schedulers, Multiversion and Optimistic Concurrency
Control Schemes. Advanced Topics: Object-Oriented and Object Relational databases. Logical Databases, Web Databases, Distributed Databases, Data Warehouse and Data Mining.

You can easily download this eBook, notes pdf file on RELATIONAL DATABASE MANAGEMENT SYSTEM (RDMS) below.


Last edited by a moderator: