STUPIDSID
1 (a)
Explain properties of Transactions.
7 M
1 (b)
Explain MDBS architecture with and without GCS.
7 M
2 (a)
What is transparency? Explain layers of transparency in DDBS.
7 M
2 (b)
What do you mean by normalization? Explain 3rd and BCNF Normal form.
7 M
2 (c)
Explain the following terms: protocol standards.broadband networks, wireless network and Internet protocols.
7 M
3 (a)
Derive simple predict,minterms and form that find out all possible Horizontal Fragments for the following:
Consider relation Proj(PNo., Pname, Budget, Loc) assume two applications will run on different sites, First application select names and budgets of projects given their location and it will run on three sites, second application run on two sites and manage project having budget less than Rs.2,00,000 on one site and higher to these are managed at other site.
Consider relation Proj(PNo., Pname, Budget, Loc) assume two applications will run on different sites, First application select names and budgets of projects given their location and it will run on three sites, second application run on two sites and manage project having budget less than Rs.2,00,000 on one site and higher to these are managed at other site.
7 M
3 (b)
Discuss attribute affinity matrix, CA matrix, BEA algorithm in the context of vertical fragmentation with example.
7 M
3 (c)
Explain distributed semantic integrity control with example.
7 M
3 (d)
For given query draw Query graph and join graph also rewrite the query and draw rewritten operator tree.
'Find the names and responsibility of programmer who have been working on the CAD/CAM project for more than 3 years and their manager's name.'
'Find the names and responsibility of programmer who have been working on the CAD/CAM project for more than 3 years and their manager's name.'
7 M
4 (a)
Draw Block diagram of TOP-DOWN design process and explain.
7 M
4 (b)
Explain with an example reduction for primary horizontal fragmentation.
7 M
4 (c)
Explain distributed cost model with example.
7 M
4 (d)
Explain Hybrid fragmentation with an example.
7 M
5 (a)
Explain example explain workflow during transaction.
7 M
5 (b)
Explain Client/Server Architecture for DDB, with its merit and demerits.
7 M
5 (c)
Explain with diagram Layers of query processing?
7 M
5 (d)
Write short note on Parallel database system.
7 M
More question papers from Distributed Database Application & System