The assignment content discusses various aspects of a global database system, including its logical description of the whole database, providing physical and logical data independence, and improving efficiency by splitting large tables across separate disks.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
1. True. 2. True 3. The global database system catalog is logical description of whole database, if it is not in disrupted form. It contains the definition of entities that are the tables in database, relationship among the table along with its type, constraints and security. The function of global database system is that it provides the physical data independence from the distributed environment and it also provides the logical data independence. 4. Splitting a large heavily heavily used table across devices on separate physical disks will improve the efficiency because when all the tables on the same disk it will take time to scan whole database one by one but when they are separated on the different disks system will search the data on all the disks simultaneously and produce the result in minimum time. 5. True