(a) What are advantages and disadvantage of Distributed DBMS.

(b) What are the features of DDBMS?

(c) Explain the basic Timestamp Ordering Algorithm.

(d) What are the objectives of Distributed Query Processing?

(a) What is horizontal and vertical fragmentation? What are the types of horizontal fragmentation. Perform horizontal fragmentation for student relation as given below. Also give the correctness criteria for it. Student (Studentrollno., StudentName, CourseNarne, Course Fees, year).

(b) What are the various kinds of transparencies in distributed database design? Explain each with the help of an example.

(a) What are the various concurrency control techniques? Compare Lock based Concurrency Control strategies in detail.

(b) Compare Distributed Deadlock prevention to Distributed Deadlock Avoidance Explain one scheme of Distributed deadlock Detection and Recovery.

(a) A banking database should contain the customer's information along with the types of accounts customer is maintatining. Customer information is its full profile information along with his current address, PAN ID, adhar Card no included and account information should include type of account (Saving, fixed, demat, recuring, current), date and time of access and the transactions details.

• (i) Write the DTD rules for the above XML documents.
• (ii) Create an XML schema for the above XML document.

(b) What are homogenous and heterogeneous database. Give the architecture of heterogeneous databases along with some query processing issues.

(a) What problems can occur in a distributed system due to the failure of link? What are the ways by which recovery can take place?

(b) Explain the phases of query processing in distributed database.

(a) Bond Energy Algorithm

(b) Design issues of Distributed Database

(c) 3PC

(d) Transaction management model for distributed System.