4CS4-05.1

Identify the fundamental elements of relational database management systems.

4CS4-05.2

Design and explain the basic concepts of relational data model, entity-relationship model, and relational database design.

4CS4-05.3

Apply the relational database theory to formulate basic and advanced SQL queries and relational algebra expressions for the queries.

4CS4-05.4

Identify the use of normalization and functional dependency in database design.

4CS4-05.5

Understand the concept of transactions and serializability in database management system.

4CS4-05.6

Classify the implementation details of Concurrency control protocols and discuss various database recovery methods.

 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

-

-