| Module | Important Topics |
|---|
| Introduction to Database Systems | Database System Concepts, Database System Architectures, Data Models, Database Languages, Database Users and Administrators |
| Entity-Relationship Model | ER Diagrams, Entity Sets, Relationship Sets, Design Issues, Mapping Constraints, Keys, ER Diagram to Table Conversion |
| Relational Model | Structure of Relational Databases, Relational Algebra, SQL, Integrity Constraints, Relational Database Design |
| SQL and Advanced SQL | SQL Queries, Subqueries, Joins, Views, Indexes, Stored Procedures, Triggers, Cursors |
| Normalization | Functional Dependencies, Anomalies, Normal Forms, Decomposition, Lossless Join and Dependency Preserving Decomposition |
| Transaction Management and Concurrency Control | ACID Properties, Transaction States, Serializability, Lock-Based Protocols, Timestamp-Based Protocols, Deadlock Handling |
| Database Recovery Techniques | Recovery Concepts, Recovery Techniques, Shadow Paging, Log-Based Recovery, Checkpoints, Recovery with Concurrent Transactions |
| Database Security and Authorization | Discretionary Access Control, Mandatory Access Control, Role-Based Access Control, Security Threats, Encryption and Public Key Infrastructures |
| NoSQL Databases | Introduction to NoSQL, Types of NoSQL Databases, Key-Value Stores, Document Stores, Column-Family Stores, Graph Databases |
This table provides a structured overview of the important topics for a BCA in Database Management at the University of Technology - Sanganer, as per the syllabus. Note that the specific topics and their organization might vary slightly depending on the most current curriculum updates.
