IDB Flashcards
(19 cards)
What is a file system?
A method for managing data using collections of files stored on a storage device.
What are the problems associated with file systems?
Data redundancy, data anomalies, time-consuming management, complex administration.
Define data redundancy.
The existence of duplicate data in multiple places, leading to inconsistency.
What are the types of data anomalies?
- Update anomalies
- Insertion anomalies
- Deletion anomalies
Explain the importance of database design.
Defines expected database use, avoids redundant data, prevents errors.
What are the components of a database environment?
- Hardware
- Software
- Operating system software
- DBMS software
- Application programs and utility software
- People
- Procedures
- Data
What is the function of a DBMS?
To guarantee integrity and consistency of data.
What does data dictionary management in a DBMS do?
Defines data elements and their relationships.
What is the role of data storage management in a DBMS?
Stores data and related data entry forms, report definitions, etc.
What is multiuser access control in a DBMS?
Ensures multiple users can access the database concurrently without compromising integrity.
Fill in the blank: Data redundancy results in data _______.
[inconsistency]
True or False: Manual file systems are effective for large amounts of data.
False
What are the disadvantages of file-based systems?
- Requires extensive programming
- System administration is complex
- Making changes is difficult
- Security features are often inadequate
- Redundant data present
What is backup and recovery management in a DBMS?
Provides procedures for data backup and recovery.
What does data integrity management promote?
Enforcement of integrity rules within the database.
What is the purpose of database communication interfaces?
Allow databases to accept end-user requests via different network environments.
What leads to the creation of ‘home-grown’ systems?
The complexity of converting manual systems to computer systems.
List the consequences of poorly designed databases.
- Generates errors
- Leads to bad decisions
- Can lead to organizational failure
What is the significance of understanding file system characteristics?
It makes database design easier to understand and helps prevent similar problems in DBMS.
