Sample Course Plan

Course Plan of 20MCA102 – Advanced Database Management Systems
(2021 Batch)

 

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