Syllabus: CSP 249, Database management System Lab
School: SET Batch: 2019-2023
Program: B.Tech Current Academic Year: 2019-2020
Branch:CSE Semester: IV
1 Course Code CSP249
2 Course Title Database Management System Lab
3 Credits 1
4 Contact 0-0-2
Hours
(L-T-P)
Course Compulsory
Status
5 Course To Develop efficient SQL programs to access Oracle
Objective databases
Build database using Data Definition Language Statements
Perform operations using Data Manipulation Language
statements like Insert, Update and Delete
6 Course By the end of this course you will be able to:
Outcomes
CO1: Understand the concept of SQL commands in DBMS
CO2: Create SQL SELECT statements that retrieve any required data
CO3: Perform operations using Data Manipulation Language
statements like Insert, Update and Delete
CO4: Manipulate your data to modify and summaries your results for
reporting
CO5: Apply Grouping Clauses on various tuples & relations of
database
CO6: Develop project based on various SQL commands.
7 Course An introduction to the design and creation of relational databases.
Description Create database-level applications and tuning robust business
applications. Lab sessions reinforce the learning objectives and
provide participants the opportunity to gain practical hands-on
experience.
8 Outline syllabus CO
Mapping
Unit 1 Practical based Data types
Classification SQL, Data types of SQL/Oracle CO1,CO2
Unit 2 Practical based on DDL commands
Create table, Alter table and drop table CO2,CO3
Unit 3 DML commands and Aggregate functions
Introduction about the INSERT, SELECT, UPDATE & CO3,CO4
DELETE commands.
Unit 4 Practical based on Grouping Clauses GROUP BY
ORDER BY & GROUP BY HAVING
Briefly explain Group by, order by ,having clauses with CO5
examples. Aggregate function: sum, avg, count, max,
min
Unit 5 Practical based on Sub- queries, JOINS
Related example of Sub- queries, Joins and related CO5,CO6
examples,Views,Trigger
Mode of Jury/Practical/Viva
examination
Weightage CA MTE ETE
Distribution 60% 0% 40%
Text book/s* 1. Korth ,Silberschatz& Sudarshan, Data base Concepts, Tata
McGraw-Hill
Other 1. Elmasri, Navathe, Fundamentals of Database Systems,
References Pearson Education Inc.
2. Thomas Connolly, Carolyn Begg, Database Systems: A
Practical Approach to design, Implementation and
Management, Pearson Education, Latest Edition.
3. Jeffrey D. Ullman, Jennifer Windon, A first course in
Database Systems, Pearson Education.
CO and PO Mapping
S. Course Outcome Program Outcomes (PO) & Program
No. Specific Outcomes (PSO)
1. CO1: Understand the concept of SQL commands in PO1,PO5, PSO1 ,PSO2
DBMS.
2. CO2: Create SQL SELECT statements that retrieve PO2, PO3, PO4, PO5, PO9,PSO1, ,PSO3
any required data.
3. CO3: Perform operations using Data Manipulation PO2, PO3, PO4, PO5, PO9,PSO1, ,PSO3
Language statements like Insert, Update and Delete.
4. CO4: Manipulate your data to modify and PO2, PO3, PO4, PO5, PO9,PSO1, ,PSO3
summaries your results for reporting.
5 CO5: Apply Grouping Clauses on various tuples & PO2, PO3, PO4, PO5, PO9,PSO1, ,PSO3
relations of database
6 CO6: Develop project based on various SQL PO2, PO3, PO4, PO5, PO9, PO12,PSO1,
commands. PSO2,PSO3
PO and PSO mapping with level of strength for Course Name Principles of Database Management System lab
(Course Code CSP 249)
PSO1
PSO2
PSO3
PO10
PO11
PO12
PO1
PO2
PO3
Conduct investigations of PO4
PO5
PO6
PO7
PO8
Individual and team work PO9
Apply standard Software
Familiarity and practical
Project management and
Understand, analyse and
The engineer and society
Engineering knowledge
Design/development of
Modern tool usage
complex problems
Life-long learning
COs
Environment and
Problem analysis
Communication:
sustainability
proficiency
solutions
develop
finance
Ethics
CO1 3 - - - 2 - - - - - - - 2 3 2
CO2 - 3 3 3 2 - - - 3 - - - 2 3 3
CO3 - 2 2 2 2 - - - 3 - - - 2 2 3
CO4 - 2 2 2 2 - - - 3 - - - 2 2 3
CO5 - 2 2 2 2 - - - 3 - - - 2 2 3
CO6 - 2 3 2 3 - - - 3 - - 2 3 3 3
Average of non-zeros entry in following table (should be auto calculated).
Course P
Code/ PO PO PO PO PO O PO PO PO PO PO PO PS PS PSO
Name 1 2 3 4 5 6 7 8 9 10 11 12 O1 O2 3
CSP249
/ DBMS 3 2.2 2.4 2.2 2.2 - - - 3 - - 2 2.2 2.5 2.8
lab
Strength of Correlation
1. Addressed to Slight (Low=1) extent 2. Addressed to Moderate (Medium=2) extent
3. Addressed to Substantial (High=3) extent
