Database System Fundamentals


Added on  2019-09-18

1 Pages151 Words308 Views
1. True.2. True3. 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 whenthey 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
Database System Fundamentals_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Understanding Storage Architectures

Database Systems and SQL Concepts

Database Design and Implementation

Data Modelling: Conceptual, Logical and Physical Models

Disaster Planning and Database Backup: Assignment

Logical and Physical Database Design and DBMS Functions