DA3401 Database Management Systems Syllabus:
DA3401 Database Management Systems Syllabus – Anna University Regulation 2021
UNIT I RELATIONAL DATABASES
Purpose of Database System – Views of Data – Data Models – Database System Architecture – Introduction to Relational Databases – Relational Model – Keys – Relational Algebra – Relational Calculus – SQL Fundamentals – Advanced SQL features – Triggers – Embedded SQL.
UNIT II DATABASE DESIGN
Entity-Relationship Model – ER Diagrams – Functional Dependencies – Non-Loss Decomposition Functional Dependencies – First Normal Form – Second Normal Form – Third Normal Form – Dependency Preservation – Boyce/Codd Normal Form – Multi-Valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form.
UNIT III TRANSACTION MANAGEMENT
Transaction Concepts – ACID Properties – Serializability – Transaction Isolation Levels – Concurrency Control – Need for Concurrency – Lock-Based Protocols – Deadlock Handling – Recovery System – Failure Classification – Recovery Algorithm.
UNIT IV IMPLEMENTATION TECHNIQUES
Overview of Physical Storage Media – RAID – File Organization – Organization of Records in Files – Indexing and Hashing – Ordered Indices – B+ tree Index Files – Static Hashing – Dynamic Hashing Query Processing Overview – Catalog Information for Cost Estimation – Query Optimization.
UNIT V ADVANCED TOPICS
Overview of Distributed Databases – Data Fragmentation – Replication – XML Databases – XML Schema – NOSQL Database: Characteristics – CAP theorem – Types of NoSQL Datastores: Column Oriented, Document, Key-Value and Graph Types – Applications – Current Trends.
TOTAL: 45 PERIODS
OUTCOMES:
On completion of the course, the student will be able to:
CO1: Model an application’s data requirements using conceptual modeling and design database schemas based on the conceptual model.
CO2: Formulate solutions to a broad range of query problems using relational algebra/SQL.
CO3: Demonstrate an understanding of normalization theory and apply such knowledge to the normalization of a database.
CO4: Run transactions and estimate the procedures for controlling the consequences of concurrent data access.
CO5: Explain basic database storage structures, access techniques and query processing.
CO6: Describe distributed, semi-structured and unstructured database systems.
TEXT BOOKS:
1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Sixth Edition, Tata McGraw Hill, 2014.
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2017.
REFERENCES:
1. C. J. Date, A. Kannan, S. Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
2. Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, Fourth Edition, Tata McGraw Hill, 2010.
3. G. K. Gupta, “Database Management Systems”, Tata McGraw Hill, 2011.
4. Carlos Coronel, Steven Morris, Peter Rob, “Database Systems: Design, Implementation and Management”, Ninth Edition, Cengage Learning, 2011.