IITM BS Database Management Systems (BSCS2001): Syllabus and Tips

Database Management Systems (BSCS2001), called DBMS in the handbook, is a 4 credit diploma level course in the IITM BS in Data Science. It is part of the Diploma in Programming. The course page lists no prerequisite of its own, but like every diploma course it opens only after you pass all 8 foundation courses. It teaches how databases are designed, queried with SQL, stored, indexed and kept safe.

The course page names Prof. Partha Pratim Das of Ashoka University as the instructor.

What you learn

• Weeks 1 to 4: the relational model and SQL. An overview, then tables, keys and basic SQL. Then intermediate and advanced SQL. Then formal query languages and the first steps of database design.
• Weeks 5 to 7: good design and using a database from code. Two weeks on functional dependencies and normal forms, which tell you how to split tables so data is not repeated. Then a week on building applications on top of a database.
• Weeks 8 and 9: what happens on disk. How data is stored, and how indexing and hashing make lookups fast.
• Weeks 10 to 12: keeping data safe and fast. Transactions, backup and recovery, and query optimisation.

The suggested book is Database Management Systems by Abraham Silberschatz, Henry F. Korth and S. Sudarshan, as listed on the course page.

How it is assessed

The course page lists the standard pattern: 12 weeks of coursework, weekly online assignments, 2 in-person invigilated quizzes and 1 in-person invigilated end term exam. It does not mention a programming exam. The handbook says details can change from course to course, so check your term's grading document for an OPPE. Our guide to handling DBMS and PDSA covers exam practice.

Where it counts

• Diploma in Programming. DBMS is one of its 6 theory courses. See the Diploma in Programming.
• Modern Application Development I. The MAD I course page lists DBMS as a corequisite. You take DBMS before MAD I or in the same term.
• Electronic Systems students. The ES handbook lists DBMS (as CS2001, 4 credits, no prerequisite) as an open elective. It is also the first course of the ES Minor in Application Development. See ES minors.
• Terms. The DS handbook says all diploma courses are offered every term.

One mismatch to know. The DS course page for MAD I lists DBMS as a corequisite. The ES handbook's table lists DBMS as a prerequisite of MAD I instead. If you are an ES student, confirm the rule on your registration page.

Who finds it hard

Basic SQL feels familiar quickly. Expect weeks 5 and 6 to need the most practice. Functional dependencies and normal forms are abstract, and many questions need careful step by step work. Weeks 10 to 12 are also theory heavy. Transactions and recovery are hard to picture if you have never seen two users change the same data at once.

How to prepare

1. Run every query yourself. Install a small database such as SQLite or PostgreSQL. Make two or three tables, fill them with a few rows, and try each lecture query. Change one clause and predict the result first.
2. Draw joins. For each join question, write the two small tables on paper and the result table under them. This fixes most join mistakes.
3. Practise attribute closure by hand. Example: if A decides B and B decides C, then the closure of A is A, B and C. So A is a key of a table with columns A, B and C. Do many small cases like this before the quiz.
4. Make a normal form ladder. One line each for what 1NF, 2NF, 3NF and BCNF forbid, with one tiny table that breaks each rule.
5. Picture transactions with a bank example. Two people withdraw from the same account at the same time. Work out what goes wrong if nothing controls the order. The transaction rules in week 10 exist to stop this.

What to take before or after

DBMS pairs naturally with Modern Application Development I (BSCS2003), since MAD I needs it as a corequisite and its project stores data in SQLite. If you want to start the app development courses early, take DBMS in your first diploma term.

Common questions

Can I take DBMS and MAD I in the same term?

Yes. The DS course page lists DBMS as a corequisite of MAD I, so the same term is allowed. ES students should check the mismatch noted above.

Is DBMS part of the Diploma in Data Science?

No. The DS handbook places it in the Diploma in Programming. If you plan to reach the degree level, you need both diplomas, so you will take it either way.

Does DBMS have a separate project?

No. The course page lists only the assignments, quizzes and end term. You use your database skills again in the MAD I project, which the project page says stores data in SQLite.