Unit-1: Introduction To Database Systems

Database Approach,Actors,DBMS Approach, File System, Database Applications

Unit-2: Database Systems and Architecture

Data Models, Three Tier Architecture, Centralized and Client Server Architecture

Unit-3: Data Modeling

ER Diagram Concepts, EER Diagram, Relational Database Design by ER and EER to Relational Mapping

Unit-4: Structured Query Language

Data Definition Language, Data Manipulation Language, Transcation Control Language, PL-SQL Procedures, Functions, Triggers ODBC,JDBC

Unit-5: Normalization

Functional Dependencies, 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

Unit-6: Transaction Processing

Transaction Processing and System Concepts, Characterizing schedules

Unit-7: Concurrency Control and Techniques

Timestamp Ordering, Multiversion Concurrency Control, Optimisitc Concurrenct Control Database Recovery, Recovery Algorithms Caching, Checkpoints, Transaction Rollback, Recovery Techniques, Database Security and Authorization, Database Security Issues, DAC, MAC, RBAC, Statistical Database, Flow Control, Encryption as Public Key Infrastructure

Text Books

• Elmasri and Navathe, “Fundamentals of Database Systems”, Pearson Education.
• Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, McGraw-Hill

References

• North, Silberchatz, Sudarshan, “Database System Concepts”, McGraw-Hill.
• Peter Rob and Coronel, “Database Systems, Design, Implementation and Management”.
• C.J. Date, Longman, “Introduction to Database Systems”, Pearson Education