4CS4-22.1

Illustrate ER model and identify the roles and privileges of various users in a database.

4CS4-22.2

Apply common SQL statements using DDL, DML & DCL statements to perform various operations.

4CS4-22.3

Construct SQL queries for various operations in a database.

4CS4-22.4

Interpret Embedded and Nested queries.

4CS4-22.5

Assess the need of creating triggers and views to manage the database.

 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

2

-