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 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.


Course Instructor

Media Object

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

Prof. Partha Pratim Das

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).

Teaching Assistant(s)

No teaching assistant data available for this course yet
 Course Duration : Jul-Sep 2021

  View Course

 Syllabus

 Enrollment : 20-May-2021 to 02-Aug-2021

 Exam registration : 17-Jun-2021 to 20-Aug-2021

 Exam Date : 26-Sep-2021

Enrolled

20057

Registered

1875

Certificate Eligible

993

Certified Category Count

Gold

6

Silver

96

Elite

369

Successfully completed

522

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
    Note:We have taken best assignment score from both July 2020,Jan 2021 and July 2021 course
Data Base Management System - Toppers list
Top 1 % of Certified Candidates

ANANT VISHWAKARMA 98%

Pillai College of Engineering

NARENDRASINH VIRSANGBHAI LIMBAD 93%

C. U. Shah Polytechnic, Surendranagar

NAMBURI NIKHIL SAI 92%

Rajiv Gandhi University of Knowledge Technologies, IIIT Ongole

ROSHAN BISHI 92%

AMITY UNIVERSITY, CHHATTISGARH

RAHUL REDDY CHADA 90%

CHANDRAMOULI VELICHETI 90%

AMAZON

SUDARSHANA DUTTA 87%

INSTITUTE OF ENGINEERING & MANAGEMENT

SHRUTI JAIN 87%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL

UKANI VEDANT PRAKASHBHAI 86%

GANDHINAGAR INSTITUTE OF TECHNOLOGY

ANNE CHRIS EVERT M 85%

GOVERNMENT COLLEGE OF ENGINEERING

AGNIWESH GUPTA 85%

Government Polytechnic Korba


Top 2 % of Certified Candidates

SUBHODEEP KARMAKAR 84%

ST.THOMAS COLLEGE OF ENGINEERING AND TECHNOLOGY

ADITYA SIVARAM NAIR 84%

PILLAI COLLEGE OF ENGINEERING

BHAVYA PANDYA 84%

LEELABEN DASHRATHBHAI RAMDAS PATEL (LDRP) INSTITUTE OF TECHNOLOGY AND RESEARCH

UDIT DINESH 84%

SIDDHANT SINGH 83%

PANDIT DWARKA PRASAD MISHRA INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, DESIGN AND MANUFACTURING (IIITDM), JABALPUR

GOURISHETTY SATHWIK 83%

VASAVI COLLEGE OF ENGINEERING

MAHESH KUMAWAT 83%

O/o Principal Accountant General (A&E) Rajasthan

SESHADRI MOHANA LAKSHMI SAHITHI 82%

Bapatla Engineering College

YASHVIR SINGH NATHAWAT 82%

SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN


Top 5 % of Certified Candidates

SUKHENDU SHEKHAR MONDAL 81%

COOCHBEHAR GOVERNMENT ENGINEERING COLLEGE

ABHINAV KUMAR 81%

UNIVERSITY COLLEGE OF ENGINEERING AND TECHNOLOGY(UCET), VBU, HAZARIBAG

KRITIKKUMAR AVINASHBHAI JIYAVIYA 81%

SARVAJANIK COLLEGE OF ENGINEERING & TECHNOLOGY

MISHU PUSHPENDRA JAIN 81%

SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN

NILOTPAL CHAKRAVARTY 81%

Gauhati University Institute of Science and Technology

MD TAHAMMUL NOOR 81%

MUZAFFARPUR INSTITUTE OF TECHNOLOGY, MUZAFFARPUR

ALVIN VINOD CHANDRAN 81%

RAM KUMAR 80%

Government Polytechnic , Jagdishpur, Jaunpur

S ISWARYA 80%

COLLEGE OF ENGINEERING ADOOR

DABBIRU CHATURYA 80%

RAGHU ENGINEERING COLLEGE

PRATEEK BHAISORA 80%

Birla Institute of Applied Sciences

VIDYARANI M KATIGAR 80%

GOGTE INSTITUTE OF TECHNOLOGY

MANDHARA B G 80%

SAPTHAGIRI COLLEGE OF ENGINEERING,BANGALORE

AKRATI RUSIA 80%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL

KUSHAL RAWAT 80%

SWAMI KESHVANAND INSTITUTE OF TECHNOLOGY MANAGEMENT & GRAMOTHAN

NEELAM DEVISREE 79%

RAGHU ENGINEERING COLLEGE

SRIDIVYA DANDAMUDI 79%

ADUSUMILLI ASWARDHANARAYANA MURTHY & VALLURUPALLI VENKATA RAMA SESHADRI RAO POLYTECHNIC

PRAYAS CHAUDHARY 79%

MAHARAJA AGRASEN INSTITUTE OF TECHNOLOGY

RANGALA KALPANA 79%

RAGHU ENGINEERING COLLEGE

P NEELAKANTAN 79%

VNR VIGNANA JYOTHI INSTITUTE OF ENGINEERING &TECHNOLOGY

P KEERTHANA 79%

Sreenidhi institute of science and technology

LAKSHMI NARAYANA VELAYUDAM 78%

Sree Vidyanikethan Engineering College

SIMMA BHAVYASREE 78%

ANIL NEERUKONDA INSTITUTE OF TECHNOLOGY & SCIENCES

HARSHIL SHARMA 78%

Government Engineering College Baran

G NEEHARIKA 78%

VIGNAN`S INSTITUTE OF INFORMATION TECHNOLOGY

YARLAGADDA HARIKA 78%

Bapatla Engineering College

VINAY PRATAP SINGH BHADOURIYA 78%

INSTITUTE FOR EXCELLENCE IN HIGHER EDUCATION, BHOPAL

DONIPARTHI VENKATA SAI RAJ KIRAN 77%

University College of Engineering Kakinada(Autonomous), JNTUK

POTNURU RESHMA 77%

ANIL NEERUKONDA INSTITUTE OF TECHNOLOGY & SCIENCES

ANUBHAV 77%

PANDIT DWARKA PRASAD MISHRA INDIAN INSTITUTE OF INFORMATION TECHNOLOGY, DESIGN AND MANUFACTURING (IIITDM), JABALPUR

GANGIREDDY PUJITHA 77%

RAGHU ENGINEERING COLLEGE

PRANAV JAIN 77%

TEERTHANKER MAHAVEER UNIVERSITY

NEHA KATRE 77%

DWARKADAS J.SANGHVI COLLEGE OF ENGINEERING

NAIR SIDHARTH SHANKARANARAYANAN 77%

PILLAI COLLEGE OF ENGINEERING

SHREYA CHAKRABORTY 77%

RCC INSTITUTE OF INFORMATION TECHNOLOGY

JALASHREE DUSHYANTKUMAR TRIVEDI 77%

GOVERNMENT POLYTECHNIC FOR GIRLS, AHMEDABAD

VEERAVALI VIKRANTH 77%

NA

VARDAAN AGRAWAL 77%

NATIONAL INSTITUTE OF TECHNOLOGY, RAIPUR

SAMPRITA ADHIKARI 77%

HALDIA INSTITUTE OF TECHNOLOGY

INDHUJA T 77%

BSNL

DWARAPUREDDY VIJAY KUMAR 77%

RAGHU ENGINEERING COLLEGE

JAYVARDHAN PRAJAPAT 77%

SRI AUROBINDO INSTITUTE OF TECHNOLOGY INDORE

BHATT BHOOMI 77%

charotar university of science and technology

Enrollment Statistics

Total Enrollment: 20057

Registration Statistics

Total Registration : 1875

Assignment Statistics




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.

Course met my expectations and provided a solid foundation in database management systems