B.Tech.
Computer Science and Business Systems R-2023
L T P C
23CBO02 INTRODUCTION TO DBMS
3 0 0 3
Nature of Course Open Elective(OE)
Pre requisites 20CB404
Course Objectives
The course is intended to
1.To expose the students to the fundamentals of Database Management Systems.
2.To make the students understand the relational model.
3.To familiarize the students with ER diagrams.
4.To expose the students to SQL.
5.To make the students to understand the fundamentals of Transaction Processing
and Query Processing.
6. To familiarize the students with the different types of databases.
7. To make the students understand the Security Issues in Databases.
Course Outcomes
On successful completion of the course the students will be able to
CO. No Course Outcome Bloom's Level
CO1 Expose the students to the fundamentals of Database Understand
Management Systems.
CO2 Use the Relational model, ER diagrams. Understand
Apply concurrency control and recovery mechanisms for practical
CO3 Apply
problems.
CO4 Design the Query Processor and Transaction Processor. Apply
CO5 Apply security concepts to databases. Apply
CO6
Course Contents
10
MODULE – I DATABASE FUNDAMENTALS
File Systems Organization - Sequential, Pointer, Indexed, Direct - Purpose of Database
System Database System Terminologies-Database characteristics- Data models – Types of
data models – Components of DBMS- Relational Algebra. Extended ER Normalization –
Functional Dependencies, Anomaly- 1NF to 5NF- Domain Key Normal .
MODULE – II SQL & QUERY OPTIMIZATION 8
Passed in Board of Studies Approved in Academic Council
B.Tech.Computer Science and Business Systems R-2023
SQL Standards - Data types - Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static
Vs Dynamic SQL - QUERY OPTIMIZATION: Query Processing and Optimization - Heuristics
and
Cost Estimates in Query Optimization.
MODULE – III TRANSACTION PROCESSING AND CONCURRENCY CONTROL 8
Introduction-Properties of Transaction- Serializability- Concurrency Control – Locking
Mechanisms Two Phase Commit Protocol-Dead lock.
MODULE – IV TRENDS IN DATABASE TECHNOLOGY 10
Overview of Physical Storage Media – Magnetic Disks – RAID – Tertiary storage – File
Organization – Organization of Records in Files – Indexing and Hashing –Ordered Indices –
B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing
MODULE – V ADVANCED TOPICS 9
DATABASE SECURITY: Data Classification-Threats and risks – Database access Control –
Types of Privileges –Cryptography- Statistical Databases.- Distributed Databases-
Architecture-Transaction Processing-Data Warehousing and Mining-Classification- Object
Oriented Databases-XML Databases.
Total: 45 Periods
Text Books
1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”,
Sixth Edition, Tata McGraw Hill, 2011.
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Sixth
Edition, Pearson Education, 2011
Reference Books
1. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth
Edition, Pearson Education, 2006.
2. Raghu Ramakrishnan, ―Database Management Systemsǁ, Fourth Edition, McGraw-Hill
College Publications, 2015.
3. G.K.Gupta,"Database Management Systems”, Tata McGraw Hill, 2011.
Additional References:
1. https://nptel.ac.in/courses/106/105/106105175/
2. https://onlinecourses.nptel.ac.in/noc21_cs04/preview
Passed in Board of Studies Approved in Academic Council
B.Tech.Computer Science and Business Systems R-2023
Mapping of Course Outcomes (CO’s) with Programme Outcomes (PO’s) and
Programme Specific Outcomes (PSO’s)
PO’s PSO’s
COs
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
CO1 2 3 3 2 2 3
CO2 2 3 3 2 2 3
CO3 2 3 3 2 2 3
CO4 2 3 3 2 2 3
CO5 2 3 3 3 2 3
3- High 2- Medium 1- Low
Formative Assessment
Total
Blooms Taxonomy Assessment Component Marks
marks
Remember Quiz 5
Understand
Tutorial class/Assignment 5 15
Apply
Attendance 5
Summative Assessment
Final
Internal Assessment Examinations(IAE)
Bloom’s Category Examinations(FE)
IAE–I(5) IAE–II(10) IAE–III(10) 60
Remember
Understand 10 10 10 20
Apply 30 30 30 60
Analyze 10 10 10 20
Evaluate
Create
Passed in Board of Studies Approved in Academic Council
