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:
In relation to distributed database answer the following questions:
(i) Give a brief definition of distributed database. Support your answer with an appropriate diagram that shows the major component of the distributed database.
(ii) Differentiate between homogeneous distributed database and heterogeneous database system and explain which one will be appropriate for a company which has been using a database for the past 30 years and who now, wants to implement a distributed database.
(iii) Describe briefly two transparency features that exist in a distributed database environment.
(iv) Differentiate between horizontal partitioning and mixed partitioning with appropriate example.
(v) Briefly describe any three advantages of replication.
What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.
There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag
Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured
What does the cardinality ratio specify? Mapping cardinalities or cardinality ratios state the number of entities to which another entity can be associated. Mapping cardinaliti
Define the basic operations of the relational algebra? Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot
Failures and Recovery In practice various things might occur to prevent a transaction from completing. Recovery methods are used to bring database, which does not satisfy consi
Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c
What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa
Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont
Winfield is a small city with a population of 22,000 with buses serves three routes in Winfield and neighboring areas. As the city’s IT director, you have been asked to set up an i
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