| Unit 1 [Book] | |
| Database Systems: Basic Concepts, Data, Information, Fields, Records, Files, Databases | VIEW |
| Evolution and Need for Database Systems in Business | VIEW |
| Hierarchical Data Models | VIEW |
| Network Data Models | VIEW |
| Relational Data Models | VIEW |
| Object-oriented Data Models | VIEW |
| File-oriented Systems and Database Systems | VIEW |
| Three-layered Architecture of DBMS | VIEW |
| Applications, Advantages of Disadvantages of DBMS | VIEW |
| Unit 2 [Book] | |
| Data Modelling | VIEW |
| Database Design | VIEW |
| Entity-Relationship (ER) Model: Entities, Attributes, Relationships, Constraints, ER diagrams, Extended features (Generalization, Specialization, Aggregation) | VIEW |
| Relational Database Model: Structure, Keys (Primary, Foreign) | VIEW |
| Integrity Constraints | VIEW |
| Normalization (1NF, 2NF, 3NF, BCNF) | VIEW |
| Relational Schema and Table Design | VIEW |
| Role and Responsibilities of the Database Administrator (DBA) | VIEW |
| Unit 3 [Book] | |
| Relational Query Languages | VIEW |
| Structured Query Language (SQL) | VIEW |
| Data Definition Language (DDL) | VIEW |
| Data Manipulation Language (DML) | VIEW |
| Creating, Altering, and Deleting Tables, Data types, Constraints, Aggregate Functions, Joins, Sub-Queries, Views | VIEW |
| Transaction Control Commands (Commit, Rollback) | VIEW |
| Relational Algebra and Calculus, Operators: Selection, Projection, Join, Set Operations | VIEW |
| Unit 4 [Book] | |
| Database Implementation | VIEW |
| Database Management | VIEW |
| Database Storage and Physical Structures | VIEW |
| Indexing | VIEW |
| B-trees | VIEW |
| Hashing | VIEW |
| Query Processing and Optimization, Evaluation Strategies | VIEW |
| Query Cost Analysis | VIEW |
| Backup, Recovery, and Disaster Management | VIEW |
| Concurrency control: Locking, Timestamping, Deadlocks | VIEW |
| Transaction Management and ACID Properties | VIEW |
| Unit 5 [Book] | |
| Database Security: Authentication, Authorization, Privileges, Threats; Auditing, Access Controls, Violation Handling | VIEW |
| Data Integrity and Constraints | VIEW |
| Distributed Databases | VIEW |
| Client-server Architecture | VIEW |
| Data Warehousing | VIEW |
| OLAP | VIEW |
| OLTP | VIEW |
| Data Mining | VIEW |
| Practical Applications and Case Studies: | |
| Use of Commercial and Open-source DBMS (e.g., MySQL, Oracle, SQL Server) | VIEW |
| Case Studies from Finance, Marketing, HR, Retail, and e-commerce Sectors | VIEW |
| Designing and Demonstrating a Relational Database for a Business use case | VIEW |