18 Questions
What is meant by structural dependence?
A data characteristic where a change in the database schema affects data access, requiring changes in all access programs
What does 'extensive programming' refer to in the context of a file system data repository?
The difficulty in making changes to an existing file structure
Which of the following best describes structural independence?
A data characteristic where a change in the database schema does not affect data access
What is meant by data dependence?
A data condition in which data representation and manipulation are dependent on the physical data storage characteristics
What is the primary advantage of structural independence over structural dependence?
Ease of making changes to the existing file structure without extensive programming
Which of the following best describes data independence?
A condition in which data access is unaffected by changes in the physical data storage characteristics
What is a data anomaly?
A situation where inconsistent changes have been made to a database
What is a common cause of data-entry errors?
Complex entries made in several different files or recurring frequently in one or more files
What is an example of a data integrity problem?
Entering a nonexistent sales agent's name and phone number into the Customer file
What is structural independence?
The ability to change the database structure without changing the application programs that access the data
What is data dependence?
The inability to change the database structure without changing the application programs that access the data
What is data independence?
The ability to change data without changing the application programs that access the data
What is the primary role of a Database Management System (DBMS)?
To manage the database structure and control access to data
Which of the following is NOT an advantage of using a DBMS?
Extensive programming required
What is structural independence in the context of a DBMS?
The ability to change the database structure without affecting the application programs
What is data independence in the context of a DBMS?
The ability to change the data without affecting the database structure or application programs
What is the difference between data and information in the context of a database?
Data is raw facts, and information is the result of processing raw data
What is the primary function of metadata in a database?
To manage and integrate end-user data
Learn about the typical faults associated with file system data repositories, including lack of security, limited data sharing, extensive programming requirements, and structural dependence issues.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free