Introduction to Database Systems

By Prof. Sreenivasa Kumar | IIT Madras

Learners enrolled: 7913

Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard

INTENDED AUDIENCE : Any Interested Learners

PREREQUISITES : Studying B Tech (computer science) 3rd year, Discrete Mathematics and Data Structures

INDUSTRY SUPPORT : NILL

Summary

Course Status :	Completed
Course Type :	Core
Language for course content :	English
Duration :	12 weeks
Category :	Computer Science and Engineering
Credit Points :	3
Level :	Undergraduate
Start Date :	27 Jan 2020
End Date :	17 Apr 2020
Enrollment Ends :	03 Feb 2020
Exam Date :	26 Apr 2020 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 : Introduction and part of E/R Model Module
Week 2 : ER Model Module
Week 3 : Relational Model Module
Week 4 : Relational Model Module
Week 5 : TRC Module and part of SQL Module
Week 6 : SQL Module
Week 7 : Indexes Module
Week 8 : Indexes Module + Query Processing Module
Week 9 : Normal Forms Module
Week 10 : Normal Forms Module
Week 11 : Transaction Processing Module
Week 12 : Transaction Processing Module

Books and references

Database Systems by Ramez Elmasri and Shamkanth Navathe, Pearson Publications

Instructor bio

Prof. Sreenivasa Kumar

IIT Madras

The instructor Dr P Sreenivasa Kumar has been a member of the faculty of the CSE Dept for the past two decades. His research interests are: databases, semi-structured data and XML, theory and applications of ontologies. He completed his Masters and PhD from the Department of Computer Science and Automation of Indian Institute of Science, Bangalore.

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: 26th April 2020, 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 8 assignments out of the total 12 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 Madras. It will be e-verifiable at nptel.ac.in/noc.
• Only the e-certificate will be made available. Hard copies will not be dispatched.

SWAYAM Helpline / Support