The main objective of this course is to present an introduction to database management systems, with an emphasis on how to organize, maintain and retrieve - efficiently and effectively - information from such systems. The major focus will be on practical learning with an understanding of real-life scenarios.
| Set | Due Date | Marks |
|---|---|---|
| Assignment 1 (+ solutions) | 31-08-2019 | Link |
| Assignment 2 (+ solutions) | 30-09-2019 | Link |
| Assignment 3 | 31-10-2019 | Link |
| Set | Due Date | Marks |
|---|---|---|
| Projects 1-5 (Research) | 15-12-2019 | |
| Projects 6-10 (Modeling) | 15-12-2019 | |
| Projects 11-15 (Development) | 15-12-2019 | |
| Project Assignment (Group Size: 4/5) | Link | |
Marks Distribution: MID-SEMESTER - 30; SEMESTER - 50; ASSIGNMENT - 10; PROJECT - 10
Instructor: Malay Bhattacharyya (MIU)
Venue: Room No. - 520, 5th Floor, S N Bose Bhavan (Library Building)
Timings: Monday (14:15 - 16:15), Thursday (11:00 - 13:00)
Basics, History, Data Abstraction, Languages, Databse System Components, Limitations
SLIDES
August 01, 2019 (Thursday)
August 05, 2019 (Monday)
Preliminaries, Operations on Sets, Unary and Binary Operations, Special Operations, Extended Operations, Completeness
SLIDES
Entity-Relationship Data Model (Basics, Constraints, Concept of Keys, Special Features), The Entity-Relationship diagram (Components, Real-life Examples)
SLIDES
August 08, 2019 (Thursday)
Continued ...
August 09, 2019 (Friday)
August 19, 2019 (Monday)
Preliminaries, Data Definition (Principle Structure, Database Creation, Database Modification)
SLIDES
Data Manipulation (Principle Structure, Relational Operations, Logical Operations, Set Operations, Other Features)
SLIDES
August 26, 2019 (Monday)
Integrity Control, Basic Integrity Preservation (Fundamentals, Primary Key, Foreign Key, Nullity Check, General Check)
SLIDES
September 05, 2019 (Thursday)
September 09, 2019 (Monday)
Advanced Integrity Preservation (Basics, Creating Triggers, Creating Multiple Triggers, Limitations), Cursors
SLIDES
Basics, Statistics for Query Evaluation (Relation Statistics, Query Statistics)
SLIDES
September 16, 2019 (Monday)
September 19, 2019 (Thursday)
Query Equivalence, Query Tuning (Motivation, Logical and Physical Plan, Optimizing Search Strategies)
SLIDES
Data Redundancy, Normalization, Denormalization, Applications
SLIDES
September 30, 2019 (Monday)
October 14, 2019 (Monday)
First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form
SLIDES
Transaction Life Cycle, Concurrent Execution of Transactions, Serializability (Conflict Serializability, View Serializability, Testing for Serializability)
SLIDES
October 17, 2019 (Thursday)
October 21, 2019 (Monday)
Concurrency Control Protocols (Lock-based Protocols, Graph-based Protocols, Timestamp-based Protocols, Validation-based Protocols), Multiple granularity, Multiversion Schemes, Concurrency in Indexes
SLIDES
Basics, Advantages and Challenges, Some Concepts, Implementations
SLIDES
October 24, 2019 (Thursday)
October 28, 2019 (Monday)
Basic Features, Data Definition (Data Types, Database Creation, Database Deletion), Data Manipulation, Data View in MongoDB
SLIDES
Parallel Databases (Basics, Parallelism in Databases, Interquery and Intraquery Parallelism), Distributed Databases (Basics, Data Distribution, Fragmentation, Distributed Transaction Management, Distributed Deadlock Handling)
SLIDES
October 31, 2019 (Thursday)
November 04, 2019 (Monday)
Object-oriented Databases (Basics, Object Structures, Nested Relation and Decomposition, Structured Types and Inheritance), Multimedia Databases (Basics, Concept of Metadata, Multimedia Database Support by SQL)
SLIDES
Graph Databases (Basics, Property Graph Model, Neo4j), Browser Databases (Basics, PouchDB, IndexedDB)
SLIDES
November 07, 2019 (Thursday)
November 11, 2019 (Monday)
Theory
Problems
November 14, 2019 (Thursday)
November 18, 2019 (Monday)
Designing a Standard Business Environment, Relational Data Model
Designing a Start-up Business Environment, NoSQL Model
November 21, 2019 (Thursday)