Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question
(a) Differentiate between the following terms:
(i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Heterogeneous Distributed Database
(b) Explain the following terminologies with regard to Distributed Database.
(i) Fragmentation (ii) Replication (iii) Transparency
(c) In the context of distributed database management systems, explain the following fragmentation rules and support your answer with an appropriate example of a Horizontal Fragmentation:
(i) Completeness (ii) Reconstruction (iii) Disjointness
What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs
growing phase and shrinking phase are disjoint, why ?
A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh
Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further
What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number
Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def
Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,
What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters
Logical Operators Rules of Precedence: Order evaluated Operator 1 All comparison operators 2
Properties of a Transaction A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd