Course Name: Data Base Management System

Course abstract

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 details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine 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. It would also introduce 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 will also be introduced.


Course Instructor

Media Object

Prof. Partha Pratim Das

Dr. 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 and the coordinator for the upcoming Technology Park of IIT Kharagpur at Rajarhat, Kolkata. He is also the Joint Principal Investigator of National Digital Library project of MHRD and leads the initiative to integrate the Institutional Digital Repositories of various institutions across India.Dr. Das has taught several courses in Computer Science. In the past 5 years he has been teaching Software Engineering, Object-Oriented Systems, Programming and Data Structure, and Compiler Design. 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.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 Image Processing and Computer Vision (human activity tracking using Kinect), Object-Oriented Systems Analysis and Design (UML, Design Patterns and C++11), Software Engineering (automated program analysis using static and dynamic instrumentation), Compiler Technology (multi-threaded debugging), Digital Geometry, and Embedded Systems.Dr. Das is a member of Association of Computing Machinery (ACM), The Institute of Electrical and Electronics Engineers (IEEE), Indian Unit for Pattern Recognition and Artificial Intelligence (IUPRAI) and VLSI Society of India (VSI).
More info
Media Object

Prof. Samiran Chattopadhaya

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
More info

Teaching Assistant(s)

Munmun Bhattacharya

Not a student

Pragma Kar

P.hD

Tohida Rehman

P.hD

 Course Duration : Jan-Mar 2020

  View Course

 Enrollment : 18-Nov-2019 to 03-Feb-2020

 Exam registration : 16-Dec-2019 to 21-Feb-2020

 Exam Date : 29-Mar-2020

Enrolled

26729

Registered

1714

Certificate Eligible

872

Certified Category Count

Gold

2

Silver

87

Elite

302

Successfully completed

481

Participation

615

Success

Elite

Silver

Gold





Legend

AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75 AND FINAL SCORE >=40
BASED ON THE FINAL SCORE, Certificate criteria will be as below:
>=90 - Elite + Gold
75-89 -Elite + Silver
>=60 - Elite
40-59 - Successfully Completed

Final Score Calculation Logic

  • Assignment Score = Average of best 6 out of 8 assignments.
  • Final Score(Score on Certificate)= 75% of Exam Score + 25% of Assignment Score We have taken best assignment score from Both Jan and July course
Data Base Management System - Toppers list
Top 1 % of Certified Candidates

SUSHEEL MAHOBIA 91%

RUNGTA COLLEGE OF ENGINEERING & TECHNOLOGY

AMAN SHARMA 90%

Indian Institute of Technology,Roorkee

UMANGI JAIN 88%

IIT Madras

KIRAN KISHOR AWALE 88%

Tatyasaheb Kore Institute of Engineering and Technology

BHARTI DHOLOOMAL MULCHANDANI 88%

R.C.TECHNICAL INSTITUTE,AHMEDABAD

AMAN PRATAP SINGH 88%

ACROPOLIS INSTITUTE OF TECHNOLOGY & RESEARCH

SOUMADEEP SARKAR 87%

UNIVERSITY OF ENGINEERING & MANAGEMENT (UEM)

PERINA POORNA SAITEJA 87%

R.V.R. & J.C. COLLEGE OF ENGINEERING

GUGGILAM NAGA VENKATASAI LAKSHMI MANEESHA 87%

R.V.R. & J.C. COLLEGE OF ENGINEERING

ABHRANIL CHAKRABARTI 87%

Indian Institute of Technology, Madras

ARYAN SHARMA 87%

ARYA COLLEGE OF ENGINEERING & INFORMATION TECHNOLOGY


Top 2 % of Certified Candidates

ANGEERA MONDAL 86%

UNIVERSITY OF ENGINEERING & MANAGEMENT (UEM)

AISHVARYA S 86%

PSG COLLEGE OF ARTS & SCIENCE

RAGHU ARRABELLY 86%

JASMINE KAUR 86%

Indira Gandhi Delhi Technical University for Women

BHAN SINGH 85%

Dr. B. R. Ambedkar National Institute of Technology, Jalandhar

DEEBA S 85%

MRADUL RATHORE 85%

SHRI GOVINDRAM SEKSARIA INSTITUTE OF TECHNOLOGY AND SCIENCES

AJINKYA AMBADAS GORE 85%

Indian Institute of Technology,Roorkee

RUHINA BASHEER KARANI 85%

DWARKADAS J.SANGHVI COLLEGE OF ENGINEERING


Top 5 % of Certified Candidates

TANISHQ SHARMA 84%

INSTITUTE OF ENGINEERING & MANAGEMENT

NIDHISH DIPENBHAI GANDHI 84%

CHAROTAR UNIVERSITY OF SCIENCE AND TECHNOLOGY

BOGGARAM SUSHMA SRI 84%

R.V.R. & J.C. COLLEGE OF ENGINEERING

PRIYANSHU 84%

GURU NANAK DEV ENGINEERING COLLEGE

AAKASH KHEPAR 84%

Indian Institute of Technology,Roorkee

PRATEEK SONI 84%

Indian Institute of Technology,Madras

JITENDRA MANIKLAL PALIWAL 83%

SINHGAD COLLEGE OF ENGINEERING

VINUTHNA PARIM 83%

UCEK JNTUK

THOTA HARISH REDDY 83%

VARDHAMAN COLLEGE OF ENGINEERING

MUAZZAM FARAAZ 82%

S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY

BHAVINI PANDEY 82%

INSTITUTE OF ENGINEERING & TECHNOLOGY,LUCKNOW

CHINMAY JAIN 82%

GEETANJALI INSTITUTE OF TECHNICAL STUDIES

ANTRA GUPTA 82%

Delhi Technical Campus

TIYASA ROY 81%

TECHNO INDIA UNIVERSITY, WEST BENGAL

KOTA HEMA NAGA SITA RAGINI 81%

R.V.R. & J.C. COLLEGE OF ENGINEERING

JYOTI GAJRANI 81%

GOVERNMENT ENGINEERING COLLEGE, AJMER

VANYA BK 80%

Indian Institute Of Technology, Madras

PONNAM VYSHNAVI 80%

VNR VIGNANA JYOTHI INSTITUTE OF ENGINEERING &TECHNOLOGY

JYOTI KUMARI 80%

MUZAFFARPUR INSTITUTE OF TECHNOLOGY, MUZAFFARPUR

RA KEERTHAN 80%

Indian Institute of Technology, Madras

VIGNESH PRABHU 80%

Mukesh Patel School of Technology, Management and Engineering

JYOTI N NANDIMATH 79%

SMT. KASHIBAI NAVALE COLLEGE OF ENGINEERING

NISHAA KG 79%

THIAGARAJAR COLLEGE

BHUMIKA JINDAL 78%

TECHNO INDIA, SALT LAKE, WEST BENGAL

BIPLAB ROY 78%

GURU NANAK INSTITUTE OF TECHNOLOGY

VEMURI R N VENKATA SAI YASWANTH 78%

Nri Institute of Technology, Guntur

KUMAR AKHIL 78%

S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY

GAGAN SINGH SAINI 78%

Indian Institute of Technology,Roorkee

CHANDANA B S 78%

MALNAD COLLEGE OF ENGINEERING

KRITI KOTHARI 78%

SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN

Enrollment Statistics

Total Enrollment: 26729

Registration Statistics

Total Registration : 5752

Assignment Statistics




It was a great learning experience beyond my expectations.Thank you professors and special  thanks to NPTEL team.


Assignment

Exam score

Final score

Score Distribution Graph - Legend

Assignment Score: Distribution of average scores garnered by students per assignment.
Exam Score : Distribution of the final exam score of students.
Final Score : Distribution of the combined score of assignments and final exam, based on the score logic.