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!
A distributed database is defined as "a collection of multiple logically interrelated database which are physically distributed over a computer network"
(a) Give any three advantages of implementing a distributed database system.
(b) Provide any two difficulties that database designer has to face when implementing a distributed database system.
(c) The components of a Distributed Database include the following: Network Processor, Remote data processor, Data dictionary, and local data processor. Explain the function of each of the above components.
(d) Differentiate between a Homogeneous Distributed Database and a Heterogeneous Distributed Database.
(e) In the context of distributed database, explain the term „Fragmentation?
(f) Briefly discuss why data fragmentation could be useful in such distributed database systems, and explain each of the following fragmentation rules:
- Completeness- Reconstruction- Disjointness
Define the terms i) Entity type ii) Entity set Entity type: An entity type describes a collection of entities that have the similar attributes. Entity set: The set of all en
Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password
What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base
WHAT IS DBMS
Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)
Hardware failure : Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and
What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among
I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each
Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui
Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come
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