Course Outcomes
|
4IT4-22.1 |
Illustrate ER models and identify the roles and privileges of various users in the database. |
| 4IT4-22.2 | Apply common SQL statements using DDL, DML & DCL statements to perform various operations. |
| 4IT4-22.3 | ConstructSQLqueriesfor various operations in a database. |
| 4IT4-22.4 | Interpret Embedded and Nested Queries. |
| 4IT4-22.5 | Assess the need of creating triggers and views to manage the database. |
Mapping of COs and POs
| 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 | 3 | 2 | 1 | 2 | - | - | - | - | 1 | - | 1 | 2 | - | - |
| Avg | 2 | 3 | 2 | 2 | 2 | - | - | - | - | 1 | - | 1 | 2 | - | - |



