Portfolio for evaluation of Course Outcome

2023 RDBMS 4th Sem (Qualitative assessment of Investment vs Outcome

Assessment through All

Evaluation of CT 1

Evaluation of CT 2
Computer Science

Assignment
RDBMS
& Technology

COS

Quiz
Name Roll No
RDBMS 1 2 3 4 3
RDBMS 2 2 3 3 2
RDBMS 3 3 3 3 3
ROHIT BISOI 20007631
RDBMS 4 2 3 3 4
RDBMS 5 3 2 4 3
RDBMS 6 3 4 3 3
RDBMS 1 4 4 4 3
RDBMS 2 2 3 3 4
RDBMS 3 2 3 3 3
Suryakanta Jana 10008007
RDBMS 4 4 4 3 4
RDBMS 5 3 4 3 3
RDBMS 6 3 3 3 2
RDBMS 1 3 4 3 3
RDBMS 2 4 4 4 3
RDBMS 3 3 3 3 4
DEVTANU SANDHAKI 10008008
RDBMS 4 4 4 3 4
RDBMS 5 3 4 4 3
RDBMS 6 3 4 3 3
RDBMS 1 4 4 4 3
RDBMS 2 3 3 3 3
RDBMS 3 4 3 3 4
Arpita Pandit 10008009
RDBMS 4 2 3 3 3
RDBMS 5 3 4 3 3
RDBMS 6 3 4 3 4
RDBMS 1 4 3 3 3
RDBMS 2 3 3 3 3
RDBMS 3 2 3 4 3
SANCHITA PAL 10008010
RDBMS 4 3 3 3 3
RDBMS 5 3 3 3 4
RDBMS 6 3 3 3 3
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 3
RDBMS 3 3 3 3 4
SRIHARI SAMANTA 10008011
RDBMS 4 3 3 3 3
RDBMS 5 3 4 3 4
RDBMS 6 3 3 3 3
RDBMS 1 3 3 4 3
RDBMS 2 4 3 3 3
RDBMS 3 3 4 4 4
KANTIMAY BAG 10008012
RDBMS 4 4 3 3 3
RDBMS 5 4 4 4 3
RDBMS 6 3 3 3 4
RDBMS 1 4 3 3 3
RDBMS 2 3 3 3 4
RDBMS 3 3 4 4 3
PRAMIT JANA 10008013
 PRAMIT JANA 10008013
RDBMS 4 3 4 3 4
RDBMS 5 4 4 4 3
RDBMS 6 3 4 3 3
RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 4
RDBMS 3 4 3 4 4
ANKIT CHAKRABORTY 10008014
RDBMS 4 3 4 3 3
RDBMS 5 4 4 3 3
RDBMS 6 3 3 3 2
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 4
RDBMS 3 3 3 3 4
MAMPI MAITY 10008018
RDBMS 4 3 4 3 4
RDBMS 5 3 3 4 3
RDBMS 6 3 4 3 2
RDBMS 1 3 4 2 3
RDBMS 2 3 3 2 2
RDBMS 3 4 4 3 2
Subham Patra 10008019
RDBMS 4 3 3 3 3
RDBMS 5 3 4 2 3
RDBMS 6 3 3 3 3
RDBMS 1 4 3 3 3
RDBMS 2 3 3 3 4
RDBMS 3 4 3 3 4
SANTANU PATRA 10008020
RDBMS 4 3 4 3 3
RDBMS 5 3 4 4 3
RDBMS 6 3 2 3 2
RDBMS 1 4 4 4 3
RDBMS 2 4 3 3 4
RDBMS 3 4 3 3 3
RISA SAMANTA 10008021
RDBMS 4 4 3 3 4
RDBMS 5 3 3 4 3
RDBMS 6 3 3 3 2
RDBMS 1 3 4 3 3
RDBMS 2 2 3 4 3
RDBMS 3 4 2 4 3
Siddhanta Paul 10008022
RDBMS 4 3 4 3 3
RDBMS 5 3 3 4 3
RDBMS 6 3 4 3 4
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 4
RDBMS 3 2 3 3 3
Subhadip Barik 10008023
RDBMS 4 3 4 3 3
RDBMS 5 3 3 3 3
RDBMS 6 3 2 3 3
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 2
SHANKHA SHUBHRA RDBMS 3 3 3 3 3
10008026
DAS RDBMS 4 3 3 3 3
RDBMS 5 4 2 3 3
RDBMS 6 3 3 3 3
RDBMS 1 3 4 3 3
RDBMS 2 2 3 3 2
RDBMS 3 3 2 2 3
CHANDRANI HAZRA 10008028
RDBMS 4 4 2 3 3
RDBMS 5 3 4 2 3
 RDBMS 6 2 2 3 2
RDBMS 1 2 3 3 3
RDBMS 2 3 3 3 2
RDBMS 3 4 3 3 3
Sagar Kar 10008029
RDBMS 4 3 2 3 3
RDBMS 5 3 3 2 3
RDBMS 6 3 2 3 3
 RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 2
RDBMS 3 3 3 3 3
MEHERAN NESA 10008030
RDBMS 4 3 3 3 3
RDBMS 5 3 3 4 3
RDBMS 6 3 3 3 3
RDBMS 1 3 3 2 3
RDBMS 2 3 3 3 2
RDBMS 3 3 4 3 3
Gargi Das 10008031
RDBMS 4 3 3 3 3
RDBMS 5 3 3 4 3
RDBMS 6 3 3 3 3
RDBMS 1 3 4 4 3
RDBMS 2 4 3 3 4
RDBMS 3 4 3 4 3
Misbahul Alam 10008036
RDBMS 4 4 4 3 3
RDBMS 5 3 4 4 4
RDBMS 6 3 3 3 4
RDBMS 1 2 3 4 3
RDBMS 2 2 3 3 2
RDBMS 3 3 3 3 3
ARDHENDU DAS 10008037
RDBMS 4 2 3 3 4
RDBMS 5 3 2 4 3
RDBMS 6 3 4 3 2
RDBMS 1 4 4 2 3
RDBMS 2 2 3 3 2
RDBMS 3 2 3 3 3
BARNALI JANA 10008038
RDBMS 4 4 2 3 3
RDBMS 5 3 4 3 3
RDBMS 6 3 3 3 2
RDBMS 1 3 2 3 3
RDBMS 2 2 3 3 3
RDBMS 3 3 3 3 3
PRIYA DAS 10008040
RDBMS 4 2 2 3 4
RDBMS 5 3 2 2 3
RDBMS 6 3 2 3 3
RDBMS 1 4 4 4 3
RDBMS 2 3 3 3 3
RDBMS 3 4 3 3 3
PRANOY SAHA 10008042
RDBMS 4 2 4 3 4
RDBMS 5 3 4 3 3
RDBMS 6 3 4 3 2
RDBMS 1 4 3 3 3
RDBMS 2 3 3 3 3
RDBMS 3 2 3 4 3
MALLIKA PANJA 10008045
RDBMS 4 3 3 3 3
RDBMS 5 3 3 3 4
RDBMS 6 3 3 3 3
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 3
RDBMS 3 3 3 3 4
PALLABI GIRI 10008050
RDBMS 4 3 3 3 3
RDBMS 5 3 4 3 4
RDBMS 6 3 2 3 3
RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 3
 RDBMS 3 3 3 3 3
Sayan Samanta 10008051
RDBMS 4 3 3 3 3
RDBMS 5 3 3 3 3
RDBMS 6 3 3 3 4
RDBMS 1 2 3 3 3
RDBMS 2 3 3 3 2
RDBMS 3 3 3 3 3
NILKAMAL HAZRA 10008052
RDBMS 4 3 3 3 3
RDBMS 5 3 3 3 3
RDBMS 6 3 3 3 3
RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 2
RDBMS 3 4 3 4 4
BEDIKA CHAUDHURY 10008053
RDBMS 4 3 4 3 3
RDBMS 5 3 4 3 3
RDBMS 6 3 3 3 2
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 4
RDBMS 3 3 3 3 4
SONJU MAKAR 10008054
RDBMS 4 3 4 3 4
RDBMS 5 3 3 4 3
RDBMS 6 3 4 3 2
RDBMS 1 3 4 4 3
RDBMS 2 3 3 4 4
RDBMS 3 4 4 3 3
Supriya Bhunia 10008055
RDBMS 4 3 4 4 3
RDBMS 5 3 4 4 3
RDBMS 6 3 4 3 4
RDBMS 1 4 3 3 3
RDBMS 2 4 3 3 4
RDBMS 3 4 3 3 4
Debasmita Hazra 10008056
RDBMS 4 3 4 3 3
RDBMS 5 3 4 3 3
RDBMS 6 3 3 3 4
RDBMS 1 2 4 4 3
RDBMS 2 4 3 3 4
RDBMS 3 4 3 3 3
Jeet Hait 10008057
RDBMS 4 4 4 3 4
RDBMS 5 3 3 3 3
RDBMS 6 3 3 3 2
RDBMS 1 4 4 3 3
RDBMS 2 4 4 4 3
SOURISH RDBMS 3 4 4 4 3
10008058
MAHAPATRA RDBMS 4 3 4 4 4
RDBMS 5 3 3 4 3
RDBMS 6 3 4 3 4
RDBMS 1 2 3 4 4
RDBMS 2 3 3 3 4
RDBMS 3 3 3 3 3
TANMOY JANA 10008060
RDBMS 4 3 4 3 3
RDBMS 5 3 3 3 3
RDBMS 6 3 2 3 3
RDBMS 1 4 3 4 3
RDBMS 2 3 3 3 2
RDBMS 3 3 4 3 4
ABANTIKA MANNA 10008064
RDBMS 4 3 3 3 3
 RDBMS 5 4 4 3 3
RDBMS 6 3 3 4 3
RDBMS 1 3 4 3 3
RDBMS 2 4 3 3 2
RDBMS 3 2 2 4 3
SUMANA MAITY 10008065
RDBMS 4 4 4 3 3
RDBMS 5 3 2 2 3
RDBMS 6 2 2 3 4
RDBMS 1 4 3 3 3
RDBMS 2 3 3 3 2
RDBMS 3 4 3 3 3
RAHUL BAG 10027399
RDBMS 4 3 4 3 3
RDBMS 5 3 3 4 3
RDBMS 6 3 4 3 3
RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 4
RDBMS 3 3 3 3 3
Soumyajeet Das 10027400
RDBMS 4 3 3 3 3
RDBMS 5 4 4 4 3
RDBMS 6 3 3 3 3
 RDBMS 1 3 3 4 3
RDBMS 2 3 3 3 4
RDBMS 3 3 4 4 3
Sanchari Maiti 10027401
RDBMS 4 4 3 3 3
RDBMS 5 3 3 4 3
RDBMS 6 3 3 3 3
RDBMS 1 3 4 4 3
RDBMS 2 4 3 3 2
SK ALAMGIR RDBMS 3 4 3 2 3
10027403
HOSSAIN RDBMS 4 2 4 3 3
RDBMS 5 3 2 2 2
RDBMS 6 3 3 3 4
RDBMS 1 3 3 3 3
RDBMS 2 3 3 3 4
RDBMS 3 3 4 3 3
PRITHA PATRA 10007623
RDBMS 4 4 3 3 4
RDBMS 5 3 3 4 3
RDBMS 6 3 3 3 3
RDBMS 1 3 3 4 3
RDBMS 2 3 3 3 4
RDBMS 3 3 4 3 3
SUBHADEEP BHUNIA 10007643
RDBMS 4 3 3 3 3
RDBMS 5 3 4 4 3
RDBMS 6 3 3 4 3
RDBMS 1 3 4 4 3
RDBMS 2 4 3 4 4
PRATAP KUMAR RDBMS 3 3 3 3 3
10023333
MANNA RDBMS 4 3 4 3 3
RDBMS 5 4 3 3 3
RDBMS 6 3 3 3 4
Qualitativet Attainment

CO1 CO2
2.45 2.30
 Total % of STUDENT FETCHING
Course Outcome
External Evaluation

Combined Evaluation Index

vestment vs Outcome)

MORE THAN 60 %
Select Course

Course Credit

ACHIEVED BY THE
Credit Point
Aggregate CO

PUT CREDIT

ASSESSMENT
Attainment

Attainment

STUDENT
CO-wise

Direct
3 30 2

3.00 100.00 3
2.50 4
3.00
2.22 7 21 2.10 2.15
3.00
3.00
3.25
3.75
3.00
2.75
2.41 7 21 2.10 2.22
3.75
3.25
2.75
3.25
3.75
3.25
2.59 7 21 2.10 2.30
3.75
3.50
3.25
3.75
3.00
3.50
2.47 10 30 3.00 2.79
2.75
3.25
3.50
3.25
3.00
3.00
2.31 8 24 2.40 2.37
3.00
3.25
3.00
3.50
3.00
3.25
2.41 8 24 2.40 2.40
3.00
3.50
3.00
3.25
3.25
3.75
2.56 9 27 2.70 2.65
3.25
3.75
3.25
3.25
3.25
3.50
2.56 8 24 2.40 2.47
 2.56 8 24 2.40 2.47
3.50
3.75
3.25
3.00
3.25
3.75
2.44 9 27 2.70 2.60
3.25
3.50
2.75
3.50
3.25
3.25
2.47 8 24 2.40 2.43
3.50
3.25
3.00
3.00
2.50
3.25
2.22 8 24 2.40 2.33
3.00
3.00
3.00
3.25
3.25
3.50
2.41 8 24 2.40 2.40
3.25
3.50
2.50
3.75
3.50
3.25
2.50 10 30 3.00 2.80
3.50
3.25
2.75
3.25
3.00
3.25
2.44 8 24 2.40 2.42
3.25
3.25
3.50
3.50
3.25
2.75
2.31 8 24 2.40 2.37
3.25
3.00
2.75
3.50
2.75
3.00
2.28 9 27 2.70 2.53
3.00
3.00
3.00
3.25
2.50
2.50
2.06 7 21 2.10 2.09
3.00
3.00
2.25
2.75
2.75
3.25
2.13 7 21 2.10 2.11
2.75
2.75
2.75
3.00
2.75
3.00
2.25 10 30 3.00 2.70
3.00
3.25
3.00
2.75
2.75
3.25
2.25 9 27 2.70 2.52
3.00
3.25
3.00
3.50
3.50
3.50
2.63 8 24 2.40 2.49
3.50
3.75
3.25
3.00
2.50
3.00
2.19 7 21 2.10 2.14
3.00
3.00
3.00
3.25
2.50
2.75
2.19 7 21 2.10 2.14
3.00
3.25
2.75
2.75
2.75
3.00
2.06 8 24 2.40 2.27
2.75
2.50
2.75
3.75
3.00
3.25
2.44 8 24 2.40 2.42
3.25
3.25
3.00
3.25
3.00
3.00
2.31 8 24 2.40 2.37
3.00
3.25
3.00
3.50
3.00
3.25
2.38 7 21 2.10 2.21
3.00
3.50
2.75
3.00
3.00
3.00
2.28 9 27 2.70 2.53
3.00
3.00
3.25
2.75
2.75
3.00
2.19 7 21 2.10 2.14
3.00
3.00
3.00
3.00
2.75
3.75
2.34 10 30 3.00 2.74
3.25
3.25
2.75
3.50
3.25
3.25
2.47 6 18 1.80 2.07
3.50
3.25
3.00
3.50
3.50
3.50
2.63 7 21 2.10 2.31
3.50
3.50
3.50
3.25
3.50
3.50
2.50 7 21 2.10 2.26
3.25
3.25
3.25
3.25
3.50
3.25
2.44 7 21 2.10 2.24
3.75
3.00
2.75
3.50
3.75
3.75
2.69 7 21 2.10 2.34
3.75
3.25
3.50
3.25
3.25
3.00
2.31 7 21 2.10 2.18
3.25
3.00
2.75
3.50
2.75
3.50
2.44 6 18 1.80 2.05
3.00
3.50
3.25
3.25
3.00
2.75
2.22 8 24 2.40 2.33
3.50
2.50
2.75
3.25
2.75
3.25
2.38 7 21 2.10 2.21
3.25
3.25
3.25
3.00
3.25
3.00
2.38 10 30 3.00 2.75
3.00
3.75
3.00
3.25
3.25
3.50
2.44 9 27 2.70 2.60
3.25
3.25
3.00
3.50
3.00
3.00
2.25 7 21 2.10 2.16
3.00
2.25
3.25
3.00
3.25
3.25
2.41 6 18 1.80 2.04
3.50
3.25
3.00
3.25
3.25
3.25
2.44 6 18 1.80 2.05
3.00
3.50
3.25
3.50
3.75
3.00
2.50 6 18 1.80 2.08
3.25
3.25
3.25
t Attainment 2.37 Quantative Attainment 2.33 2.35

CO3 CO4 CO5 CO6

2.40 2.40 2.41 2.26
20

30
40 1
2
3
4

0
1
2
3
4
 3
3
3
CC 7 3 1
BC 7 3 2
BC 7 3 3
BB 10 3 4
BC 8 3 5
BC 8 3 6
BC 9 3 7
CC 8 3 8
BB 9 3 9
BB 8 3 10
BC 8 3 11
BC 8 3 12
BB 10 3 13
BC 8 3 14
BC 8 3 15
BB 9 3 16
BC 7 3 17
BC 7 3 18
BB 10 3 19
BC 9 3 20
BC 8 3 21
BB 7 3 22
BC 7 3 23
BC 8 3 24
BB 8 3 25
BC 8 3 26
BC 7 3 27
BB 9 3 28
BC 7 3 29
BB 10 3 30
BC 6 3 31
BC 7 3 32
BC 7 3 33
BC 7 3 34
BC 7 3 35
BC 7 3 36
BC 6 3 37
BC 8 3 38
BC 7 3 39
BB 10 3 40
BB 9 3 41
CC 7 3 42
BC 6 3 43
BC 6 3 44
CC 6 3 45
0 3 46
0 3 47
0 3 48
0 3 49
0 3 50
0 3 51
0 3 52
0 3 53
0 3 54
0 3 55
0 3 56
0 3 57
0 3 58
0 3 59
0 3 60
0 3 61
0 3 62
0 3 63
0 3 64
0 3 65
0 3 66
0 3 67
0 3 68
0 3 69
0 3 70
0 3 71
0 0 3 72
0 0 3 73
0 0 3 74
0 0 3 75
0 0 3 76
0 0 3 77
0 0 3 78
0 0 3 79
0 0 3 80
0 0 3 81
0 0 3 82
0 0 3 83
0 3 84
0 3 85
0 3 86
0 3 87
0 3 88
0 3 89
0 3 90
0 3 91
0 3 92
0 3 93
0 3 94
0 3 95
0 3 96
0 3 97
0 3 98
0 3 99
0 3 100
0 3 101
0 3 102
0 3 103
0 3 104
0 3 105
0 3 106
0 3 107
0 3 108
0 3 109
0 3 110
0 3 111
0 3 112
0 3 113
0 3 114
0 3 115
0 3 116
0 3 117
0 3 118
0 3 119
0 3 120
0 3 121
0 3 122
0 3 123
0 3 124
0 3 125
0 3 126
0 3 127
0 3 128
0 3 129
0 3 130
0 3 131
0 3 132
0 3 133
0 3 134
0 3 135
0 3 136
0 3 137
0 3 138
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
0 3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2.15 1 3.00
0.00 0 100.00 2.50
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.25 3.00 2.50 3.00 3.00
2.22 1 PUT population 3.75
0.00 0 Below 3.00
0.00 0 2.75
0.00 0 3.75
0.00 0 3.25
0.00 0 Total 45 2.75 3.75 3.00 2.75 3.75
2.30 1 3.25
0.00 0 3.75
0.00 0 3.25
0.00 0 3.75
0.00 0 3.50
0.00 0 3.25 3.25 3.75 3.25 3.75
2.79 1 3.75
0.00 0 3.00
0.00 0 3.50
0.00 0 2.75
0.00 0 3.25
0.00 0 3.50 3.75 3.00 3.50 2.75
2.37 1 3.25
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00 3.25 3.00 3.00 3.00
2.40 1 3.50
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00
0.00 0 3.50
0.00 0 3.00 3.50 3.00 3.25 3.00
2.65 1 3.25
0.00 0 3.25
0.00 0 3.75

3.25 3.25 3.75 3.25

0.00 0 3.25
0.00 0 3.75
0.00 0 3.25 3.25 3.25 3.75 3.25
2.47 1 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.50
0.00 0 3.75
0.00 0 3.25 3.25 3.25 3.50 3.50
2.60 1 3.00
0.00 0 3.25
0.00 0 3.75
0.00 0 3.25
0.00 0 3.50
0.00 0 2.75 3.00 3.25 3.75 3.25
2.43 1 3.50
0.00 0 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.00 3.50 3.25 3.25 3.50
2.33 1 3.00
0.00 0 2.50
0.00 0 3.25
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00 3.00 2.50 3.25 3.00
2.40 1 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.50
0.00 0 2.50 3.25 3.25 3.50 3.25
2.80 1 3.75
0.00 0 3.50
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 2.75 3.75 3.50 3.25 3.50
2.42 1 3.25
0.00 0 3.00
0.00 0 3.25
0.00 0 3.25
0.00 0 3.25
0.00 0 3.50 3.25 3.00 3.25 3.25
2.37 1 3.50
0.00 0 3.25
0.00 0 2.75
0.00 0 3.25
0.00 0 3.00
0.00 0 2.75 3.50 3.25 2.75 3.25
2.53 1 3.50
0.00 0 2.75
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00 3.50 2.75 3.00 3.00
2.09 1 3.25
0.00 0 2.50
0.00 0 2.50
0.00 0 3.00
0.00 0 3.00
0.00 0 2.25 3.25 2.50 2.50 3.00
2.11 1 2.75
0.00 0 2.75
0.00 0 3.25
0.00 0 2.75
0.00 0 2.75
0.00 0 2.75 2.75 2.75 3.25 2.75
2.70 1 3.00
0.00 0 2.75
0.00 0 3.00
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00 3.00 2.75 3.00 3.00
2.52 1 2.75
0.00 0 2.75
0.00 0 3.25

2.75 2.75 3.25 3.00

0.00 0 3.00
0.00 0 3.25
0.00 0 3.00 2.75 2.75 3.25 3.00
2.49 1 3.50
0.00 0 3.50
0.00 0 3.50
0.00 0 3.50
0.00 0 3.75
0.00 0 3.25 3.50 3.50 3.50 3.50
2.14 1 3.00
0.00 0 2.50
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00 3.00 2.50 3.00 3.00
2.14 1 3.25
0.00 0 2.50
0.00 0 2.75
0.00 0 3.00
0.00 0 3.25
0.00 0 2.75 3.25 2.50 2.75 3.00
2.27 1 2.75
0.00 0 2.75
0.00 0 3.00
0.00 0 2.75
0.00 0 2.50
0.00 0 2.75 2.75 2.75 3.00 2.75
2.42 1 3.75
0.00 0 3.00
0.00 0 3.25
0.00 0 3.25
0.00 0 3.25
0.00 0 3.00 3.75 3.00 3.25 3.25
2.37 1 3.25
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00 3.25 3.00 3.00 3.00
2.21 1 3.50
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00
0.00 0 3.50
0.00 0 2.75 3.50 3.00 3.25 3.00
2.53 1 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.25 3.00 3.00 3.00 3.00
2.14 1 2.75
0.00 0 2.75
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00 2.75 2.75 3.00 3.00
2.74 1 3.00
0.00 0 2.75
0.00 0 3.75
0.00 0 3.25
0.00 0 3.25
0.00 0 2.75 3.00 2.75 3.75 3.25
2.07 1 3.50
0.00 0 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.00 3.50 3.25 3.25 3.50
2.31 1 3.50
0.00 0 3.50
0.00 0 3.50
0.00 0 3.50
0.00 0 3.50
0.00 0 3.50 3.50 3.50 3.50 3.50
2.26 1 3.25
0.00 0 3.50
0.00 0 3.50

3.25 3.50 3.50 3.25

0.00 0 3.25
0.00 0 3.25
0.00 0 3.25 3.25 3.50 3.50 3.25
2.24 1 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.75
0.00 0 3.00
0.00 0 2.75 3.25 3.50 3.25 3.75
2.34 1 3.50
0.00 0 3.75
0.00 0 3.75
0.00 0 3.75
0.00 0 3.25
0.00 0 3.50 3.50 3.75 3.75 3.75
2.18 1 3.25
0.00 0 3.25
0.00 0 3.00
0.00 0 3.25
0.00 0 3.00
0.00 0 2.75 3.25 3.25 3.00 3.25
2.05 1 3.50
0.00 0 2.75
0.00 0 3.50
0.00 0 3.00
0.00 0 3.50
0.00 0 3.25 3.50 2.75 3.50 3.00
2.33 1 3.25
0.00 0 3.00
0.00 0 2.75
0.00 0 3.50
0.00 0 2.50
0.00 0 2.75 3.25 3.00 2.75 3.50
2.21 1 3.25
0.00 0 2.75
0.00 0 3.25
0.00 0 3.25
0.00 0 3.25
0.00 0 3.25 3.25 2.75 3.25 3.25
2.75 1 3.00
0.00 0 3.25
0.00 0 3.00
0.00 0 3.00
0.00 0 3.75
0.00 0 3.00 3.00 3.25 3.00 3.00
2.60 1 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.25
0.00 0 3.00 3.25 3.25 3.50 3.25
2.16 1 3.50
0.00 0 3.00
0.00 0 3.00
0.00 0 3.00
0.00 0 2.25
0.00 0 3.25 3.50 3.00 3.00 3.00
2.04 1 3.00
0.00 0 3.25
0.00 0 3.25
0.00 0 3.50
0.00 0 3.25
0.00 0 3.00 3.00 3.25 3.25 3.50
2.05 1 3.25
0.00 0 3.25
0.00 0 3.25
0.00 0 3.00
0.00 0 3.50
0.00 0 3.25 3.25 3.25 3.25 3.00
2.08 1 3.50
0.00 0 3.75
0.00 0 3.00
0.00 0 3.25
0.00 0 3.25
0.00 0 3.25 3.50 3.75 3.00 3.25
45 147.00 138.00 144.25 144.25
3.27 3.07 3.21 3.21
2.45 2.30 2.40 2.40
3.00 3.25

3.25 2.75

3.50 3.25

3.25 3.50

3.25 3.00

3.50 3.00

3.75 3.25
3.75 3.25

3.75 3.25

3.50 2.75

3.25 3.00

3.00 3.00

3.50 2.50

3.25 2.75
3.25 3.50

3.00 2.75

3.00 3.00

3.00 2.25

2.75 2.75

3.25 3.00

3.25 3.00
3.25 3.00

3.75 3.25

3.00 3.00

3.25 2.75

2.50 2.75

3.25 3.00

3.25 3.00
3.50 2.75

3.00 3.25

3.00 3.00

3.25 2.75

3.25 3.00

3.50 3.50

3.25 3.25
3.25 3.25

3.00 2.75

3.25 3.50

3.00 2.75

3.50 3.25

2.50 2.75

3.25 3.25
3.75 3.00

3.25 3.00

2.25 3.25

3.25 3.00

3.50 3.25

3.25 3.25
144.75 135.75
3.22 3.02
2.41 2.26
 1 ROHIT BISOI 20007631

2 Suryakanta Jana 10008007

3 DEVTANU SANDHAKI 10008008
ROHIT BISOI 20007631
4 Arpita Pandit 10008009

5 SANCHITA PAL 10008010

6 SRIHARI SAMANTA 10008011

7 KANTIMAY BAG 10008012
8 PRAMIT JANA 10008013
9 ANKIT CHAKRABORTY 10008014
Suryakanta Jana 10008007
10 MAMPI MAITY 10008018
11 Subham Patra 10008019
12 SANTANU PATRA 10008020
13 RISA SAMANTA 10008021
14 Siddhanta Paul 10008022
15 Subhadip Barik 10008023
DEVTANU SANDHAKI 10008008
16 SHANKHA SHUBHRA DAS 10008026
17 CHANDRANI HAZRA 10008028
18 Sagar Kar 10008029
19 MEHERAN NESA 10008030
20 Gargi Das 10008031
21 Misbahul Alam 10008036
Arpita Pandit 10008009
22 ARDHENDU DAS 10008037
23 BARNALI JANA 10008038
24 PRIYA DAS 10008040
25 PRANOY SAHA 10008042
26 MALLIKA PANJA 10008045
27 PALLABI GIRI 10008050
SANCHITA PAL 10008010
28 Sayan Samanta 10008051
29 NILKAMAL HAZRA 10008052
30 BEDIKA CHAUDHURY 10008053
31 SONJU MAKAR 10008054
32 Supriya Bhunia 10008055
33 Debasmita Hazra 10008056
SRIHARI SAMANTA 10008011
34 Jeet Hait 10008057
35 SOURISH MAHAPATRA 10008058
36 TANMOY JANA 10008060
37 ABANTIKA MANNA 10008064
38 SUMANA MAITY 10008065
39 RAHUL BAG 10027399
KANTIMAY BAG 10008012
40 Soumyajeet Das 10027400
41 Sanchari Maiti 10027401
42 SK ALAMGIR HOSSAIN 10027403
43 PRITHA PATRA 10007623
44 SUBHADEEP BHUNIA 10007643
45 PRATAP KUMAR MANNA 10023333
PRAMIT JANA 10008013
46 0 0
47 0 0
48 0 0
49 0 0
50 0 0
51 0 0
ANKIT CHAKRABORTY 10008014
 ANKIT CHAKRABORTY 10008014
52 0 0
53 0
54 0
55 0
56 0
57 0
MAMPI MAITY 10008018
58
59
60
61
62
63
Subham Patra 10008019
64
65
66
67
68
69
SANTANU PATRA 10008020
70
71
72
73
74
75
RISA SAMANTA 10008021
76
77
78
79
80
81
Siddhanta Paul 10008022
82
83
84
85
86
87
Subhadip Barik 10008023
88
89
90
91
92
93
SHANKHA SHUBHRA DAS 10008026
94
95
96
97
98
99
CHANDRANI HAZRA 10008028
100
101
102
103
104
Sagar Kar 10008029
105
Sagar Kar 10008029
106
107
108
109
110
111
MEHERAN NESA 10008030
112
113
114

Gargi Das 10008031

Misbahul Alam 10008036

ARDHENDU DAS 10008037

BARNALI JANA 10008038

PRIYA DAS 10008040

PRANOY SAHA 10008042

MALLIKA PANJA 10008045

PALLABI GIRI 10008050

 PALLABI GIRI 10008050

Sayan Samanta 10008051

NILKAMAL HAZRA 10008052

BEDIKA CHAUDHURY 10008053

SONJU MAKAR 10008054

Supriya Bhunia 10008055

Debasmita Hazra 10008056

Jeet Hait 10008057

SOURISH MAHAPATRA 10008058

 TANMOY JANA 10008060

ABANTIKA MANNA 10008064

SUMANA MAITY 10008065

RAHUL BAG 10027399

Soumyajeet Das 10027400

Sanchari Maiti 10027401

SK ALAMGIR HOSSAIN 10027403

PRITHA PATRA 10007623

SUBHADEEP BHUNIA 10007643

 SUBHADEEP BHUNIA 10007643

PRATAP KUMAR MANNA 10023333

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
20007631
10008007
10008008
10008009
10008010
10008011
10008012
10008013
10008014
10008018
10008019
10008020
10008021
10008022
10008023
10008026
10008028
10008029
10008030
10008031
10008036
10008037
10008038
10008040
10008042
10008045
10008050
10008051
10008052
10008053
10008054
10008055
10008056
10008057
10008058
10008060
10008064
10008065
10027399
10027400
10027401
10027403
10007623
10007643
10023333
0
0
0
0
0
0
0
0
0
0
0
0
ID 5
BC 7 7
BC 7 7
BC 7 7
AA 10 10
BB 8 8
BB 8 8
AB 9 9
BB 8 8
AB 9 9
BB 8 8
BB 8 8
BB 8 8
AA 10 10
BB 8 8
BB 8 8
AB 9 9
BC 7 7
BC 7 7
AA 10 10
AB 9 9
BB 8 8
BC 7 7
BC 7 7
BB 8 8
BB 8 8
BB 8 8
BC 7 7
AB 9 9
BC 7 7
AA 10 10
CC 6 6
BC 7 7
BC 7 7
BC 7 7
BC 7 7
BC 7 7
CC 6 6
BB 8 8
BC 7 7
AA 10 10
AB 9 9
BC 7 7
CC 6 6
CC 6 6
CC 6 6
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 5
0 5
5
5
5
5
5
5
5
5
5
5
 CO RDBMS CO PO1 PO2

Define database problems at the view level and

RDBMS

Identify the physical structure of a database, RDBMS 1 3 2

1

demonstrating skills in Remembering foundational

concepts for data handling.

Explain and Describe the use of Entity-Relationship

RDBMS

Diagrams (ERDs) in database design, helping students RDBMS 2 3 3

2

to classify and interpret database components,

achieving Understanding.
Apply relational algebra principles to solve a range of
RDBMS

query and data update problems, showcasing

RDBMS 3 3 3
proficiency in Applying.
3
RDBMS

Construct and Execute SQL queries to retrieve and

manipulate data, demonstrating effective command of RDBMS 4 3 3
4

SQL at the level of Applying.

Analyze functional dependencies to Design and
RDBMS

Normalize databases, achieving Analyzing by creating 3 3

RDBMS 5
5

optimized data structures and internal organization.

Evaluate transaction systems and Assess data

extraction techniques for efficiency, demonstrating
RDBMS

expertise in Evaluating for effective database RDBMS 6 3 2

6

management.

RDBMS 3.00 2.67

Qualitative
Quantitativ 2.37 2.37 2.11
Attainment 2.33
e 2.33 2.07
Attainment
Direct 2.35 2.35 2.09
Attainment
* Enter correlation levels 1, 2 or 3
100.00

Attainment (Low) 2: Moderate (Medium)3: Sub

% no correlation
 PO3 PO4 PO5 PO6 PO7

1 1 - 1 -

2 2 1 1 -

3 2 - 1 1

3 3 1 1 1

3 2 1 2 2

3 1 2 3 3

2.50 1.83 1.25 1.50 1.75

1.98 1.45 0.99 1.19 1.38
1.94 1.43 0.97 1.17 1.36

1.96 1.44 0.98 1.17 1.37

ter correlation levels 1, 2 or 3 as defined below: 1: Slight

2: Moderate (Medium)3: Substantial (High) and It there is
no correlation, put “-”
CO RDBMS CO PSO1 PSO2 PSO3

Define database problems at the view level and

RDBMS 1 Identify the physical structure of a database, RDBMS 1 3 1 1
demonstrating skills in Remembering foundational
concepts for data handling.

Explain and Describe the use of Entity-Relationship

RDBMS 2 Diagrams (ERDs) in database design, helping students RDBMS 2 3 2 2
to classify and interpret database components,
achieving Understanding.
Apply relational algebra principles to solve a range of
RDBMS 3
query and data update problems, showcasing RDBMS 3 3 3 2
proficiency in Applying.

Construct and Execute SQL queries to retrieve and

RDBMS 4 manipulate data, demonstrating effective command of RDBMS 4 3 3 2
SQL at the level of Applying.
Analyze functional dependencies to Design and
RDBMS 5 Normalize databases, achieving Analyzing by creating RDBMS 5 3 2 3
optimized data structures and internal organization.
Evaluate transaction systems and Assess data
RDBMS 6 extraction techniques for efficiency, demonstrating RDBMS 6 3 3 3
expertise in Evaluating for effective database
management.
RDBMS 3.00 2.33 2.17

Qualitative 2.37 2.37 1.85 1.71

Attainment

Quantitative 2.33 2.33 1.81 1.69

Attainment
Direct 2.35 2.35 1.83 1.70
Attainment
 * Enter correlation levels 1, 2 or 3 as
defined below: 1: Slight (Low) 2:

100.00
Attainment Moderate (Medium)3: Substantial
% (High) and It there is no correlation,
put “-”
 GLOBAL INSTITUTE OF SCIENCE & TECHNOLOGY(An Institution of ICARE)
DEPT- COMPUTER SCIENCE & TECHNOLOGY(CS&T)
4th SEMESTER THEORETICAL SESSIONAL
Sl No. Name of the Student Registration Number OS ID CN SSE OOPUJ MP OS-LAB
DGITCSTS4
Number
1 ROHIT BISOI D212207630 20007631 BC BC CC BC CC AA AB
2 Suryakanta Jana D222310847 10008007 BB BC BC BC BC AA AA
3 DEVTANU SANDHAKI D222310848 10008008 BB BC BC BB BB AA AA
4 Arpita Pandit D222310849 10008009 AB AA BB AA AA AA AA
5 SANCHITA PAL D222310850 10008010 AB BB BC AB AB AA AA
6 SRIHARI SAMANTA D222310851 10008011 BC BB BC AB BC AA AA
7 KANTIMAY BAG D222310852 10008012 BB AB BC AB AB AA AA
8 PRAMIT JANA D222310853 10008013 BB BB CC AB BB AA AA
9 ANKIT CHAKRABORTY D222310854 10008014 BB AB BB AB AB AA AA
10 MAMPI MAITY D222310858 10008018 AB BB BB AB AB AA AA
11 Subham Patra D222310859 10008019 BB BB BC BB BC AA AA
12 SANTANU PATRA D222310860 10008020 BC BB BC BB BB AA AA
13 RISA SAMANTA D222310861 10008021 AB AA BB AB AA AA AA
14 Siddhanta Paul D222310862 10008022 BB BB BC BB BB AA AA
15 Subhadip Barik D222310863 10008023 AB BB BC BB BB AA AA
16 SHANKHA SHUBHRA DAS D222310866 10008026 BC AB BB BB AB AA AA
17 CHANDRANI HAZRA D222310868 10008028 BB BC BC AB BB AA AA
18 Sagar Kar D222310869 10008029 BB BC BC BB BB AA AA
19 MEHERAN NESA D222310870 10008030 AB AA BB AB AA AA AA
20 Gargi Das D222310871 10008031 AB AB BC AB AB AA AA
21 Misbahul Alam D222310876 10008036 BC BB BC BB BC AA AA
22 ARDHENDU DAS D222310877 10008037 BC BC BB BC BC AA AA
23 BARNALI JANA D222310878 10008038 BC BC BC BB BC AA AA
24 PRIYA DAS D222310880 10008040 BB BB BC AB AB AA AA
25 PRANOY SAHA D222310882 10008042 BB BB BB BC BB AA AA
26 MALLIKA PANJA D222310885 10008045 BB BB BC AB AB AA AA
27 PALLABI GIRI D222310890 10008050 BB BC BC BB BB AA AA
28 Sayan Samanta D222310891 10008051 BC AB BB BB AA AA AA
29 NILKAMAL HAZRA D222310892 10008052 BC BC BC BB BB AA AA
30 BEDIKA CHAUDHURY D222310893 10008053 BB AA BB AB AB AA AA
31 SONJU MAKAR D222310894 10008054 BC CC BC BC BC AA AA
32 Supriya Bhunia D222310895 10008055 BC BC BC BB BC AA AA
33 Debasmita Hazra D222310896 10008056 BB BC BC BB BC AA AA
34 Jeet Hait D222310897 10008057 BB BC BC BB BB AA AA
35 SOURISH MAHAPATRA D222310898 10008058 BB BC BC BC BC AA AB
36 TANMOY JANA D222310900 10008060 BC BC BC BB BB AA AA
37 ABANTIKA MANNA D222310904 10008064 BC CC BC BC BC AA AA
38 SUMANA MAITY D222310905 10008065 BB BB BC BC BB AA AA
39 RAHUL BAG D232413223 10027399 BC BC BC BB BC AA AA
40 Soumyajeet Das D232413224 10027400 AB AA BB AA AA AA AA
41 Sanchari Maiti D232413225 10027401 BB AB BB AB AB AA AA
42 SK ALAMGIR HOSSAIN D232413227 10027403 BB BC CC BB BC AA AA
43 PRITHA PATRA D212207622 10007623 BC CC BC CC BC AA AB
44 SUBHADEEP BHUNIA D212207642 10007643 BC CC BC BC CC AA AB
45 PRATAP KUMAR MANNAD222311123 10023333 BC CC CC CC CC AA AB
ICARE)

SESSIONAL Total Students:

ID-LAB CNLAB OOP-LAB GP %
45
AB AB AB 7.4 73
AA AA AB 8 79.3
AA AA AA 8.3 81.8
AA AA AA 9.6 91.9
AA AB AA 8.8 86.9
AA AA AA 8.3 81.6
AA AA AA 8.9 85.7
AA AA AA 8.4 82.3
AA AA AB 9 86
AA AA AA 9 88.6
AA AB AB 8.2 81
AA AA AA 8.3 85.1
AA AA AA 9.4 92.3
AA AB AA 8.4 82.1
AA AA AB 8.5 84.4
AA AA AA 8.7 84.2
AA AA AA 8.4 83.9
AA AB AA 8.2 80.6
AA AA AA 9.4 93.5
AA AA AB 9 86.5
AA AA AB 8.1 79.3
AA AA AB 8 81.2
AA AA AA 8 81.2
AA AB AA 8.7 85
AA AA AA 8.4 83.2
AA AA AA 8.7 85.4
AA AA AB 8.2 83
AA AA AA 8.9 85.9
AA AA AB 8.1 81.3
AA AA AA 9.1 90.7
AA AB AA 7.7 77
AA AB AB 7.9 79.1
AA AA AA 8.1 82
AA AA AB 8.2 83.9
AA AA AB 7.9 78.6
AA AB AA 8.1 80.9
AA AB AB 7.6 77.8
AA AA AA 8.3 83.2
AA AA AB 8 78.9
AA AA AA 9.6 93.7
AA AA AA 9 89.2
AA AB AA 8 79.1
AB AB AB 7.4 74.7
AA AB AB 7.4 74.3
AA AA AB 7.2 72.7
 Analysis on previous attainments and setting targets on CO attainments for current semester subjec

Attainment
Course Outcome Target for Level of Current Gap
Current Exam Year (2023)

CO1 3 2.45 0.55

CO2 3 2.30 0.70

CO3 3 2.40 0.60

CO4 3 2.40 0.60

CO5 3 2.41 0.59

CO6 3 2.26 0.74

s attainments and setting targets on CO attainments for current semester subjects.

Gap Analysis Actions Taken

Improvement observed in defining problems at the view Introduced additional tutorials focusing on
level and understanding the database's physical structure, fundamental database concepts and structural
but a gap remains in comprehensive retention. understanding.

Students demonstrate difficulty in applying ERD tools for Organized supplementary sessions on Entity-
database schema design, reflecting a need for enhanced Relationship (ER) diagrams and provided real-life
practical exercises. schema design examples.

Minor challenges in formulating relational algebra Implemented targeted hands-on query exercises
solutions for diverse queries, indicating a gap in and incorporated real-world scenarios to
application-level problem-solving skills. improve relational algebra proficiency.

Limited ability to formulate SQL queries for practical Conducted lab sessions emphasizing SQL query
applications, requiring additional exposure to structured formulation with guided problem-solving
problem-solving techniques. activities.

Understanding and analyzing functional dependencies Added detailed practical assignments on

and database normalization require further skill-building functional dependencies and normalization
for better conceptual clarity and analysis. techniques using case studies.

Students struggle to evaluate transaction systems and Included workshops focusing on transaction
optimize SQL queries, showing challenges in cognitive management, optimization techniques, and
levels of evaluation and synthesis. performance-based query execution.
 Uint Plan
Unit No. Unit Title

1 Introduction to Databases and DBMS

2 Database Models and DBMS

Architecture

3 Entity-Relationship (ER) Diagrams

4 Relational Algebra

5 SQL Fundamentals

Normalization and Functional

6 Dependencies

7 Database Integrity and Constraints

Transaction Management and

8 Recovery
 Uint Plan
Topics Covered COs Mapped Bloom's Level
- Definition of a Database and DBMS
- Types of Databases (Hierarchical, Network, Relational) Remembering,
CO1, CO2 Understanding
- Overview of Database Management System components: Data Models,
DBMS architecture,
- Concept DBMS
of Database functions
Models
- Relational Model Basics
- Components of DBMS Architecture: Database engine, Query processor, CO1, CO2, CO5 Understanding, Analyzing
etc.
Data Independence
- Definition and importance of ER Models
- Entities, Attributes, Relationships CO2, CO4 Understanding, Applying
- Cardinality, Participation constraints
- Mapping ER models to relational schemas
- Basic Operations in Relational Algebra: Select, Project, Union,
Difference, Cartesian Product, Join CO3 Applying
- Relational algebra expressions for query execution

- Overview of SQL
- Basic SQL syntax: SELECT, INSERT, UPDATE, DELETE CO4 Applying
- Data Retrieval: SELECT queries, WHERE clause, ORDER BY, LIMIT

- Normalization concepts: 1NF, 2NF, 3NF, BCNF

- Definition and examples of Functional Dependencies CO5 Analyzing
- Design principles for database normalization

- Types of constraints: Primary Key, Foreign Key, Unique, Check CO5, CO6 Analyzing, Evaluating
- Data integrity concepts: Entity, Referential, Domain integrity
- Introduction to Transactions: ACID properties
- Transaction lifecycle: Begin, Commit, Rollback CO6 Evaluating
- Recovery methods and techniques
Teaching Hours

6
 Date Session No. Unit Title Topics Covered COs Covered
July 1, 2024 Session 1 Introduction to Databases Overview of DBMS, Types of Databases CO1
and DBMS to Databases
Introduction
July 3, 2024 Session 2 DBMS Components, DBMS Functions CO1, CO2
and DBMS
July 8, 2024 Session 3 Database Models and Database Models, DBMS Architecture CO1, CO2
DBMS Architecture
Database Models and Overview
July 10, 2024 Session 4 Data Independence, DBMS Components CO2, CO5
DBMS Architecture
Entity-Relationship (ER) Entities, Attributes, Relationships,
July 15, 2024 Session 5 CO2
Diagrams
Entity-Relationship (ER) Cardinality
Mapping ER Models to Relational
July 17, 2024 Session 6 CO2, CO4
Diagrams Schemas
Basic Operations: Select, Project, Union,
July 22, 2024 Session 7 Relational Algebra CO3
Join
July 24, 2024 Session 8 Relational Algebra Query Expressions in Relational Algebra CO3
July 29, 2024 Session 9 SQL Fundamentals Introduction to SQL, SELECT, INSERT, CO4
UPDATE, DELETE
Data Retrieval: SELECT Queries, WHERE
July 31, 2024 Session 10 SQL Fundamentals CO4
Clause
August 5, 2024 Session 11 SQL Fundamentals Joins, Subqueries, Aggregate Functions CO4
Data Manipulation: INSERT, UPDATE,
August 7, 2024 Session 12 SQL Fundamentals DELETE CO4
Normalization and
August 12, 2024 Session 13 Functional Dependencies Introduction to Normalization, 1NF, 2NF CO5
Normalization and
August 14, 2024 Session 14 Functional Dependencies 3NF, BCNF, Functional Dependencies CO5
Normalization and
August 19, 2024 Session 15 Functional Dependencies Practical examples of normalization CO5
Database Integrity and Primary Key, Foreign Key, Unique
August 21, 2024 Session 16 Constraints Constraints CO5, CO6
Database Integrity and
August 26, 2024 Session 17 Constraints Check Constraints, Data Integrity CO5, CO6
Transaction Management Introduction to Transactions: ACID
August 28, 2024 Session 18 and Recovery Properties CO6
### Session 19 Transaction Management Transaction Lifecycle, Commit, Rollback CO6
and Recovery
Transaction Management Recovery Techniques, Concurrency
### Session 20 CO6
and Recovery
Introduction to Databases Control
Review of DBMS Components and
### Session 21 CO1, CO2
and DBMSModels and
Database Architecture
### Session 22 Recap of DBMS Models and Architecture CO1, CO5
DBMS Architecture (ER)
Entity-Relationship Review ERD Design and Mapping to
### Session 23 CO2, CO4
Diagrams Relational
Relational Models
Algebra Review and Query
### Session 24 Relational Algebra CO3
Practice
### Session 25 SQL Fundamentals SQL Query Practice Session CO4
### Session 26 SQL Fundamentals Advanced SQL Queries, Subqueries CO4
### Session 27 Normalization and Recap of Normalization, Functional CO5
Functional Dependencies
Database Integrity and Dependencies
October 2, 2024 Session 28 Constraints Review and Case Studies CO5, CO6
Constraints
Transaction Management
October 7, 2024 Session 29 Transaction Concepts and Review CO6
and Recovery
Transaction Management
October 9, 2024 Session 30 Transaction Recovery Methods CO6
and Recovery CO1, CO2,
October 14, 2024 Session 31 Review of All Units Comprehensive Review of Database CO3,
Design, Query Optimization CO1, CO4,
CO2,
CO5,
CO3, CO6
October 16, 2024 Session 32 Review of All Units Practical Queries, Design Challenges CO1, CO4,
CO2,
CO5,
CO3, CO6
CO4,
October 21, 2024 Session 33 Final Exam Preparation Revision and Mock Test CO1,
CO5, CO2,
CO6
October 23, 2024 Session 34 Final Exam Preparation Focused Revision on Key Topics CO3,
CO1, CO4,
CO2,
CO5,
CO3, CO6
CO4,
October 28, 2024 Session 35 Final Exam Final Exam on RDBMS Course
CO5, CO6
Teacher's Sign Principal's Sign