Hello BTech Computer Science & IT Engineering students, I am sharing the Relational database management system (RDBMS) PDF class lecture notes, eBook, book as per the BTech CSE/IT Engineering course syllabus. These quick revision and summarized notes, eBook on Relational database management system (RDBMS) will help you score more marks and help study in less time for your CSE/IT Engg. semester exams.
Key topics covered in Relational database management system (RDBMS) quick revision PDF class notes, book, eBook for BTech Computer Science / IT Engineering:
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.
Please click the download link below to get Relational database management system (RDBMS) quick revision PDF class notes, book, eBook file for BTech Computer Science / IT Engineering syllabus.