| Unit 1 Introduction [Book] | |
| DBMS Overview | VIEW |
| Database system Vs file system | VIEW |
| Database System concept and Architecture | VIEW |
| Data model schema and instances | VIEW |
| Data independence | VIEW |
| Database Language and Interfaces, Data definitions language | VIEW |
| DML | VIEW |
| Overall Database Structure | VIEW |
| Data modeling using the Entity Relationship Model: | VIEW |
| ER model concepts | VIEW |
| Notation for ER diagram | VIEW |
| Mapping constraints | VIEW |
| Unit 2 Relational data Model [Book] | |
| Relational data Model and Language | VIEW |
| DBMS Keys, Concepts of Super Key, Candidate key, Primary key | VIEW |
| Relational data model concepts | VIEW |
| integrity constraints, Entity integrity, Referential integrity, Keys constraints, Domain constraints | VIEW |
| Relational algebra, Relational calculus, and Tuple and Domain calculus | VIEW |
| Unit 3 [Book] | |
| Introduction on SQL: Characteristics of SQL, Advantage of SQL | VIEW |
| SQL Data type and Literals | VIEW |
| Types of SQL commands | VIEW |
| SQL operators and their procedure | VIEW |
| Tables, Views and Indexes | VIEW |
| Queries and Sub queries | VIEW |
| Aggregate functions | VIEW |
| SQL: Insert, Update and Delete operations, Joins | VIEW |
| Unions, Intersection, Minus | VIEW |
| Cursors | VIEW |
| Triggers | VIEW |
| Procedures in SQL/PL SQL | VIEW |
| Database Design | VIEW |
| Normalization | VIEW |
| Functional dependencies, normal forms | VIEW |
| First normal forms NF1 | VIEW |
| Second normal forms NF2 | VIEW |
| Third normal forms NF3 | VIEW |
| **BCNF | VIEW |
| **Multivalued Dependencies and fifth Normal form | VIEW |
| Unit 4 [Book] | ||
| Transaction Processing Concept: Transaction system | VIEW | VIEW |
| Testing of serializability, Serializability of schedules, Conflict & View Serializable schedule, Recoverability, Backup, Recovery from transaction failures, Log based recovery, Checkpoints | VIEW | |
| Deadlock handling | VIEW | |
| Concurrency control | VIEW | |
| Locking Techniques for concurrency control, Time stamping protocols for Concurrency control, Validation based protocol, Multiple granularity, Multi version schemes | VIEW | |
| Unit 5 Recent Trends in Database Management Systems [Book] | ||
| Centralized and Client-Server Architectures | VIEW | |
| Distributed Databases | VIEW | VIEW |
| Object-Oriented Database | VIEW | VIEW |
| Temporal Databases | VIEW | |
| Decision Support System | VIEW | |
| Data Analysis | VIEW | |
| Data Mining | VIEW | |
| Data Warehousing | VIEW | |
| Data Visualization | VIEW | |
| Mobile Databases | VIEW | |
| OODB Databases | VIEW | |
| XML Databases | VIEW | |
| Multimedia Databases: | VIEW | |
| Spatial Databases | VIEW | |
| Geographical Databases | VIEW | |
| Web Databases | VIEW | |
| Mobile Databases | VIEW | |
| Active Databases | VIEW | |