STUPIDSID
1 (a)
Explain the potential problems with DDBMS.
7 M
1 (b)
Explain Top Down Design Process for Distributed Database Design.
7 M
2 (a)
Explain following in context of Relational algebra :
1. Selection 2. Natural Join 3. Intersection
1. Selection 2. Natural Join 3. Intersection
7 M
2 (b)
What are the objectives of Query processing?
7 M
2 (c)
Explain layers of Query processing.
7 M
3 (a)
Consider following relations
employee (person-name, street, city)
works(person-name. company-name, salary)
company(company-name, city)
manages(person-name,, manager-name)
Write following query in relational algebra form.
(1) Find names of all employees who work for HDFC.
(2) Find the names of all employees who live in the same city as the company for which they work.
(3) Find names and cities of residence of all employees who do not work for HDFC and earn more than Rs 10 lac per year.
employee (person-name, street, city)
works(person-name. company-name, salary)
company(company-name, city)
manages(person-name,, manager-name)
Write following query in relational algebra form.
(1) Find names of all employees who work for HDFC.
(2) Find the names of all employees who live in the same city as the company for which they work.
(3) Find names and cities of residence of all employees who do not work for HDFC and earn more than Rs 10 lac per year.
7 M
3 (b)
What is fragmentation? Why it is needed? What are the correctness rules for
Fragmentation?
7 M
3 (c)
What do you mean by distributed semantic integrity control? Explain with
Example.
7 M
3 (d)
Describe BEA algorithm used in vertical fragmentation.
7 M
4 (a)
What is Query Optimization? List the components of Query Optimizer
software and explain any one.
7 M
4 (b)
Explain the first phase of Query processing that transforms a relational calculus query into a relational algebra query.
7 M
4 (c)
What is allocation? List and explain the information requirements during
Allocation.
7 M
4 (d)
Explain Distributed cost model with suitable example and determine total time
as well as response time.
7 M
5 (a)
List various Transaction Models. Explain any two in detail.
7 M
5 (b)
Discuss fundamental issues in distributed database design. Give at least 3
differences between replicated and Partitioned database.
7 M
5 (c)
Write short note on: MDBS architecture.
7 M
5 (d)
Write short note on: Two Phase Commit Protocol for Distributed Transactions.
7 M
More question papers from Distributed Database Application & System