Database Management Systems


Unit – I : Introduction (Chapter – 1)
Introduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, Data Models, Database Design and ER Model: Entity, Attributes, Relationships, Constraints, Keys, Design Process, Entity Relationship Model, ER Diagram, Design Issues, Extended E-R Features, converting E-R & EER diagram into tables.
Unit – II : SQL AND PL/SQL (Chapter – 2)
SQL : Characteristics and advantages, SQL Data Types and Literals, DDL, DML, DCL, TCL, SQL Operators, Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updating using Views, Indexes, SQL DML Queries: SELECT Query and clauses, Set Operations, Predicates and Joins, Set membership, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database Modification using SQL Insert, Update and Delete Queries. PL/SQL : concept of Stored Procedures & Functions, Cursors, Triggers, Assertions, roles and privileges , Embedded SQL, Dynamic SQL.
Unit – III : Relational Database Design (Chapter – 3)
Relational Model: Basic concepts, Attributes and Domains, CODD’s Rules, Relational Integrity: Domain, Referential Integrities, Enterprise Constraints, Database Design: Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, Algorithms for Decomposition, 2NF, 3NF, BCNF, Modeling Temporal Data.
Unit – IV : Database Transactions and Query Processing (Chapter – 4)
Basic concept of a Transaction, Transaction Management, Properties of Transactions, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking Methods, Deadlocks, Time-stamping Methods, Recovery methods : Shadow-Paging and Log-Based Recovery, Checkpoints, Query Processing, Query Optimization, Performance Tuning.
Unit – V : Parallel and Distributed Databases (Chapter – 5)
Introduction to Database Architectures: Multi-user DBMS Architectures, Case study- Oracle Architecture. Parallel Databases : Speedup and Scale up, Architectures of Parallel Databases.
Distributed Databases : Architecture of Distributed Databases, Distributed Database Design, Distributed Data Storage, Distributed Transaction : Basics, Failure modes, Commit Protocols, Concurrency Control in Distributed Database.
Unit VI : NoSQL Database (Chapter – 6)
Introduction to NoSQL Database, Types and examples of NoSQL Database- Key value store, document store, graph, Performance, Structured verses unstructured data, Distributed Database Model, CAP theorem and BASE Properties, Comparative study of SQL and NoSQL, NoSQL Data Models, Case Study-unstructured data from social media. Introduction to Big Data, HADOOP: HDFS, MapReduce.



Written By:—  Seema Kedar,Rakesh Shirsath ISBN 9789333215497

Reviews (0)


There are no reviews yet.

Be the first to review “Database Management Systems”

Your email address will not be published. Required fields are marked *

Shipping & Delivery

Vestibulum curae torquent diam diam commodo parturient penatibus nunc dui adipiscing convallis bulum parturient suspendisse parturient a.Parturient in parturient scelerisque nibh lectus quam a natoque adipiscing a vestibulum hendrerit et pharetra fames.Consequat net

Vestibulum parturient suspendisse parturient a.Parturient in parturient scelerisque nibh lectus quam a natoque adipiscing a vestibulum hendrerit et pharetra fames.Consequat netus.

Scelerisque adipiscing bibendum sem vestibulum et in a a a purus lectus faucibus lobortis tincidunt purus lectus nisl class eros.Condimentum a et ullamcorper dictumst mus et tristique elementum nam inceptos hac vestibulum amet elit