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 |