COL362/632 Introduction to Data Management Systems

🕰 Tuesday, Wednesday, and Friday 10:00 -- 11:00 (slot E)
📍 LH 308

Notice

Course Logistics

• All course related discussion will take place on Piazza.
• Moodle for lecture notes and assignments.

Teaching Assistants

• Abhinav Barnawal
• Rajat Bhardwaj
• Sadiya Ajaz Churoo
• Nilanjan Ghosh
• Rahul Kumar
• Manshi Sagar

Overview

Data management systems play a foundational role in data analytics. They provide a structured and organized mechanism for storing, querying, and retrieving data, allowing data analysts and scientists to extract specific information and insights from datasets. The course “Introduction to Database Management Systems” will provide students with a comprehensive understanding of the fundamental concepts and principles associated with designing and implementing data management systems focusing on relational database management systems. The course aims to empower students with a solid foundation in data management systems, preparing them for more advanced studies or professional roles in data analytics and related fields.

Objectives

• Fundamentals: Develop a foundational understanding of the basic concepts and principles associated with data management systems.

• Relational Data Modeling: Introduce students to ER and relational data model and equip them with the skills to design and create effective database structures.

• Query Language Proficiency: Familiarize students with Relational Algebra and Structured Query Language (SQL) to enable them to interact with databases and perform analytical tasks including retrieval, data manipulation, and reporting.

• Database Design and Implementation: Provide knowledge and skills for designing and implementing databases systems, and applying them to broader data analytical tasks.

• Practical Application: Offer hands-on experience and practical exercises to apply theoretical knowledge, allowing students to develop the skills needed for real-world scenarios in data analytics.

Prerequisites

• COL 106
• Programming in Java/C/C++

Recommended Textbooks

B1. Database System Concepts (7 ed.) by Silberschatz, Korth and Sudarshan, McGraw-Hill.

B2. Database Systems: The Complete Book (2 ed.) by Garcia-Molina, Ullman, Widom, Prentice Hall.

Evaluation

The course will follow the IIT Honor code

Grading

Late Submission Policy

• You have a total of 72 late hours (across all assignments).
• Late hours will be counted in granularity of hours. For example, if you submit an assignment 20 mins past its deadline, 1 hour will be subtracted from your late hour.
• You will get a penalty of (-20)% for each late day after you have exhausted all your late hours.

Pass Criteria

• Score at least 30% to pass the course (D grade)

Audit Policy

• Score 50% overall.
• Attempt and submit all assignments and score at least 50%.

Attendance Policy

• If attendance is less than 75%, the student will be awarded one grade less than the actual grade that he/she has earned. For example, a student who has got an A grade but has attendance less than 75% will be awarded an A(-) grade.
• A student cannot get NP for an audit course if his/her attendance is less than 75%.

Syllabus