Skip to content
SmartFigureEdu

Anna University · Regulation 2021

CS 3492 Database Management Systems question papers

CS3492 Database Management Systems previous year question papers from Anna University (Regulation 2021), with the full syllabus. Read online or download the PDF.

Fourth semester · Core · L T P C: 3 0 0 3

Question papers

Syllabus

  1. Unit 1: Relational Databases10 hours

    Purpose of Database System · Views of data · Data Models · Database System Architecture · Introduction to relational databases · Relational Model · Keys · Relational Algebra · SQL fundamentals · Advanced SQL features · Embedded SQL · Dynamic SQL

  2. Unit 2: Database Design8 hours

    Entity-Relationship model · E-R Diagrams · Enhanced-ER Model · ER-to-Relational Mapping · Functional Dependencies · Non-loss Decomposition · First · Second · Third Normal Forms · Dependency Preservation · Boyce/Codd Normal Form · Multi-valued Dependencies and Fourth Normal Form · Join Dependencies and Fifth Normal Form

  3. Unit 3: Transactions9 hours

    Transaction Concepts · ACID Properties · Schedules · Serializability · Transaction support in SQL · Need for Concurrency · Concurrency control · Two Phase Locking · Timestamp · Multiversion · Validation and Snapshot isolation · Multiple Granularity locking · Deadlock Handling · Recovery Concepts · Recovery based on deferred and immediate update · Shadow paging · ARIES Algorithm

  4. Unit 4: Implementation Techniques9 hours

    RAID · File Organization · Organization of Records in Files · Data dictionary Storage · Column Oriented Storage · Indexing and Hashing · Ordered Indices · B+ tree Index Files · B tree Index Files · Static Hashing · Dynamic Hashing · Query Processing Overview · Algorithms for Selection · Sorting and join operations · Query optimization using Heuristics · Cost Estimation

  5. Unit 5: Advanced Topics9 hours

    Distributed Databases: Architecture · Data Storage · Transaction Processing · Query processing and optimization · NOSQL Databases: Introduction · CAP Theorem · Document Based systems · Key value Stores · Column Based Systems · Graph Databases. Database Security: Security issues · Access control based on privileges · Role Based access control · SQL Injection · Statistical Database security · Flow control · Encryption and Public Key infrastructures · Challenges