Course Name: Database 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

Partha Pratim Das

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.


Teaching Assistant(s)

Gurunath Reddy M

PhD, IIT Kharagpur

Himadri Bhusan Girija Sankar Bhuyan

PhD Scholar

SRIJONI MAJUMDAR

RESEARCH SCHOLAR

 Course Duration : Feb-Mar 2018

  View Course

 Syllabus

 Enrollment : 20-Nov-2017 to 05-Feb-2018

 Exam registration : 08-Jan-2018 to 07-Mar-2018

 Exam Date : 28-Apr-2018, 29-Apr-2018

Enrolled

29398

Registered

3195

Certificate Eligible

2419

Certified Category Count

Gold

32

Elite

1300

Successfully completed

1087

Participation

456

Success

Elite

Gold





Legend

>=90 - Elite + Gold
60-89 - Elite
40-59 - Successfully Completed
<40 - No Certificate

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
Database Management System - Toppers list
Top 1 % of Certified Candidates

THAVASI S 97%

MEPCO SCHLENK ENGINEERING COLLEGE

VISHAL SHARMA 95%

ASANSOL ENGINEERING COLLEGE

NAVEEN MALHOTRA 95%

TEOCO

J JEBA EMILYN 95%

SONA COLLEGE OF TECHNOLOGY

SAFA SALMAN HAMDARE 94%

ST.FRANCIS INSTITUTE OF TECHNOLGY

V PADMA 94%

G. NARAYANAMMA INSTITUTE OF TECHNOLOGY AND SCIENCE (FOR WOMEN)

POOJA RANI 94%

HIMALAYAN INSTITUTE OF ENGINEERING AND TECHNOLOGY

SUDESHNA KUNDU MONDAL 94%

UNIVERSITY OF ENGINEERING & MANAGEMENT (UEM)

T.SWAPNA 93%

G. NARAYANAMMA INSTITUTE OF TECHNOLOGY AND SCIENCE (FOR WOMEN)

RISHABH KUMAR SINHA 93%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY & SCIENCE

PATIL PRAJAKTA LAXMAN 92%

GOVERNMENT COLLEGE OF ENGINEERING,KARAD

TATA PRIYANKA 92%

GUDLAVALLERU ENGINEERING COLLEGE

VINEETA SUTHAR 92%

M B M ENGINEERING COLLEGE

MAYANK GUPTA 92%

PRANVEER SINGH INSTITUTE OF TECHNOLOGY

SHREYA AGARWAL 92%

TECHNO INDIA, SALT LAKE, WEST BENGAL

SUNITA SAHU 91%

V. E. S. INSTITUTE OF TECHNOLOGY,CHEMBUR

UNMESH VIJAY KADAM 91%

S. K. SOMAIYA DEGREE COLLEGE OF ARTS, SCIENCE AND COMMERCE

DEBDAN BHANDARI 91%

INSTITUTE OF ENGINEERING & MANAGEMENT

SUVASISH DUTTA 91%

GOVERNMENT COLLEGE OF ENGINEERING AND LEATHER TECHNOLOGY

SHIVAM SHUKLA 91%

MADAN MOHAN MALAVIYA UNIVERSITY OF TECHNOLOGY

SOUMYA SANKAR MODAK 91%

TECHNO INDIA, SALT LAKE, WEST BENGAL

MADAKA MADHURI LATHA 91%

G. NARAYANAMMA INSTITUTE OF TECHNOLOGY AND SCIENCE (FOR WOMEN)

SUNITA MILIND DOL 91%

WALCHAND INSTITUTE OF TECHNOLOGY

AMRITA CHATTERJEE 91%

FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT


Top 2 % of Certified Candidates

SUMIT NAG 90%

TECHNO INDIA COLLEGE OF TECHNOLOGY

GOUTAM BOSE 90%

INSTITUTE OF ENGINEERING & MANAGEMENT

PRAKHAR RAJ 90%

TECHNO INDIA, SALT LAKE, WEST BENGAL

AYAN SAHA 90%

ST.THOMAS COLLEGE OF ENGINEERING & TECHNOLOGY

SHAURYA AGNIHOTRI 90%

M B M ENGINEERING COLLEGE

SAYAN BACHHAR 90%

INSTITUTE OF ENGINEERING & MANAGEMENT

VANSIKA GUPTA 90%

TECHNO INDIA, SALT LAKE, WEST BENGAL

UDIT PRASAD 90%

INSTITUTE OF ENGINEERING & MANAGEMENT

UDAY BHAVE 89%

SHAH & ANCHOR KUTCHHI ENGINEERING COLLEGE

EARRA AKHIL 89%

VASAVI COLLEGE OF ENGINEERING

FARHANUL HAQUE 89%

TECHNO INDIA, SALT LAKE, WEST BENGAL

SUBODH KUMAR RAI 89%

MADAN MOHAN MALAVIYA UNIVERSITY OF TECHNOLOGY

PRITAM CHAKRABORTY 89%

TECHNO INDIA COLLEGE OF TECHNOLOGY

ANIRBAN DEBNATH 89%

TECHNO INDIA COLLEGE OF TECHNOLOGY

V. KARPAGAM 89%

SRI RAMAKRISHNA ENGINEERING COLLEGE

SHIVANI DUJARI 89%

TECHNO INDIA, SALT LAKE, WEST BENGAL

SASWATA MAJUMDAR 89%

B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY

MADDULA PAVAN KUMAR 89%

PRASAD V POTLURI SIDDHARTHA INSTITUTE OF TECHNOLOGY

SURINDER KAUR 89%

CHANDIGARH UNIVERSITY

D N V S L S INDIRA 88%

GUDLAVALLERU ENGINEERING COLLEGE

GNANENDRA KOTIKAM 88%

NARASARAOPETA ENGINEERING COLLEGE

SUGAM AGARWAL 88%

TECHNO INDIA COLLEGE OF TECHNOLOGY

ADITYA SANTRA 88%

B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY

SOURABH MAKHIJA 88%

SHRI SHANKARACHARYA INSTITUTE OF PROFESSIONAL MANAGEMENT & TECHNOLOGY

NINAAD SHUKLA 88%

SHRI SHANKARACHARYA INSTITUTE OF PROFESSIONAL MANAGEMENT & TECHNOLOGY

SRI NIWAS PALIWAL 88%

M B M ENGINEERING COLLEGE

SANDIP MANDAL 88%

NETAJI SUBHASH ENGINEERING COLLEGE

PRAGYA AGARWAL 88%

AISSMS COLLEGE OF ENGINEERING, PUNE

KISHAN SANTLANI 88%

ACROPOLIS INSTITUTE OF TECHNOLOGY & RESEARCH

VELAGAPUDI KEERTHANA DEVI 88%

VELAGAPUDI RAMAKRISHNA SIDDHARTHA ENGINEERING COLLEGE

SHERIN JABBAR 88%

MEA ENGINEERING COLLEGE


Top 5 % of Certified Candidates

RAJAT GUPTA 87%

NATIONAL INSTITUTE OF TECHNOLOGY PATNA

MANDAKRANTA BOSE 87%

NETAJI SUBHASH ENGINEERING COLLEGE

AELGANI VIVEKANAND 87%

CMR COLLEGE OF ENGINEEING & TECHNOLOGY

SHRAVANI ROY 87%

NETAJI SUBHASH ENGINEERING COLLEGE

CHANDRAMITA BHATTACHARYA 87%

INSTITUTE OF ENGINEERING & MANAGEMENT

MAANSI VYAS 87%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL

SRAJAN DIXIT 87%

KIET GROUP OF INSTITUTIONS

TRISAGNI BANERJEE 87%

INSTITUTE OF ENGINEERING & MANAGEMENT

SHASHANK SATISH D 87%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL

VIJAY KUMAR TRIVEDI 87%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY, BHOPAL

SUDHIRVARMA SAGIRAJU 87%

RAGHU ENGINEERING COLLEGE

RAM PRABHA V 87%

VV COLLEGE OF ENGINEERING

GAGAN PUNJABI 87%

INSTITUTE OF ENGINEERING AND SCIENCE, IPS ACADEMY

RANJIT SINGH 86%

ARJAN DASS COLLEGE

SIDDHARTH YASHASWEE 86%

INSTITUTE OF ENGINEERING & MANAGEMENT

ROHIT MONDAL 86%

TECHNO INDIA COLLEGE OF TECHNOLOGY

PRIYANKA KUMARI 86%

VELOCIS SYSTEM PVT LTD

ANIKA AGIWAL 86%

B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY

DEEPTI GUPTA 86%

INTERNATIONAL INSTITUTE FOR SPECIAL EDUCATION

CHANDRASEKHARA REDDY T 86%

ANURAG GROUPS OF INSTITUTIONS

SAVITHA RAMESH 86%

AURORAS SCIENTIFIC, TECHNOLOGICAL AND RESEARCH ACADEMY

RAJRUPA CHATTARAJ 86%

TECHNO INDIA COLLEGE OF TECHNOLOGY

ARIHANT KUMAR SEKHANI 86%

MALLABHUM INSTITUTE OF TECHNOLOGY

PRIYA 86%

TECHNO INDIA, SALT LAKE, WEST BENGAL

SATISH CHHOKAR 86%

RAJ KUMAR GOEL INSTITUTE OF TECHNOLOGY

PIYUSH KUMAR 86%

INSTITUTE OF ENGINEERING & MANAGEMENT

SAGAR KUMAR ROY 86%

TECHNO INDIA, SALT LAKE, WEST BENGAL

ANIMESH SADHU 86%

ASANSOL ENGINEERING COLLEGE

SHUBHAM KUMAR SINGH 86%

TECHNO INDIA, SALT LAKE, WEST BENGAL

TWINKLE BHASIN 85%

WOMEN INSTITUTE OF TECHNONLOGY

ADITYA AGARWAL 85%

GURUKULA KANGRI VISHWAVIDYALAYA,HARIDWAR

DEBMALYA PAN 85%

TECHNO INDIA, SALT LAKE, WEST BENGAL

MUKUND FATEHPURIA 85%

B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY

INDRAJIT SALUI 85%

TECHNO INDIA, SALT LAKE, WEST BENGAL

OM PRAKASH SAMANTRAY 85%

NARASARAOPETA ENGINEERING COLLEGE

ABHISHEK GARG 85%

TECHNO INDIA, SALT LAKE, WEST BENGAL

GOVIND KUMAR TAILOR 85%

JAIPUR RUGS COMPANY PVT LTD

BISHAL ROY 85%

FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT

SUSMIT GHOSH 85%

TECHNO INDIA, SALT LAKE, WEST BENGAL

GUNDE PRATHAMESH SANJAY 85%

SANJAY GHODAWAT GROUP OF INSTITUTIONS

AISHANI BASU 85%

NETAJI SUBHASH ENGINEERING COLLEGE

SHASHIDHAR SINHA 85%

INSTITUTE OF ENGINEERING & MANAGEMENT

APPARAO GEDDAPU 85%

S.R.K.INSTITUTE OF TEHNOLOGY

DEBARGHA DAS 85%

INSTITUTE OF ENGINEERING & MANAGEMENT

RAHUL KUMAR NANDI 85%

TECHNO INDIA, SALT LAKE, WEST BENGAL

PRADNYA GIRISH VALSANGKAR 85%

WALCHAND INSTITUTE OF TECHNOLOGY

PRAVIN RAJARAM KUMBHAR 85%

MET BHUJBAL KNOWLEDGE CITY INSTITUTE OF ENGINEERING

SHRUTI SINGHANIA 85%

TECHNO INDIA COLLEGE OF TECHNOLOGY

MEENAL BABU CHIPPA 84%

WALCHAND INSTITUTE OF TECHNOLOGY

KASTURI SAHA 84%

ST.THOMAS COLLEGE OF ENGINEERING & TECHNOLOGY

RUSHIKESH ANANT SHINDE 84%

TERNA ENGINEERING COLLEGE

SHUKLA SUDHANSHU SATISH 84%

TERNA ENGINEERING COLLEGE

ANIMESH SHARDA SINGH 84%

K J SOMAIYA INSTITUTE OF MANAGEMENT STUDIES AND RESEARCH

AKASH KUMAR 84%

THE NATIONAL INSTITUE OF ENGINEERING

YUGCHHAYA NITIN GALPHAT 84%

VIVEKANAND EDUCATION SOCIETYS INSTITUTE OF TECHNOLOGY

VISHNU PRAKASH GUPTA 84%

INSTITUTE OF ENGINEERING & MANAGEMENT

SALONI AGRAWAL 84%

LAKSHMI NARAIN COLLEGE OF TECHNOLOGY & SCIENCE

DHRUV KEDIA 84%

TECHNO INDIA, SALT LAKE, WEST BENGAL

SRISHTI JAISWAL 84%

B.P. PODDAR INSTITUTE OF MANAGEMENT AND TECHNOLOGY

MOHAMMED UZAIR MOHIUDDIN 84%

VARDHAMAN COLLEGE OF ENGINEERING

DEEPAK SINGH 84%

TECHNO INDIA, SALT LAKE, WEST BENGAL

AYUSH BHATTACHARJEE 84%

ST.THOMAS COLLEGE OF ENGINEERING & TECHNOLOGY

SANDIVYA SAXENA 84%

SRM INSTITUTE OF SCIENCE & TECHNOLOGY, MODINAGAR

ABHISHEK AGRAWAL 84%

HARCOURT BUTLER TECHNOLOGICAL INSTITUTE

ANJALI SRIVASTAVA 84%

PRANVEER SINGH INSTITUTE OF TECHNOLOGY

ROCKY SINGH 84%

INSTITUTE OF ENGINEERING & MANAGEMENT

K DEEPA 84%

SRI RAMAKRISHNA ENGINEERING COLLEGE

JADHAV RAKSHANDA SANJAY 84%

WALCHAND INSTITUTE OF TECHNOLOGY

GAYATHRI RU VA 84%

VV COLLEGE OF ENGINEERING

PATIT PAWAN BARIK 84%

TECHNO INDIA COLLEGE OF TECHNOLOGY

H.SUSMITHA 84%

KUPPAM ENGINEERING COLLEGE

MANJULA HIREMATH 84%

WALCHAND INSTITUTE OF TECHNOLOGY

Enrollment Statistics

Total Enrollment: 29398

Registration Statistics

Total Registration : 3195

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.