KMBNIT03 DATABASE MANAGEMENT SYSTEM UNIT 1 Introduction DBMS Overview, Database system Vs file system Database system concept and Architecture, Data model Schema and Instances Data Independence, DML, Overall Database Structure Data Modelling using the Entity Relationship Model, ER Model concept, Notation for ER diagram Mapping Constraints UNIT 2 Relational data Model Relational data Model and Language DBMS keys, Concepts of Super Key, Candidate Key, Primary Key Relational data model concept Integrity Constraint, Entity Integrity, Referential Integrity, Keys Constraint, Domain Constraint Relational algebra, Relational calculus, and Tuple and Domain calculus UNIT 3Â Introduction on SQL Characteristics of SQL , Advantage of SQL, SQL Data type and Literals Types of SQL Commands, SQL Operators and their procedure Tables, Views and Indexes, Queries and Sub Queries Aggregate functions, SQL: Insert and Delete operations, Joins Unions, Intersections, Minus, Cursors, Triggers, Procedure in SQL/PL SQL Database Design, Normalization, Functional Dependencies , Normal forms, First Normal Form NF1, Second Normal Forms NF2, Third normal forms NF3 BCNF, Multi-valued dependencies and fifth Normal Forms UNIT 4Â Transactions Processing Concept : Transaction System Testing of Serializability , Serializability of Schedule, Conflict and Serializable Schedule Recover-ability, Backup, Recovery from Transactions failures, Log based recovery Check points Deadlock Handling, Concurrency Control Locking Techniques, for currency control , Time Stamping protocols for concurrency control, Validation based protocol Multiple Granularity, Multi version Scheme UNIT 5 Recent Trends in Database Management system Centralized and Client server Architectures, Distributed Database, Object- Oriented Database Temporal Database, Decision Support System, Data Analysis Data Mining, Data Warehousing, Data Visualizations Mobile Database, OODB database, XML Database Multimedia Database, Spatial Database, Geographical Database, Web Database, Active Database
