Scribd
Upload
25 views3 pages

DBMS Lab CO - PO Values

The document lists various experiments related to database management, including creating tables, querying data, and implementing SQL commands. Each experiment is mapped to specific Course Outcomes (CO) and Program Outcomes (PO) with corresponding scores. The document also includes a case study section and mentions tools like PostgreSQL and DbVisualizer.

Uploaded by

logeshraja006
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views3 pages

DBMS Lab CO - PO Values

The document lists various experiments related to database management, including creating tables, querying data, and implementing SQL commands. Each experiment is mapped to specific Course Outcomes (CO) and Program Outcomes (PO) with corresponding scores. The document also includes a case study section and mentions tools like PostgreSQL and DbVisualizer.

Uploaded by

logeshraja006
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

LIST OF EXPERIMENTS

CO & PO MAPPING
EX. Course PO PO PO PO PO PO PO PO PO PO PO PO PSO PSO PSO
TITLE OF EXPERIMENT Outcome 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
No.
Create a database
table, add constraints
(primary key, unique,
check, Not null), insert CO2
3 2 2 3 2 3 3 2 3 2 2
rows, update and
delete rows using SQL
DDL and DML
1. commands.
Create a set of tables,
add foreign key
Constraints-and CO1 2 2 2 3 2 3 3 2 3 2 2
2. incorporate referential
integrity
Query the database
tables using different
„where‟clause CO2 3 2 2 3 2 3 3 2 3 2
conditions and also 3

3. implement aggregate
functions
Query the database
tables and explore sub CO2
queries and simple 3 2 2 3 2 3 3 2 3 2 2
4. join
operations
Query the database
tables and explore CO2 3 2 2 3 2 3 3 2 3 2 2
natural, equi and
5.
outer joins
Write user defined
functions and stored CO3 3 3 3 3 2 3 3 2 3 2 2
6.
procedures in SQL
7. Execute complex 3 3 3 3 2 3 3 2 3 2 2
transactions and realize CO3
DCL and TCL
commands
Write SQL Triggers for
insert, delete, and CO3
update operations in a 3 3 3 3 2 3 3 2 3 2 2
8. database
table.
Create View and index
for database tables with CO3 3 3 3 3 2 3 3 2 3 2 2
9. a large number of
records.
Createan XML database
10 and validate it using CO4 3 3 3 3 2 3 3 2 3 3 2
XML schema
Create Document,
column and graph CO5 3 3 3 3 2 3 3 2 3 3 2
based data using
11
NOSQL database tools
Develop a simple GUI
based database
application and CO1,
incorporate all CO2, 2 2 2 3 2 3 2 3 2 2 2
-
CO3
the
12 above-mentioned
features
Case Study using any
of the real life database
applications from the
following list
a) Inventory
Management for a
EMart Grocery Shop 2 2 2 3 2 3 - 2 3 2 2 2
CO1,
b) Society Financial CO2,
Management CO3
c) Cop Friendly App
–
Eseva
13
d) Property
Management – eMall
e) Star Small and
Medium Banking and
Finance
Content beyond syllabus
CO1,
PostgreSQL
14 CO2, 2 2 2 3 2 3 - 2 3 2 2 2
CO3
CO1,
DbVisualizer
15 CO2, 2 2 2 3 2 3 - 2 3 2 2 2
CO3

You might also like