Madhavan Mukund

RDBMS and SQL

Aug–Nov 2025

Administrative details

• Instructor: Madhavan Mukund

• Teaching Assistants: None

• Evaluation:

  • Assignments, final exam

  • Weightage approximately 60%, 40%, to be confirmed

  • Copying is fatal

• Text and reference books:

  • Database System Concepts (7th Edition), Avi Silberschatz, Henry F. Korth, S. Sudarshan

Course plan

This list is approximate and subject to change.

• The relational model
  • History
  • Relational algebra
• SQL
  • Basic queries
  • Creating and updating tables
  • Aggregate queries
• Storing tables on disk
• Query processing
• Transactions and consistency

Assignments

• TBA

Lectures

• Lecture 1: 14 Aug 2025
  (Class Notes)

  • Why DBMS? Overview of concepts to be discussed in the course
  • Reference: Silberschatz et al, Ch 1.1, 1.2

  Supplementary reading

  • A Relational Model of Data for Large Shared Data Banks, E.F. Codd, CACM, Jun 1970
  • A Brief History of Databases