4IT4-22.1

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

4IT4-22.2

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

4IT4-22.3

Construct SQL queries for 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.

PO1

PO2

PO3

PO4

PO5

PO6

PO7

PO8

PO9

PO10

PO11

PO12

PSO 1

PSO 2

PSO 3

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