A database administrator would like to address data inconsistencies, define conventions to be used across the organization, make data easier to analyze, and enforce the use of data standards. Which of

Question

Options

• AEntity relationship diagram
• BData dictionary
• CWord processor
• DUnified modeling language

• A
  8% (2)
• B
  83% (20)
• C
  4% (1)
• D
  4% (1)

Explanation

A data dictionary is a centralized repository that documents data definitions, formats, relationships, and standards - making it the ideal tool for addressing inconsistencies, enforcing conventions, and improving data analysis across an organization. An entity relationship diagram (A) visualizes relationships between database entities but does not enforce standards or define organizational conventions. A word processor (C) is a general-purpose writing tool with no data management or standardization capabilities. Unified Modeling Language (D) is used for software system design and modeling, not for managing data definitions or enforcing data standards.

Memory tip: Think of a data dictionary as the rulebook for your data - it tells everyone in the organization what data means, how it should be formatted, and how it should be used consistently.

No community discussion yet for this question.