DATABASE MANAGEMENT SYSTEM (Aditya Publication)
Hurry, Only 5 left!
DATABASE MANAGEMENT SYSTEM
Unit-1: Database System Applications, Database Systems versus File Systems, View of Data, Data Models, Database Languages, Database Users and Administrators, Transaction Management, Database System Structure, Application architectures, History of Database Systems. Entity-Relationship Model, Basic Concepts, Constraints, Keys, Design Issues, Entity-Relationship Diagram, Weak Entity Sets, Extended E-R Features, Design of an E-R Database Schema, Reduction of an E-R Schema to Tables.
Unit-2: Relational Model: Structure of Relational Databases, The Relational Algebra, Extended Relational-Algebra Operations, Modification of the Database, Views, The Tuple Relational Calculus, The Domain Relational Calculus. SQL: Basic Structure, Set Operations, Aggregate Functions, Null Values, Nested Subqueries, Views.
Unit-3: Integrity and Security, Domain Constraints, Referential Integrity, Assertions, Triggers, Security and Authorization, Authorization in SQL, Encryption and Authentication, Relational-Database Design:, First Normal Form, Pitfalls in Relational-Database, Design, Functional Dependencies, Decomposition, BCNF, Third, Fourth and more Normal Forms, Overall Database Design Process.
Unit-4: Query Processing: Overview, Measures of Query Cost, Selection Operation, Sorting, Join Operation, Other Operations, Evaluation of Expressions, Query Optimization: Overview, Estimating Statistics of Expression Results, Transformation of Relational Expressions, Choice of Evaluation Plans, Materialized Views.
Unit-5: Transaction Management: Transaction Concept, Transaction State, Implementation of Atomicity and Durability, Concurrent Execution, Serializability, Recoverability, Implementation of Isolation, Transaction Definition in SQL, Testing for Serializability.
Unit-6: Concurrency Control: Lock-Based Protocols, Timestamp-Based Protocols, Validation-Based Protocols, Multiple Granularity, Multiversion Schemes, Deadlock Handling, Insert and Delete Operations Weak Levels of Consistency, Concurrency in Index Structures. Recovery System, issues & solutions.
|Category||Books - Engineering - Computer Science - Semester-VI|
|Dimensions||10(l) * 1(w) *10(h) CM|