STUPIDSID
Write a short note on the following:
1 (a)
Object ID and type constructor.
5 M
1 (b)
Weak entity set in ER diagram.
5 M
1 (c)
Data mart and data warehouse.
5 M
1 (d)
Trigger in SQL.
5 M
2 (a)
R=(A, B, C, D, E)
This relation R is decomposed into
R1={A, B, C}
R2={A, D, E}
Show that the decomposition if following functional dependencies hold
FD={A ?BC, CD?E, B?D, E?E}
This relation R is decomposed into
R1={A, B, C}
R2={A, D, E}
Show that the decomposition if following functional dependencies hold
FD={A ?BC, CD?E, B?D, E?E}
10 M
2 (b)
Explain parallel database with advantages and dis-advantages.
10 M
3 (a)
Write a short note on constraints on database.
10 M
3 (b)
Define primary key, super key, candidate key and functional dependencies.
10 M
4 (a)
Describe design and implementation issues in mobile database.
10 M
4 (b)
Explain fragmentation in distributed database with proper example.
10 M
5 (a)
Differentiate between OLTP and OLAP.
10 M
5 (b)
Explain rules of mapping ER diagram to relational model.
10 M
6 (a)
Nested relations in ORDBMS.
10 M
6 (b)
Differentiate RDBMS, ORDBMS, CODBMS.
10 M
Write short notes on the following:
7 (a)
Temporal Database.
5 M
7 (b)
Specialization and generalization
5 M
7 (c)
Replication in distributed database.
5 M
7 (d)
BCNF.
5 M
More question papers from Database Technologies