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