Database Management Systems

Dr. SOUMYADEV MAITY

Objective of the course

The main objective of this course is to provide students with the background to design, implement, and use database management systems. Database technology though being core subject of all CSE/IT Bachelor programs and assumes special significance due to the highly competitive environment and the explosive use of the internet in Business-to-Client and Business-to-Business applications and the need to store more business data. Recent developments in technologies is proposed to be included.

Outcome of the course

Students can apply knowledge of database techniques and appropriate to the discipline. Students can analyze a problem, develop Relational models and identify and define the information needs and requirements appropriate to its’ business context and solution. Students can use current relational database techniques, skills, and tools necessary for developing information systems. An ability to use and apply current technical concepts and practices in the relational database management, students should develop the ability to explore recent advances like NoSQL and Linked data principles etc. along with the applications towards data warehousing and data mining. The capability to project mode problem solving needs to be incorporated.

Syllabus

Evolution of Data Centric Systems, Need & Purpose of Database Systems. Database User categories and Database Architecture. Data Modeling-ER Diagrams, Case Study discussions for ER Diagrams. Relational Database-concepts of Keys: Super Key, Primary, Candidate and Foreign Keys. Weak Entity Surrogate Keys.

Integrity constraints, Referential constraints and SQL Constructs. Database languages-Relational Algebra, SQL,PL-SQL.Triggers Embedded SQL and Application Programming Interfaces. Relational Database Design issues and Normalization. Functional Dependencies and Various Normal Form Tests.

Query Processing, Query Optimization, Storage and File Structures, Distributed Databases,

Mini Projects

Book References

Text Books

  1. Database System Concepts by Avi Silberschatz, Henry F. Korth, S Sudarshan. E-Book

  2. Fundamentals of Database Systems by Elmasari, Navathe E-Book

Additional References

  1. Introduction to Database Systems by B.C. Desai

  2. Database Management Systems by Jerry Post

  3. Database Management System by Ramakrishnan, Gehrke

  4. Fundamentals of Database Management System by Elmasri Navathe

For PLSQL Programming

  1. SQL, PL/SQL the Programming Language of Oracle by Ivan Bayross