DATABASE MANAGEMENT SYSTEMS
COURSE CODEIT211 CREDITS 3
L T P E O Sessional Marks: 40
2 1 0 1 4 End Exam Marks: 60
End Exam:3 Hours
Prerequisite(s): Relational Algebra, Set Theory, knowledge in any program language
Course Objectives:
Understand basic database concepts, including the structure and operation ofthe
relational data model.
Construct simple and moderately advanced database queries using
StructuredQuery Language(SQL).
Understand and successfully apply logical database design principles, includingE-
R diagrams and databasenormalization.
Understand the concept of a database transaction and related database
facilities,including concurrency control, locking andprotocols.
Course Outcomes:
After completion of this course, the students will be able to:
CO1:ModelapplicationsdatarequirementsusingconceptualmodellingtoolslikeERdiagramsan
d design database schemas based on the conceptual model.
CO-2:Apply relational database theory and describe relational algebra expression, tuple
and domain relation expression for queries.
CO-3:Write SQL commands to create tables and indexes, insert/update/delete data and
query data in a relational DBMS. Optimize the database design by applying functional
dependency and normalization principles
CO-4:. Examine the serializability of non-serial schedules and compare and contrast the
concurrency control protocols.
Mapping of Course Outcomes with POs and PSOs
COs/POs-
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 P010 PO11 PO12 PSO1 PSO2
PSOs
CO1 3 2 1 1 3 2 2 2 2 1
CO2 3 2 1 1 3 2 2 2 2 1
CO3 3 2 1 1 3 2 2 2 2 1
CO4 3 2 1 1 3 2 2 2 2 1
R-20 2nd year Syllabus Page 38
UNIT-I Introduction 10 Periods
Introduction to DBMS: Overview, File system vs. DBMS, Advantages of DBMS, Structure of
DBMS, Levels of Data Abstraction, Database Users and Administrators, E-R model: Entities,
Attributes and Entity sets, Relationship and Relationship sets, Features of ER model,
Conceptual database design with ER model.
Learning Outcome: At the end of this Unit the student will be able to
Understand database concepts and structures and querylanguage
Understand the E Rmodel
Design ER-models to represent simple database applicationscenarios
UNIT-II 12 Periods
Relational model: Integrity constraints over relations and enforcement, Querying relation data,
Logical database design, views, destroying/altering tables and views. Relational Languages:
algebra and calculus.
Learning Outcome: At the end of this Unit the student will be able to
Understand the relationalmodel
Convert the ER-model to relational tables, populate relational database
andformulate SQL queries ondata
Explain the basic concepts of relational model, relational database design,relational
algebra and relationalCalculus
UNIT-III 10 Periods
SQL: Basic SQL, Query, union, interest, except, Nested Queries, Aggregated Operation,
Null values, Embedded SQL, cursors, Database connectivity(ODBC and JDBC), Triggers and
Active database, designing active databases.
Learning Outcome: At the end of this Unit the student will be able to
Execute various advance SQL queries
Write SQL commands to create tables and indexes, insert/update/delete data,
andquery data in a relationalDBMS.
Perform PL/SQL programming using concept of Cursor Management,
ErrorHandling, Packages andTriggers
UNIT-IV 12 Periods
Normalization: Introduction to Schema Refinement - Problems Caused By Redundancy,
Decomposition, Functional Dependency, Closure of a Set of FDs,Normal Forms (First, Second,
Third normal forms, BCNF, Fourth & Fifth normalforms).
Learning Outcome: At the end of this Unit the student will be able
Understand Functional Dependency and FunctionalDecomposition.
Apply various Normalization techniques.
Improve the database design bynormalization.
R-20 2nd year Syllabus Page 39
UNIT-V 10 Periods
Transaction management: Transaction concept, transactions and schedules, concurrent
execution of transactions Concurrency control: Lock management, specialized locking
techniques, concurrency control without locking.
Learning Outcome: At the end of this Unit the student will be able to
understand transactions and their properties(ACID)
understand the anomalies that occur withoutACID
understand the locking protocols used to ensureIsolation
Text Books
1. Raghu Ramakrishnanand Johannes Gehrke, “Database Management Systems”, 3 rdEdition,
McGraw-Hill,2003.
References Books
1. Silberschatz, Korth and Sudharshan, “Data Base System Concepts”,5 Edition, McGraw
Hill,2006.
2. Elmasri,Navathe,“FundamentalsofDatabaseSystems”,5 t h Edition,PearsonEducation, 2007.
R-20 2nd year Syllabus Page 40
