IIT Madras Online BSc Program - Database Management Systems

Introduction

• Instructor: Prof. Parto Pratim Das, Computer Science and Engineering, IIT Kharagpur.
• Unique Program: First online BSc degree from IIT.
• Course: Database Management Systems (DBMS).

Course Overview

• Objective: Understand the importance of DBMS in today's world.
• Main Focus:
  • Why databases are essential.
  • Course prerequisites, outline, and textbook.

Why Databases?

• Definition: DBMS stores info about an enterprise (business, nation, bank, etc.).
• Applications:
  • Banking (Net banking, UPI, etc.).
  • Reservations (airlines, railways).
  • Academic (universities, ERP systems).
  • E-commerce (Amazon, eBay).
  • Other areas: Manufacturing, HR, travel.
  • Non-traditional uses: Emails, social media.
• Industry Need: Skills in programming, design, and administration of databases are in high demand.

Problems with File Systems

• Issues:
  • Data redundancy and inconsistency.
  • Difficulty accessing data.
  • Data isolation and integrity issues.
  • Lack of atomicity, concurrency, and security.
• Solution: Databases address these issues effectively.

Course Prerequisites

• Essential Knowledge:

  • Set theory: Union, intersection, complement, etc.
  • Relations and functions.
  • Propositional logic and predicate logic.
  • Data structures: Arrays, lists, trees, hashing.
  • Programming in Python.

• Desirable Knowledge:

  • Algorithms and programming in C.
  • Object-oriented analysis, design, and programming.

• References: MOOCs, NPTEL videos, textbooks.

Course Outline

• Duration: 12 weeks, 5 modules per week (Total: 60 modules).
• Structure:
  • Weeks 1-8: Application programming (basic part, industry-oriented).
  • Weeks 9-12: Database administration and design (advanced topics).

Textbook

• Recommended: "Database System Concepts" by Silberschatz, Korth, and Sudarshan.
• Edition: 6th or 7th edition.

Summary

• Importance of DBMS: Integral to modern applications.
• Course Introduction: Set the foundation for the following modules.

Prepare for the next module where actual course content will be discussed.