WGU C175 Data Management
Foundations Q u e s t i o n s a n d A n s w e r s
1. ad hoc query: A "spur-of-the-moment" question
2. analytical database: A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making
3. availability: In the context of data security, it refers to the accessibility of data whenever required
by authorized users and for authorized purposes
4. centralized database: A database located at a single site
5. cloud database: A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS
6. data: Raw facts, or facts that have not yet been processed to reveal their meaning to the end user
7. data anomaly: An abnormality of the data in which inconsistent changes have been made to
a database (For example, an employee moves, but the address changes is not corrected in all files in
the database)
8. data dependence: A data condition in which data representation and manipulation are
,dependent on the physical data storage characteristics
9. data dictionary: A DBMS component that stores metadata. Contains the data definition,
as well as their characteristics and relationships
10. data inconsistency: A condition in which ditterent versions of the same data yield
ditterent results
11. data independence: A condition in which data access is unattected by changes in the
physical data storage characteristics
12. data integrity: In a relational database, a condition in which the data in the database
complies with all entity and referential integrity constraints
13. data management: A process that focuses on data collection, storage, and retrieval.
14. data processing (DP) specialist: The person responsible for developing and
managing a comput- erized file processing system
15. data redundancy: Exists when the same data is stored unnecessarily at ditterent
places
16. database: A shared, integrated computer structure that houses a collection of related data
including end-user data (raw facts) and metadata (data about the data)
, 17. database design: The process that yields the description of the database structure
and determines the database components. The second phase of the database life cycle
18. database management system (DBMS): The collection of programs that
manages the database structure and controls access to the data stored in the database
19. database system: An organization of components that defines and regulates the
collection, storage, management, and use of data in a database environment
20. desktop database: A single-user database that runs on a personal computer
21. discipline-specific database: A database that contains data focused on specific
subject areas
22. enterprise database: The overall company data representation, which provides
support for present and expected future needs
23. field: An alphabetic or numeric character or group of characters that defines a characteristic
of a person, place, or thing. (for example, a person's SSN, address, phone number, and bank balance
all constitute fields)
24. file: A named collection of related records
25. general-purpose database: A database that contains a wide variety of data used in
Foundations Q u e s t i o n s a n d A n s w e r s
1. ad hoc query: A "spur-of-the-moment" question
2. analytical database: A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making
3. availability: In the context of data security, it refers to the accessibility of data whenever required
by authorized users and for authorized purposes
4. centralized database: A database located at a single site
5. cloud database: A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS
6. data: Raw facts, or facts that have not yet been processed to reveal their meaning to the end user
7. data anomaly: An abnormality of the data in which inconsistent changes have been made to
a database (For example, an employee moves, but the address changes is not corrected in all files in
the database)
8. data dependence: A data condition in which data representation and manipulation are
,dependent on the physical data storage characteristics
9. data dictionary: A DBMS component that stores metadata. Contains the data definition,
as well as their characteristics and relationships
10. data inconsistency: A condition in which ditterent versions of the same data yield
ditterent results
11. data independence: A condition in which data access is unattected by changes in the
physical data storage characteristics
12. data integrity: In a relational database, a condition in which the data in the database
complies with all entity and referential integrity constraints
13. data management: A process that focuses on data collection, storage, and retrieval.
14. data processing (DP) specialist: The person responsible for developing and
managing a comput- erized file processing system
15. data redundancy: Exists when the same data is stored unnecessarily at ditterent
places
16. database: A shared, integrated computer structure that houses a collection of related data
including end-user data (raw facts) and metadata (data about the data)
, 17. database design: The process that yields the description of the database structure
and determines the database components. The second phase of the database life cycle
18. database management system (DBMS): The collection of programs that
manages the database structure and controls access to the data stored in the database
19. database system: An organization of components that defines and regulates the
collection, storage, management, and use of data in a database environment
20. desktop database: A single-user database that runs on a personal computer
21. discipline-specific database: A database that contains data focused on specific
subject areas
22. enterprise database: The overall company data representation, which provides
support for present and expected future needs
23. field: An alphabetic or numeric character or group of characters that defines a characteristic
of a person, place, or thing. (for example, a person's SSN, address, phone number, and bank balance
all constitute fields)
24. file: A named collection of related records
25. general-purpose database: A database that contains a wide variety of data used in
