Data Base Management System

By Prof. Partha Pratim Das, Prof. Samiran Chattopadhyay | IIT Kharagpur

Learners enrolled: 15056

Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.

While DBMS’s differ in the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.

INTENDED AUDIENCE : Students from all disciplines can enroll for this course.
PRE-REQUISTES :1. Procedural and / or Object-Oriented Programming (C / C++ / Java / Python)

2. Data Structures

3. Algorithms
INDUSTRY SUPPORT : DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems, data mining, machine learning) have a need for the same. These include – Microsoft, Samsung, Xerox, Yahoo, Google, IBM, TCS, Infosys, Amazon, Flipkart, etc.

Summary

Course Status :	Completed
Course Type :	Core
Language for course content :	English
Duration :	8 weeks
Category :	Computer Science and Engineering Programming
Credit Points :	2
Level :	Undergraduate/Postgraduate
Start Date :	18 Jan 2021
End Date :	12 Mar 2021
Enrollment Ends :	01 Feb 2021
Exam Date :	21 Mar 2021 IST

Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout

Week 1: Course Overview. Introduction to RDBMS
Week 2: Structured Query Language (SQL)
Week 3: Relational Algebra. Entity-Relationship Model
Week 4: Relational Database Design
Week 5: Application Development. Case Studies. Storage and File Structure
Week 6: Indexing and Hashing. Query Processing
Week 7: Query Optimization. Transactions (Serializability and Recoverability)
Week 8: Concurrency Control. Recovery Systems. Course Summarization.

Books and references

Text Books / Basic Material
– Database System Concepts by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, 6th Edition, McGraw-Hill Education, 2010.
– Presentations used in the Course

Reference (Advanced) Material
This is a first level course. So the textbook would be the primary resource also for the advanced chapters. In addition, some references will be specified for every topic during the course.

Instructor bio

Prof. Partha Pratim Das

IIT Kharagpur

Prof. Partha Pratim Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He served as a faculty in Department of Computer Science and Engineering, IIT Kharagpur from 1988 to 1998. In 1998, he joined Alumnus Software Ltd as a Business Development Manager. From 2001 to 2011, he worked for Interra Systems, Inc. as a Senior Director and headed its Kolkata Center. In 2011, he joined back to Department of Computer Science and Engineering, IIT Kharagpur as Professor. Dr. Das has also served as a Visiting Professor with Institute of Radio Physics and Electronics, Calcutta University from 2003 to 2013.

Dr. Das is currently the Head of Rajendra Mishra School of Engineering Entrepreneurship, the Professor-inCharge of the upcoming Research Park of IIT Kharagpur at Rajarhat, Kolkata, and the Joint Principal Investigator of National Digital Library of India project of MHRD.

Dr. Das has taught several courses in Computer Science including Software Engineering, Object-Oriented Systems, Programming and Data Structure, Compiler Design, Design and Analysis of Algorithms, Information System Design, Database Management Systems, Computational Geometry, Principles of Programming Languages, Embedded Systems, and Image Processing. Jointly with 2 others, he has also offered a course on Introduction to Design of Algorithms under the T10KT program of NME-ICT, MHRD (https://www.facebook.com/t10kt.algorithms/) to nearly 7000 teachers. Further, Dr. Das has been offering Programming in C++ and Object-Oriented Analysis and Design in NPTEL-NOC. Both courses are regularly attended by thousands of students.

Dr. Das has published over 40 technical papers in international journals in areas of Digital Geometry, Image Processing, Parallel Computing and Knowledge-based Systems. In 2013 he has co-authored a research monograph titled Digital Geometry in Image Processing (CRC Press). His current interests include Human-Computer Interactions, Computer Analysis of Indian Classical Dance, Object-Oriented Systems Analysis and Design, Software Engineering, Compiler Technology, and Technology Enabled Learning. Dr. Das is a member of Association of Computing Machinery (ACM), The Institute of Electrical and Electronics Engineers (IEEE), and Indian Unit for Pattern Recognition and Artificial Intelligence (IUPRAI).

Prof. Samiran Chattopadhyay

Samiran Chattopadhyay received his B.Tech and M.Tech degrees in 1987, and 1989 respectively from IIT Kharagpur. He received his PhD in 1993 from Jadavpur University. He served as a faculty in Department of Computer Science and Engineering, Jadavpur University from 1989 to 1993 and 1997 to 2001 before joining the department of Information Technology. He has two decades of experience in serving reputed Industry houses such as Computer Associates, Interra Systems India, Agilent, Motorola as Technical consultants. Dr. Chattopadhyay has also served as an Adjunct faculty at IIT Kharagpur.

Course certificate

The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
Date and Time of Exams: 21 March 2021 Morning session 9am to 12 noon; Afternoon Session 2pm to 5pm.
Registration url: Announcements will be made when the registration form is open for registrations.
The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.

CRITERIA TO GET A CERTIFICATE

Average assignment score = 25% of average of best 6 assignments out of the total 8 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

Certificate will have your name, photograph and the score in the final exam with the breakup.It will have the logos of NPTEL and IIT Kharagpur .It will be e-verifiable at nptel.ac.in/noc.

Only the e-certificate will be made available. Hard copies will not be dispatched.

Once again, thanks for your interest in our online courses and certification. Happy learning.

- NPTEL team

SWAYAM Helpline / Support