Subject Code & Name: CS25C13 – Database Management Systems
Regulation: R-2025
Semester: IV (Fourth Semester)
Branch: B.E. Computer Science and Engineering (CSE) / B.Tech. Information Technology (IT) / B.Tech. Artificial Intelligence and Data Science (AI&DS) / B.Tech. Computer Science and Business Systems (CSBS) / B.E. Computer and Communication Engineering (CCE) / B.E. Computer Science and Engineering (Data Science) (CSE(DS)) / B.E. Computer Science and Engineering (Internet of Things) (CSE(IoT)) / B.E. Computer Science and Engineering (Cyber Security) (CSE(Cyber)) / B.E. Computer Science and Engineering (Artificial Intelligence and Machine Learning) (CSE(AI&ML)) / B.E. Computer Science and Design (CSD)
Credits / L-T-P: 5 Credits | L-T-P: 3-0-4
Course Objectives
- This course provides a comprehensive foundation in database system concepts, including architecture, data modeling, and query languages.
- The course discusses the concepts of transaction management, concurrency control and query optimization.
Full Unit-wise Syllabus
Unit I – DBMS and Data Modeling
Purpose – architecture and types of DBMS – Data models: traditional, hierarchical, network, relational, object-oriented – DBMS architecture – Database users and languages (DDL, DML, DCL) – basic SQL queries.
Practical: Installation and configuration of open-source DBMS; Creation of databases and SQL operations.
Unit II – Data Modeling and Relational Design
Entity Types, Entity Sets – Attributes – Keys: Candidate, Primary, Foreign – Relationship Types & Roles – Constraints: Participation, Degree – Weak Entities & Keys – Converting ER Diagrams to Relations – Handling M:N relationships, ISA hierarchies – EER Extensions: Specialization/Generalization.
Practical: Creation of ER Model for a real-world scenario using Draw.io and Lucidchart; Conversion of ER Diagram to Relational Schema.
Unit III – SQL Commands
Primary key, foreign key, unique, not null, check, IN operator, Functions – aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-Queries: Use of group by, having, order by, join and its types, Exist, Any, All, view and its types. Transaction control commands.
Practical: Creation of sample database and perform CRUD operations; Combining data from multiple tables and perform complex data retrieval.
Unit IV – Database Design and Normalization
Functional dependencies – Normal forms: 1NF, 2NF, 3NF, 4NF, BCNF – Decomposition, lossless joins – Impact of normalization on schema.
Practical: Identification of functional dependency, entities and attributes; Implementation of the schema in SQL tool and populate with sample data.
Unit V – Transactions, Concurrency and Recovery
ACID Properties – Transaction States (active, committed, aborted) – System and User Transactions – Serializability – Locking Protocols (2PL), Timestamp Ordering, Deadlocks – Isolation Levels – Log-Based Recovery: Write-Ahead Logging – Checkpoints – ARIES – Shadow Paging.
Practical: ACID properties (e.g., missing commit, unhandled rollback); Simulation of transaction in SQL.
Unit VI – Query Processing and Indexing
Parsing, Validation, Query Trees – Query Execution Plans – Cost Estimation – Physical Plan Strategies – Heuristics and Cost-Based Optimization – Disk Storage, RAID – File Organization – B+-Tree Indexes – Hash-Based Indexing: Static & Dynamic – NoSQL.
Practical: Query Optimization Simulation Using Query Trees; Analyze and compare execution plans in MySQL/PostgreSQL.
Course Outcomes (COs)
- CO1: Describe the fundamental concepts of database management systems and data models.
- CO2: Analyze database methods to ensure efficient data organization and retrieval.
- CO3: Evaluate database design approaches in maintaining data integrity.
- CO4: Design database solutions for real-world applications.
- CO5: Develop the ability to apply emerging topics through continuous self-learning.
Assessment Pattern (Quick Note)
- Weightage: Continuous Assessment 50% | End Semester Theory Examination 50%
- Internal methodology: Activities 10% (Assignments 30, Quiz 10, Project based learning 25, Flipped Classroom 10, Review of GATE questions 25), Internal Theory Examinations 30% (TWO tests), Internal Laboratory Examination 10%
Source: Official Anna University – B.E. Computer Science and Engineering R-2025 Syllabus
Last Updated: October 2026
Comments
Post a Comment