Dimensions of data quality Flashcards
refers to the extent to which all required data elements are present in a dataset. It ensures that there are no missing values or gaps in the data.
Completeness
Example: A customer database should include all necessary fields such as name, address, email, and phone number for each customer record. If some customer records are missing phone numbers, the dataset is incomplete.
Completeness
refers to the degree of correctness and precision of the data. It ensures that the data values are true representations of the real-world entities or events they describe.
Accuracy
In a medical database, the accuracy of patient height and weight measurements is crucial for calculating body mass index (BMI) accurately. Incorrect measurements can lead to wrong assessments of patients’ health status.
Accuracy
refers to the absence of discrepancies or contradictions within a dataset or between different datasets. It ensures that data values are uniform and coherent across the entire dataset.
Consistency
In a sales database, the product prices should be the same across all sales transactions. If the same product has different prices in different transactions, it indicates____in the dataset.
Consistency
refers to the degree to which the data accurately represents the real-world concepts or entities it is intended to describe. It ensures that the data is relevant and meaningful for its intended purpose
Validity
In a survey dataset, the survey responses depend on the accuracy and relevance of the questions asked. If the survey questions are poorly designed or ambiguous, the ____of the responses may be compromised.
Validity
refers to the absence of duplicate or redundant data records within a dataset. It ensures that each data record represents a distinct entity or event.
Uniqueness
In a customer database, each customer should be represented by a one customer ID. If multiple records have the same customer ID or if there are duplicate customer records, it violates the _____of the dataset.
Uniqueness
refers to the overall reliability and trustworthiness of the data. It ensures that the data is protected against unauthorized access, modification, or corruption, and that it maintains its accuracy and consistency over time.
Integrity
Implementing data encryption and access controls to prevent unauthorized users from tampering with sensitive data in a financial database helps maintain ____. Additionally, implementing data validation rules and error-checking mechanisms helps ensure the ____ of data entry processes.
Integrity
An inventory database for a retail store should contain all products currently available for sale, including product name, description, price, and quantity in stock.
Completeness
A financial database tracks transactions for a bank. The accuracy of transaction amounts is essential for calculating account balances and detecting fraudulent activity. If transaction amounts are entered incorrectly, it can lead to errors in financial reporting.
Accuracy
An employee database records job titles for all staff members. Inconsistencies in job title abbreviations (e.g., “Mgr” vs. “Manager”) make it challenging to generate accurate reports on employee roles and responsibilities.
consistency
