STUPIDSID
1 (a)
Define specialization and Generalization with an example.
5 M
1 (b)
Write about Aggregate Function in SQL.
5 M
1 (c)
Discuss Referential Integrity Constraints.
5 M
1 (d)
Explain Total Participation and Partial Participation with example.
5 M
2 (a)
Explain the following Relational Algebra Operations with example:-
i) Set Intersection
ii) Division Operator
iii) Generalized Projection
iv) Natural join
i) Set Intersection
ii) Division Operator
iii) Generalized Projection
iv) Natural join
10 M
2 (b)
Draw an ER Diagram for a banking enterprise. Convert it into relational model.
10 M
3 (a)
What is Normalization? Explain INF, 2NF, 3NF and BCNF giving examples.
10 M
3 (b)
What is an attributes? Discuss various types of attributes with examples.
10 M
4 (a)
Explain sort-merge join algorithm in query processing.
10 M
4 (b)
Describe conflict serializability and view serializability with example.
10 M
5 (a)
Explain database system architecture in detail.
10 M
5 (b)
What do you mean by Data Modelling? Discuss different types of Models.
10 M
Write short notes on:
6 (a)
ACID Properties
5 M
6 (b)
Steps in Query Processing.
5 M
6 (c)
Data Control Command in SQL
5 M
6 (d)
Security in Database.
5 M
More question papers from Database Management Systems