| Hour No. |
Module |
Proposed Date |
Topic |
|
|
| 1 |
1 |
21-03-2022 |
Introduction – Purpose of Database System – Database System Applications |
| 2 |
|
22-03-2022 |
View of data: Data Abstraction, Instances and Schemas, Data Models |
| 3 |
|
23-03-2022 |
Database Architecture, Database Users and Interfaces, DBA |
| 4 |
|
24-03-2022 |
Introduction to the Relational Model: Structure of Relational Database, DB Schema, Keys |
| 5 |
|
24-03-2022 |
Exercises based on Relational Algebra Operations |
| 6 |
|
28-03-2022 |
Relational Query language, The Relational Algebra: Fundamental Operations |
| 7 |
|
28-03-2022 |
Formal definition of the relational algebra,Additional relational algebra operations |
| 8 |
|
28-03-2022 |
Exercises based on Additional Relational Algebra Operations |
| 9 |
|
29-03-2022 |
The Entity-Relationship model: Entity Set, Relationship Set, Attributes |
| 10 |
|
30-03-2022 |
Constraints: Mapping cardinalities,Key Constraints, Participation Constraints |
| 11 |
|
31-03-2022 |
Relational Database Design using ER- to Relational Mapping |
| 12 |
|
31-03-2022 |
ER Diagram- Structure, Complex attributes, Roles, Non binary relationship sets, Weak Entity |
| 13 |
|
01-04-2022 |
Extended ER Features: Specialization,Generalization |
| 14 |
|
04-04-2022 |
Constraints on Specialization,Generalization, Inheritance, Aggregation |
| 15 |
|
04-04-2022 |
ER Diagram Exercises |
| 16 |
2 |
05-04-2022 |
Database Tables and Normalization – The Need for Normalization |
| 17 |
|
06-04-2022 |
The Normalization Process: Inference Rules for Functional Dependencies |
| 18 |
|
07-04-2022 |
Minimal set of Functional Dependencies – Conversion to 1NF,2NF |
| 19 |
|
08-04-2022 |
Conversion to Third Normal Form |
| 20 |
|
13-04-2022 |
Exercises based on Normalization |
| 21 |
|
13-04-2022 |
Higher Level Normal Forms: Boyce/Codd Normal Form |
| 22 |
|
18-04-2022 |
Fourth Normal Form, Join dependencies and Fifth Normal Form |
| 23 |
|
18-04-2022 |
Normalization and Database Design, Improving the Design – Surrogate Key Considerations |
| 24 |
|
19-04-2022 |
Normalization Exercises |
| 25 |
3 |
25-04-2022 |
Transaction: Evaluating Transaction Results, Transaction ACID Properties |
| 26 |
|
26-04-2022 |
Transaction Management with SQL, Transaction Log |
| 27 |
|
27-04-2022 |
Concurrency Control: Lost Updates, Uncommitted Data, Inconsistent Retrievals |
| 28 |
|
28-04-2022 |
The Scheduler, Concurrency Control with Locking Methods: Lock Granularity |
| 29 |
|
29-04-2022 |
Lock Types, Two Phase Locking to Ensure Serializability |
| 30 |
|
03-05-2022 |
Deadlocks |
| 31 |
|
04-05-2022 |
Concurrency Control with Time stamping Methods: Wait/Die and Wait/Wound Schemes |
| 32 |
|
05-05-2022 |
Concurrency Control with Optimistic Methods |
| 33 |
|
06-05-2022 |
Database Recovery Management: Transaction Recovery |
| 34 |
4 |
09-05-2022 |
RAID |
| 35 |
|
10-05-2022 |
File Organization |
| 36 |
|
11-05-2022 |
Organization of Records in Files |
| 37 |
|
12-05-2022 |
Indexing and Hashing: Basic concept, Ordered Indices |
| 38 |
|
13-05-2022 |
B+ tree Index Files: Structure of a B+-Tree |
| 39 |
|
16-05-2022 |
B tree Index Files |
| 40 |
|
17-05-2022 |
Static Hashing, Dynamic Hashing |
| 41 |
|
18-05-2022 |
Dynamic Hashing |
| 42 |
|
19-05-2022 |
Query Processing: Overview, Selection Operation |
| 43 |
|
20-05-2022 |
Query Processing: Selection Operation |
| 44 |
5 |
23-05-2022 |
Distributed Databases: Homogeneous and Heterogeneous Databases |
| 45 |
|
24-05-2022 |
Distributed Data Storage, Distributed Transactions |
| 46 |
|
25-05-2022 |
Object Based Databases: Overview, Complex Data types |
| 47 |
|
30-05-2022 |
Structured types and inheritance in SQL |
| 48 |
|
31-05-2022 |
Table Inheritance |
| 49 |
|
01-06-2022 |
Array and Multiset types in SQL |
| 50 |
|
02-06-2022 |
Object Identity and reference types in SQL |
| 51 |
|
03-06-2022 |
XML:DTD and XML Schema |
| 52 |
|
06-06-2022 |
XML Presentations, XML Applications |
| 53 |
|
07-06-2022 |
Next Generation Databases:Distributed Relational Databases, CAP theorem |
| 54 |
|
08-06-2022 |
Norelational Databases – MongoDB sharding and Replication |
| 55 |
|
09-06-2022 |
Hbase |
| 56 |
|
10-06-2022 |
Cassandra |