CS3481 DATABASE MANAGEMENT SYSTEMS LABORATORY

(For IV Semester IT)

COURSEOUTCOMES (COs)
At the end of the course, the student should be able to

COs Cognitive Level Course outcomes

CO1 Create Create databases with different types of key constraints.
CO2 Apply Construct simple and complex SQL queries using DML and DCL commands.
Use advanced features such as stored procedures and triggers and incorporate
CO3 Apply
in GUI based application development.
CO4 Analyze Create an XML database and validate with meta-data (XML schema).
CO5 Create Create and manipulate data using NOSQL database.
CO6 Analyze Critically analyze the use of Tables, Views, Functions and Procedures

LIST OF EXPERIMENTS: MAPPING WITH COS, POS& PSOS

Exp.N
Name of the Experiment COs POs PSOs
o
Create a database table, add constraints (primary key, 1&2
1 unique, check, Not null), insert rows, update and 1 1,2,4,5,8,9,10,12
delete rows using SQL DDL and DML commands
Create a set of tables, add foreign key constraints 1&2
2 1 1,2,3,8,9,10,12
and incorporate referential integrity.
Query the database tables using different “where” 1&2
3 clause conditions and also implement aggregate 2 1,2,3,8,9,10,12
functions
Query the database tables and explore sub queries and 1&2
4 2 1,2,3,8,9,10,12
simple join operations.
Query the database tables and explore natural, equi 1&2
5 2,3 1,2,3,8,9,10,12
and outer joins.
Write user defined functions and stored procedures in 1&2
6 2,3,4,5,6 1,2,3,8,9,10,12
SQL
Execute complex transactions and realize DCL and 1&2
7 4&6 1,2,3,8,9,10,12
TCL commands
Write SQL Triggers for insert, delete, and update 1&2
8 3&5 1,2,3,8,9,10,12
operations in a database table.
Create View and index for database tables with a 1&2
9 3 1,2,3,8,9,10,12
large number of records.
Create an XML database and validate it using XML 1&2
10 3 1,2,3,8,9,10,12
schema.
Create Document, column and graph based data using 1&2
11 NOSQL database tools. 4,5, 1,2,3,8,9,10,12
6
Develop a simple GUI based database application and 1&2
12 5&6 1,2,3,8,9,10,12
incorporate all the above-mentioned features
13 Case Study using any of the real life database applications 1&6 1,2,3,4,5,6,9,11,12 1&2
from the following list
A. Inventory Management for a EMart Grocery
Shop
B. Society Financial Management
C. Cop Friendly App – Eseva
D. Property Management – eMall
E. Star Small and Medium Banking and Finance
 Build Entity Model diagram. The
diagram should align with the business
and functional goals stated in the
application.
 Apply Normalization rules in designing the tables
in scope.
 Prepared applicable views, triggers (for
auditing purposes), functions for
enabling enterprise grade features.
 Build PL SQL / Stored Procedures
 for Complex Functionalities, ex EOD
Batch Processing for calculating the
EMI for Gold Loan for each eligible
Customer.
 Ability to showcase ACID Properties with sample
queries with appropriate settings
Experiments Beyond the Syllabus
1 Database Programming: Implicit and Explicit Cursors 2,6 1,2,3,8,9,10,12 1&2
Exception Handling 6 1,2,3,8,9,10,12 1&2
2

PROGRAM OUTCOMES (POs)

PO1 Engineering Knowledge PO7 Environment & Sustainability

PO2 Problem Analysis PO8 Ethics
PO3 Design & Development PO9 Individual & Team Work
PO4 Investigations PO10 Communication Skills
PO5 Modern Tools PO11 Project Mgt. & Finance
PO6 Engineer & Society PO12 Life Long Learning

PROGRAM SPECIFIC OUTCOMES (PSOs)

PSO1: Cutting Edge:

To identify and implement appropriate techniques, resources, modern tools for providing solution to new
idea and innovation.
PSO2: Risk Management:
To manage complex IT projects with consideration of human, financial, ethical and environmental factors
and an understanding of risk management processes, operational and policy implications.