SYLLABUS

 

 Introduction to Database Management Systems (DBMS)

Databases are the foundation of modern applications, helping store, manage, and retrieve data efficiently. In this blog, I will cover the essential concepts of Database Management Systems (DBMS) in a simple and structured manner.

The topics include relational databases, data models, relational algebra, SQL fundamentals, advanced SQL, PL/SQL, and triggers. We will also explore database design concepts such as ER models, normalization (1NF to 5NF), and functional dependencies. Further, we will study transactions, ACID properties, concurrency control, and recovery mechanisms. Implementation techniques like indexing, hashing, RAID, and query optimization will also be discussed. Finally, we will introduce NoSQL databases and MongoDB.

This blog aims to provide both theoretical clarity and practical insight into how database systems work. 


Syllabus

Course Code-Title

21CS206 – DATABASE MANAGEMENT SYSTEMS

Course Component

Professional Core

Contact Hours

Lecture

Tutorial

Practical

Total Hours

Credit

3

0

0

45

3

Course Assessment methods 

Continuous

Semester-end assessment

Internal Assessment Tests and Assignments

End semester exam, Student Course exit survey

Prerequisite Courses

  • Working Knowledge on Computers

  • Data structures

Course Objective

  • To explain the fundamentals of data models and to represent a database system.

  • To describe the internal storage structures using different file and indexing techniques which will help in physical DB design.

  • To illustrate the fundamental concepts of transaction processing- concurrency control techniques and recovery procedures.

  • To demonstrate Storage and Query processing Techniques.

  • To develop a solutions to the real time problems using NoSQL.

TOPICS TO BE COVERED


UNIT I - RELATIONAL DATABASES                                                                                                      

Purpose of Database System – Views of data – Data Models – Database System Architecture – Introduction to relational databases – Relational Model – Keys – Relational Algebra – SQL fundamentals – Advanced SQL features – PL/SQL, Triggers, Embedded SQL– Dynamic SQL.


UNIT II – DATABASE DESIGN                                                                                                                

Entity-Relationship model – E-R Diagrams – Enhanced-ER Model – ER-to-Relational Mapping – Functional Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form


UNIT III - TRANSACTIONS                                                                                                                     

Transaction Concepts – ACID Properties – Schedules – Serializability – Concurrency Control – Need for Concurrency – Locking Protocols – Two Phase Locking – Deadlock – Transaction Recovery - Save Points – Isolation Levels – SQL Facilities for Concurrency and Recovery.


UNIT IV– IMPLEMENTATION TECHNIQUES                                                                                   

RAID – File Organization – Organization of Records in Files – Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing – Query Processing Overview – Query optimization using Heuristics and Cost Estimation.


UNIT V– NOSQL DATABASE                                                                                                                

Introduction to NoSQL Database system – Classification of NoSQL Databases : Graph databases – key – value stores – document stores – NoSQL vs SQL – Limitations of NoSQL – Mongo DB document model.


TOTAL : 45

Course Outcomes

Upon completion of the course the student will be able to

  1. Build and manipulate relational database using Structured Query Language and relational languages

  2. Prepare database using ER-Diagram for real time Applications.

  3. Make use of Normalization techniques to reduce cost due to redundancy constraints

  4. Illustrate different types of scheduling and recovery techniques for concurrent transactions

  5. Construct data structures like indexes and hash tables for the fast retrieval of data and validate the query evaluation plan

TEXT BOOKS:

  1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan,,” Database System Concepts”, 6th Edition,

Tata McGraw Hill, 2011.

  1. RamezElmasri, Shamkant B. Navathe,” Fundamentals of Database Systems”, 1st Edition, Pearson

Education, 2011

  1. Raghu Ramakrishnan, Database Management Systems‖, 4th Edition, McGraw-Hill College

Publications, 2015


REFERENCES:

  1. C.J.Date, A.Kannan, S.Swamynathan,,” An Introduction to Database Systems”,8th Edition, Pearson Education, 2006.

  2. Elvis C Foster, “Database Systems-A pragmatic Approach”2nd Edition CRC Press,2016

  3. G.K.Gupta,"Database Management Systems, 1st Edition, Tata McGraw Hill, 2011.




Comments

Post a Comment

Popular posts from this blog

Views in Relational Databases

   Views in Relational Databases A View is a virtual table in a relational database. It is created using a SQL query and displays data from one or more tables. Unlike a regular table, a view does not store data physically; instead, it stores the query definition and retrieves data dynamically when accessed. Views are used to simplify complex queries, improve security, and present specific data to users without exposing the entire table. 🔹 Why Use Views? Security – Restrict access to specific columns or rows. Simplification – Hide complex joins and calculations. Data Abstraction – Show only required information to users. Consistency – Provide a standard way to access data. 🔹 Types of Views Simple View – Based on a single table without complex functions. Complex View – Based on multiple tables with joins, grouping, or functions. 🔹 Example (SQL Syntax) CREATE VIEW student_view AS SELECT name, department FROM student; click here to view
Read more

SQL

Introduction to SQL SQL (Structured Query Language) is a standard programming language used to manage and manipulate relational databases. It is used to create databases, insert data, retrieve data, update records, and delete data. SQL works with relational databases that store data in tables (rows and columns). It is easy to learn and widely used in industries such as banking, education, healthcare, and e-commerce.  Types of SQL Commands DDL (Data Definition Language) – CREATE, ALTER, DROP DML (Data Manipulation Language) – INSERT, UPDATE, DELETE DQL (Data Query Language) – SELECT DCL (Data Control Language) – GRANT, REVOKE TCL (Transaction Control Language) – COMMIT, ROLLBACK, SAVEPOINT SQL is essential for interacting with relational database systems efficiently.  Advanced SQL Features Advanced SQL features provide powerful capabilities for handling complex queries and database operations.  1️⃣ Joins Used to combine data from multiple tables (INNE...
Read more

EMBEDDED SQL

Embedded SQL Embedded SQL is a method of writing SQL statements inside a host programming language such as C, C++, or Java. It allows application programs to interact directly with a relational database. In Embedded SQL, SQL commands are written within the source code of the program and are processed by a special precompiler before compilation. The precompiler converts SQL statements into function calls that the programming language can understand. 🔹 Why Use Embedded SQL? To connect application programs with databases To retrieve and manipulate data directly from code To build database-driven applications 🔹 Key Features SQL statements are embedded inside programming code Uses host variables to pass values between the program and database Supports SELECT, INSERT, UPDATE, DELETE, and transaction control commands 🔹 Example (Conceptual Syntax in C) EXEC SQL SELECT name INTO : student_name FROM student WHERE roll_no = 1 ; Here, :student_name is a host varia...
Read more