KCS 551: DATABASE MANAGEMENT SYSTEMS LAB
Course Outcomes:
| CO |
At the end of course , the student will be able to:
|
Bloom’s Level
|
|
CO1
|
Understand and apply oracle 11 g products for creating tables, views, indexes,
sequences and other database objects. |
K2, K4
|
|
CO2
|
Design and implement a database schema for company data base, banking data base,
library information system, payroll processing system, student information
system. |
K3, K5, K6
|
|
CO3
|
Write and execute simple and complex queries using DDL, DML, DCL and TCL. |
K4, K5
|
|
CO4
|
Write and execute PL/SQL blocks, procedure functions, packages and triggers,
cursors. |
K4, K5
|
|
CO5
|
Enforce entity integrity, referential integrity, key constraints, and domain
constraints on database. |
K3, K4
|
Mapping Matrix of CO's and PO's
| COs |
PO1 |
PO2 |
PO3 |
PO4 |
PO5 |
PO6 |
PO7 |
PO8 |
PO9 |
PO10 |
PO11 |
PO12 |
PSO1 |
PSO2 |
PSO3 |
|
CO1
|
2 |
3 |
2 |
1 |
2 |
- |
- |
- |
- |
1 |
- |
1 |
2 |
- |
- |
|
CO2
|
2 |
2 |
- |
2 |
2 |
- |
- |
- |
- |
- |
- |
- |
2 |
- |
- |
|
CO3
|
2 |
2 |
- |
2 |
2 |
- |
- |
- |
- |
- |
- |
- |
2 |
- |
- |
|
CO4
|
2 |
2 |
1 |
2 |
2 |
- |
- |
- |
- |
- |
- |
- |
2 |
- |
- |
|
CO5
|
2 |
2 |
1 |
2 |
2 |
- |
- |
- |
- |
- |
- |
- |
2 |
- |
- |
|
Avg
|
2 |
2.2 |
1.3 |
1.8 |
2 |
- |
- |
- |
- |
1 |
- |
1 |
2 |
- |
- |
