Interline Publishing +91 98867 328 23 / 24 / 25   +91 80 2333 2824 Sign Up   Sign In
Interline Publishing
Skip to Reader

Set up video

    Subscription offer
         (Unlimited Download)
Amount Validity
र 100 6 months
र 200 1 year
Search By
SRM Database Management Systems - Sem V
No Units Titles Sub Titles Chapters
1 Unit 1 Introduction Introduction to databases and their applications- Overview of a Database Management System-Data abstraction and database architecture - The Entity- Relationship Data Model: Elements of the E/R Model , Design Principles, The Modeling of Constraints, Weak Entity Sets - Basics of the Relational Model-From E/R Diagrams to Relational Designs-Converting Subclass Structures to Relations VIEW CHAPTERS
2 Unit 2 The Relational Databases & Sql Functional Dependencies-Rules About Functional Dependencies-Design of Relational Database Schemas  Multivalued Dependencies - Normalization - Relational Algebra: Relational Operations, Extended Operators of Relational Algebra, Constraints on Relations - Tuple Relational Calculus and Domain Relational Calculus - Introduction to SQL - Entering Information - Extracting Information VIEW CHAPTERS
3 Unit 3 Sql Advanced Database Design And Pl/Sql Ensuring Data Validity with Constraints - Speeding Up Results with Indexes - Manipulating Data - Grouping and Aggregating Data - Selecting Data from Different Tables - Queries within Queries - Views - Security and User Authorization in SQL - PL/SQL: Fundamentals - Conditional and Sequential Control- Loops - Cursors in PL/SQL - Stored Procedures and Functions VIEW CHAPTERS
4 Unit 4 Files Organizations, Query Otimization, Concurrency Index Structures: Indexes on Sequential Files, B-Trees, Hash Tables - Query Processing and Optimization: Selection and Join processing algorithms, query tree, query transformation, and evaluation plan - ACID properties - Concurrency Control by Lock, Timestamp, Validation VIEW CHAPTERS
5 Unit 5 Control Transaction management: Serializability and Recoverability, View Serializability, log-Based Recovery, Resolving Deadlocks - Distributed Databases - XML databases  Open source database tools: MySQL, Postgresql, SqLite VIEW CHAPTERS
About Us
Contact Us
Advertising Guidelines
Safe and Secure Payment
All major credit and debit cards are accepted.
Policies: Terms of Use | Privacy    Copyright © 2019 Interline Publishing. All rights reserved.