Course Curriculum Pack
This course is aimed at imparting candidates for the Database Management System aims at building the
following key competencies amongst the Students
Program Name Degree Bachelor of Technology in Computer Science & Information technology
Qualification Pack QPXXXXX
Course Name Database CS5003 Weekly Workload in Hours
Management Theory Pract. Tut
System 04 02 01
Version No 1.0 Version Update date 07//2020
Pre-requisite Pl-Sql / Oracle
Fundamentals of database system
basic data structures and their uses (lists, arrays)
the concepts of object-oriented programming (classes,
inheritance)
modular software design and method linkage
the design, implementation and testing of medium-sized problem
solutions
contexts in which databases are used
basic familiarity with a Unix environment
Course Outcome After completion of this course student will be able to :
1. The students will be able to describe various architectural issues, data
models, concept of data independence & database Administration etc.
2. The students will be able to demonstraterelation among domain, tupples&
attributes, various keys ,schemas , integrity constraints etc , DDL, DML ,
queries , joins etc.
3. The students will be able to describe Normalization , functional
dependencies , various methods of optimization , dangling tupples ,
lossless joins etc .
4. The students will be able to demonstrate transaction system serializibility
testing , transaction failure recovery, log based recovery check points ,
schedules , deadlock handling , distributed database , OODBMS & DBMS
5. The students will be able to demonstrate data dictionary, distributed
database, memory concepts, server, concept of tables , data extraction
from multiple tables, RDBMS through Oracle , Oracle conception of
exception handling, SQL /PlSQL ,data security.
The Course Encompasses
Sr. No Module/Units Key Learning Outcomes Instructional Objectives
1 Introduction to Database The l Students should be able to:
& Architecture LO1 : Describe database , various
architectural issues & models
Theory Duration (hh.mm): LO2 : countthe difference between
(10.00) Database & Traditional file accessing
approach , advantages .
Practical Duration LO3 :describe various Data models
(hh.mm): (4:00) & relationship among various
entities in that, various Schemas &
instances .
LO4: describe the concept of data
Independence.
LO5: discuss Database Languages &
Interfaces, Structures of Database,
Functions of DBA.
LO6 : describe E-R model, Entities,
attributes, generalization,
aggregation & specialization,
Comparison among various models.
2 Relational Data Models The Students should be able to:
Lo1 : identify domains ,
Theory Duration (hh.mm): tuples ,attributes relations
9:00 LO2 : describe relations ,
Practical Duration Keys ,Relational Database Schemas ,
(hh.mm): (5:00) Integrity Constraints , Referential
integrity
LO3 : demonstrate Relational Query
Languages SQL , DDL, DML, Complex
Queries
LO4 : identify Joins ,
Indexing ,Relational Algebra & their
operations like select, project, join ,
outer Union, division,
LO5 : describe relational Calculus as
tuple& domain oriented relational
calculas& their operations
3 Database Design The Students should be able to:
concepts LO1 : demonstrate Normalization ,
Theory Duration (hh.mm): Normal forms , Functional
9:00 dependency ,decomposition & lossless
Practical Duration joins.
(hh.mm): 8:00 LO2 : describe null values & dangling
tupples , Query Optimisation ,Steps of
optimization , various methods to
implement select , project , & join
operation. Optimization methods :-
Heuristic based & cost Estimation based.
4 Transaction Processing The Students should be able to:
Concepts LO1 : describe about Transaction system
Serializibility testing & schedules,
recovery from transaction failure , log
Theory Duration (hh.mm): based recovery , Checkpoints, deadlock
7:00 handling.
Practical Duration LO2 : demonstrate Distributed
(hh.mm): 5:00 Database, concurrency control
techniques , comparison among
OODBMS & DBMS
5 Relational Database The Students should be able to:
Management Sys. LO1: describe about RDBMS through
Oracle , SQL/MYSQL,
Theory Duration (hh.mm): LO2 : Identify Data Dictionary , Server,
7:00 Distributed Database, Memory concepts
, concept of tables , data extraction
Practical Duration from multiple tables
(hh.mm): 6:00 LO3 : demonstrate Introduction to ANSI
SQL , database Security , Oracle
Exception Handling process.
Module/Unit wise Syllabus Details
Sr. No Module/Units Detailed Topic wise Syllabus References
1 Introduction to Database
system & Architecture What database is ?,What are the various
architectural issues & models
Theory Duration (hh.mm): Difference between Database & Traditional file
6:00 accessing approach , advantages .
Various Data models & relationship among
various entities in that, various Schemas
&instances .
The concept of data Independence.
Database Languages & Interfaces, Structures of
Database , Functions of DBA.
E-R model , Entities, attributes , generalization ,
aggregation & specialization, Comparison
among various models.
2 Relational Data Models Domains , tupples ,attributes relations
Relations , Keys ,Relational Database Schemas ,
Theory Duration (hh.mm): Integrity Constraints , Referential integrity
9:00 Relational Query Languages SQL , DDL, DML,
Complex Queries
Various Joins , Indexing ,Relational Algebra & their
operations like select, project, join , outer Union,
division,
Relational Calculas as tupple& domain oriented
relational calculas& their operations
3 Database Design
concepts Normalization , Normal forms , Functional
Theory Duration (hh.mm): dependency ,decomposition & lossless joins.
9:00 Null values & dangling tupples , Query Optimisation
,Steps of optimization , various methods to
implement select , project , & join operation.
Optimization methods :- Heuristic based & cost
Estimation based.
4 Transaction Processing
Concepts Transaction system Serializibility testing &
schedules, recovery from transaction failure , log
based recovery , Checkpoints, deadlock handling.
Theory Duration (hh.mm): Distributed Database, concurrency control
7:00 techniques , comparison among OODBMS & DBMS
5 Relational Database
Management Sys. RDBMS through Oracle , SQL/MYSQL,
Data Dictionary , Server, Distributed Database,
Theory Duration (hh.mm): Memory concepts , concept of tables , data
7:00 extraction from multiple tables
Introduction to ANSI SQL , database Security ,
Oracle Exception Handling process.
Module wise List of Activities/ Experiments/Practical/Tutorials
Sr. No Module/Units Description Equipment
required
Code
1 Introduction to Database Installation of PL\SQL, Oracle S1
system & Architecture S2
Creation of a table .
H1
Theory Duration (hh.mm): Concept of tupples , entity, attributes
6:00
2 Relational Data Models Delete duplicate row from the table. S1
Display the alternate row from table. S2
Theory Duration (hh.mm): Delete alternate row from table. H1
9:00
3 Database Design Update multiple rows in using single update S1
concepts statement. S2
Theory Duration (hh.mm): Find the third highest paid and third lowest H1
9:00 paid salary.
Display the 3rd, 4th, 9th rows from table.
4 Transaction Processing Display the ename, which is start with j, k, l S1
Concepts or m. S2
Show all employees who were hired the H1
first half of the month.
Theory Duration (hh.mm): Display the three record in the first row and
7:00 two records in the second row and one
record in thethird row in a single sql
statements.
Write a sql statements for rollback commit
and save points.
Write a pl/sql for select, insert, update and
delete statements.
5 Relational Database Write a pl/sql block to delete a record. If S1
Management Sys. delete operation is successful return 1 else S2
return 0. H1
Theory Duration (hh.mm): Display name, hire date of all employees
7:00 using cursors.
Display details of first 5 highly paid
employees using cursors.
Write a database trigger which fires if you
try to insert, update, or delete after 7’o’
clock.
Text Books/Reference Books
Sr. No Title of the Book Author Edition / volume Text(T)
Reference
(R)
1. Fundamental of Database System Korth, Silbertz, McGrawHill T1
Sudarshan 7th Edition
2 An Introduction To Database Date C J, Pearson R1
System 9th Edition
3 Data Base System:Design Rob CengageLearnin R2
Implementation & Management ig
4 Introduction to Database AtulKahate Pearson R3
Management System Educations
List of Unique Equipment required
Sr. No Module/Units Description of Equipment Equipment
Code
1 Introduction to Database SQL/PL SQL S1
system & Architecture Oracle S2
Theory Duration (hh.mm): fully equipped PC system H1
6:00
2 Relational Data Models SQL/PL SQL S1
Theory Duration (hh.mm): Oracle S2
9:00 fully equipped PC system H1
3 Database Design SQL/PL SQL S1
concepts Oracle S2
Theory Duration (hh.mm): fully equipped PC system H1
9:00
4 Transaction Processing SQL/PL SQL S1
Concepts Oracle S2
Theory Duration (hh.mm): fully equipped PC system H1
7:00
5 Relational Database SQL/PL SQL S1
Management Sys. Oracle S2
Theory Duration (hh.mm): fully equipped PC system H1
7:00
Assessment Matrix
Application/Field Trip)
Research assignments
Learning Outcome ID
Practical Experiment
Learni
Case Study analysis
Group Discussions
Other (Real World
Prototype making
Lab Experiment
ng
Presentation
Written Test
Role Play
Seminar
Sr. Outco
Tutorial
Project
N Module/Unit me
o
Introduction to LO1
1 Database system &
√ √ √ √ √ √
LO2
Architecture √ √
LO3
√ √ √ √
LO4
√ √ √
LO5
√ √ √ √
LO6
√ √
Relational Data LO1
2 Models
√ √ √ √ √
LO2
√ √ √
LO3
√ √ √ √
LO4
√ √ √
LO5
√ √ √
Database Design LO1
3 concepts
√ √ √ √ √
LO2
√ √ √ √ √ √ √
LO3
√ √ √ √ √
Transaction LO1
4 Processing
√ √ √ √ √
LO2
Concepts √ √ √ √ √ √ √
Relational LO1
5 Database
√ √ √ √ √ √
LO2
Management Sys √ √ √ √
LO3
√ √ √ √
LO4
√ √ √ √
Evaluation System
Assessment Requirements as per Course Matrix Percentage weightage Allotted marks
(Select which is applicable)
Attendance 5 10
Mid Term Examination 18 36
Laboratory Experiments 10 20
Tutorials 1.5 3
Project 6 12
Seminar 1 2
Presentation 1.5 3
Research Assignments 1.5 3
Case Study Analysis 1.5 3
Group discussion 1.5 3
Role Play 1.5 3
prototype making 1.5 3
Field visit 1.5 3
Internship - -
End Term Examination (Theory) 20 40
End Term Examination (Practical) 20 40
Other-Real World Application Development 8 16
Total 100% 200
CO & PO Mapping
CO/PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
2 2
CO1
CO2 2 2 2
CO3 2 3
2 3 3 3
CO4
2 3 3
CO5
Note: Now map your Cos with POs and fill the given matrix: Fill 1,2 or 3 in the cell depending on 1:poor, 2: medium
and 3:strong fulfillment of CO for particular PO
Program Outcomes
PO1 Engineering Knowledge: Apply knowledge of mathematics and science, with
fundamentals of Computer Science & Engineering to be able to solve complex engineering
problems related to CSE.
PO2 Problem Analysis: Identify, Formulate, review research literature and analyze complex
engineering problems related to CSE and reaching substantiated conclusions using first
principles of mathematics, natural sciences and engineering sciences
PO3 Design/Development of solutions: Design solutions for complex engineering problems
related to CSE and design system components or processes that meet the specified needs
with appropriate consideration for the public health and safety and the cultural societal and
environmental considerations
PO4 Conduct Investigations of Complex problems: Use research–based knowledge and
research methods including design of experiments, analysis and interpretation of data, and
synthesis of the information to provide valid conclusions.
PO5 Modern Tool Usage: Create, Select and apply appropriate techniques, resources and
modern engineering and IT tools including prediction and modeling to computer science
related complex engineering activities with an understanding of the limitations
PO6 The Engineer and Society: Apply Reasoning informed by the contextual knowledge to
assess societal, health, safety, legal and cultural issues and the consequent responsibilities
relevant to the CSE professional engineering practice
PO7 Environment and Sustainability: Understand the impact of the CSE professional
engineering solutions in societal and environmental contexts and demonstrate the
knowledge of, and need for sustainable development
PO8 Ethics: Apply Ethical Principles and commit to professional ethics and responsibilities and
norms of the engineering practice
PO9 Individual and Team Work: Function effectively as an individual and as a member or
leader in diverse teams and in multidisciplinary Settings
PO10 Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large such as able to comprehend and with write
effective reports and design documentation, make effective presentations and give and
receive clear instructions.
PO11 Project Management and Finance: Demonstrate knowledge and understanding of the
engineering management principles and apply these to one’s own work, as a member and
leader in a team, to manage projects and in multi disciplinary environments
PO12 Life-Long Learning: Recognize the need for and have the preparation and ability to engage
in independent and life-long learning the broadest context of technological change
