Database Management Systems for SPPU

Unit - (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 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 - AND PL/SQL (Chapter - 2) Characteristics and advantages, SQL Data Types and Literals, DDL, DML, DCL, TCL, SQL Operators, Creating, Modifying, Deleting, Creating, Dropping, Updating using Views, Indexes, SQL DML 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/ concept of Stored Procedures & Functions, Cursors, Triggers, Assertions, roles and privileges , Embedded SQL, Dynamic SQL.Unit - Database Design (Chapter - 3)Relational Basic concepts, Attributes and Domains, CODD's Rules, Relational Domain, Referential Integrities, Enterprise Constraints, Database 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 - Transactions and Query Processing (Chapter - 4)Basic concept of a Transaction, Transaction Management, Properties of Transactions, Concept of Schedule, Serial Schedule, Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Need, Locking Methods, Deadlocks, Time-stamping Methods, Recovery Shadow-Paging and Log-Based Recovery, Checkpoints, Query Processing, Query Optimization, Performance Tuning.Unit - and Distributed Databases (Chapter - 5)Introduction to Database Multi-user DBMS Architectures, Case study- Oracle Architecture. Parallel Speedup and Scale up, Architectures of Parallel Databases.Distributed Architecture of Distributed Databases, Distributed Database Design, Distributed Data Storage, Distributed Basics, Failure modes, Commit Protocols, Concurrency Control in Distributed Database.Unit 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, HDFS, MapReduce.