| Year/Subject | Database Management System | ||
| Easy | Medium | Difficult | |
| 2015 MARCH-CS Scientist-C | 1.BCNF 2.Associativity |
1.Functional dependency(2) | 1.Normal Forms |
| 2016 MARCH-CS/IT/EC-STA | 1.DML 2.Relational database |
1.File system | — |
| 2016 MARCH-CS/IT-Scientist-B | 1.Transaction management 2.File structures(2) 3.Relational Schema(2) |
1.Relational Schema 2.Functional Dependency 3.Normal Forms |
— |
| 2016 DEC-IT-Scientist-B | 1.Normalization 2.Relational model 3.Keys 4.Functional depen dency 5.Relational algebra 6.Normal forms 7.ER Diagrams |
1.Relational Schema | — |
| 2016 DEC-CS-Scientist-B | 1.Relational schema(2) | 1.ER diagrams 2.Functional dependency 3.Relational database |
— |
| 2017 JULY-IT-Scientist-B | 1.File structures 2.Relational model (3) 3.SQL |
1.Cartesian product/ Relational model 2.ER Diagram cardinality 3.Relational data model |
— |
| 2017 JULY-CS-Scientist-B | 1.File structures | 1.Transaction management | — |
| 2017 OCT-CS-SA | 1.SQL 2.ER models 3.Associativity |
1.SQL | — |
| 2017 OCT-IT-SA | 1.Relational algebra | 1.Normal forms 2.SQL |
— |
| 2017 DEC-CS/IT-STA | — | — | — |
| 2017 DEC-CS/IT-Scientist-B | 1.2-Phase locking 2.Normal forms 3.Total participation |
1.Normal forms 2.FD 3.Functional dependency(Normal Forms) |
— |
| 2018 DEC-CS/IT-STA | 1.Domain integrity 2.Transaction Integrity 3.B+ Tree 4.Keys 5.locks 6. SQl query parser |
— | — |
| 2018 DEC-CS/IT-Scientist-B | 1.ER model diagram 2.Relational Schema 3.Terminal symb ol(Permanent memory) 4.Normalization(2) 5.B+ Trees 6.On-delete cascade 7.ACID properties |
— | — |
