KCA204 : DATABASE MANAGEMENT SYSTEMS
Course Outcomes:
|
Course Outcome (CO)
|
At the end of course , the student will be able to
|
Bloom’s Level
|
| CO 1 |
Describe the features of a database system and its application and compare
various types of data models. |
K 2
|
| CO 2 |
Construct an ER Model for a given problem and transform it into a relation
database schema. |
K 5, K 6
|
| CO 3 |
Formulate solution to a query problem using SQL Commands, relational algebra,
tuple calculus and domain calculus. |
K 5, K 6
|
| CO 4 |
Explain the need of normalization and normalize a given relation to the desired
normal form. |
K 2, K 3
|
| CO 5 |
Explain different approaches of transaction processing and concurrency control.
|
K 2
|
Mapping Matrix of CO's and PO's
| CO |
PO1 |
PO2 |
PO3 |
PO4 |
PO5 |
PO6 |
PO7 |
PO8 |
PO9 |
PO10 |
PO11 |
PO12 |
|
CO1
|
3 |
1 |
2 |
1 |
1 |
1 |
|
CO2
|
2 |
2 |
2 |
2 |
1 |
|
CO3
|
2 |
1 |
2 |
2 |
1 |
1 |
|
CO4
|
2 |
1 |
2 |
1 |
1 |
1 |
|
CO5
|
1 |
2 |
2 |
1 |
1 |
1 |
