Data Base Management System
ABOUT THE COURSE : 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.
Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.
Page Visits
Course layout, books and references.
- Database System Concepts by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, 6th Edition, McGraw-Hill Education, 2010.
- Presentations used in the Course
Instructor bio
Prof. Partha Pratim Das
Prof. Samiran Chattopadhyay
Course certificate.
DOWNLOAD APP
SWAYAM SUPPORT
Please choose the SWAYAM National Coordinator for support. * :
COMMENTS
As per our records you have not submitted this assignment. 1) Storing data and meta-data separately makes RDBMS general-purpose and flexible. True False No, the answer is incorrect. Score: 0 Accepted Answers: 2) "Data Model" is nothing but a data structure where data is stored. True False No, the answer is incorrect.
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. Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.
Week 1: Course Overview. Introduction to RDBMSWeek 2: Structured Query Language (SQL)Week 3: Relational Algebra. Entity-Relationship Model Week 4: Relational Database DesignWeek 5: Application Development. Case Studies. Storage and File StructureWeek 6: Indexing and Hashing.