DBMS · Syllabus

Syllabus DBMS C2311C4

Course Syllabus

C2311C4 - Database Management System

ProgramBachelor of Technology (BTech)Semester - 3
Type of CourseCore Course
Prerequisite
Rationale-
Effective From A.Y.2025-26
Teaching Scheme (Contact Hours)Examination Scheme
LectureTutorialPracticalCreditTheory MarksPractical MarksTotal Marks
TTPP
3-2410060-50210

SEE - Semester End Examination, T - Internal Theory, P - Internal Practical

Course ContentT - Teaching Hours | W - Weightage
Sr.TopicsTW
1Database system architecture 5 10 Introduction to DBMS- Historical perspective, File Versus a DBMS, Advantages of DBMS, Describing and storing data in DBMS, Architecture of a DBMS, Data Abstraction, Data Independence, Data Definition Language (DDL), Data Manipulation Language (DML).510
2Data models 6 15 Entity-relationship model, Features of ER Model, network model, relational and object-oriented data models, integrity constraints, and data manipulation operations.615
3Relational query languages 4 10 Relational algebra, Tuple and domain relational calculus, and SQL – Queries, Constraints, Form of SQL Query, UNION, INTERSECT and EXCEPT, Nested Queries, Aggregate Operators, Null values, Complex Integrity constraints in SQL, triggers, and Embedded SQL410
4Relational database design 5 15 Domain and data dependency, Armstrong's axioms, Normal forms-1NF, 2NF, 3NF, and BCNF. Dependency preservation, Lossless design.515
5Query Processing & Query Optimization 6 10 Evaluation of relational algebra expressions, Query equivalence, Join strategies, and Query optimization algorithms.610
6Transaction processing 6 15 Concurrency control, ACID property, Serializability of scheduling, Locking and time stamp based schedulers, Multi-version and optimistic Concurrency Control schemes, Database recovery. Security and Authorization- Access control, Direct access control, and Mandatory access control, Role of DBA, Application development.615
7SQL Concepts1325

Printed on : 09-11-2026 01:42 PM Page 1 of 3

Course Syllabus

C2311C4 - Database Management System

Course ContentT - Teaching Hours | W - Weightage
Sr. TopicsT W

Basics of SQL, DDL, DML, DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, aggregate functions, Built-in functions –numeric, date, string functions, Set operations, sub-queries, correlated sub-queries, join, Exist, Any, All, view and its types., transaction control commands. PL/SQL Concepts: Cursors, Stored Procedures, Stored Functions, Database Triggers Total 45

Suggested Distribution Of Theory Marks Using Bloom's Taxonomy
LevelRemembranceUnderstandingApplicationAnalyzeEvaluateCreate
Weightage20203015150

NOTE : This specification table shall be treated as a general guideline for the students and the teachers. The actual distribution of marks in the question paper may vary slightly from above table.

Course Outcomes
At the end of this course, students will be able to:
CO1Understand functional components of the DBMS.
CO2Design queriesusing Relational Algebra, Relational Calculus and SQL
CO3Apply SQL to find solutions to a broad range of queries
CO4Implementing the SQL Concepts
CO5Develop Data Models
CO PO Mapping
COCO - 1CO - 2CO - 3CO - 4CO - 5
PO - 112011
PO - 201133
PO - 303003
PO - 402000
PO - 510023
PO - 600101
PO - 700001
PO - 800000
PO - 900000
PO - 1002000
PO - 1110023
PO - 1200122

Printed on : 09-11-2026 01:42 PM Page 2 of 3

Course Syllabus

C2311C4 - Database Management System

Reference Books

  1. An introduction to Database Systems By C J Date | Pearson

  2. Database System Concepts By Abraham Silberschatz, Henry F. Korth, S. Sudarshan | McGraw-Hill

  3. SQL- PL/SQL By Ivan bayross

List of Practical
1.To study DDL-create and DML-insert commands.
2.Create the below-given table below and insert the data accordingly. Perform the following queries
3.To perform various data manipulation commands, aggregate functions and sorting concept on all created tables.
4.To study Single-row functions
5.Displaying data from Multiple Tables (join)
6.To apply the concept of Aggregating Data using Group functions.
7.To solve queries using the concept of sub query.
8.Manipulating Data
9.To apply the concept of security and privileges.
10.To study transaction control commands.
11.Write cursors and triggers.
List of Tutorial
1.ONLINE RETAIL APPLICATION DATABASE PROJECT
2.COLLEGE DATABASE
3.HOSPITAL MANAGEMENT SYSTEM
4.LIBRARY MANAGEMENT SYSTEM
5.RESTAURANT MANAGEMENT

Printed on : 09-11-2026 01:42 PM Page 3 of 3