DS0-001 · Question #46
A database professional is considering denormalizing a database. Which of the following documents should be used to analyze the database's structure?
The correct answer is D. ERD. An Entity Relationship Diagram (ERD) is the correct tool because it visually maps tables, columns, primary/foreign keys, and relationships between entities - exactly what you need to analyze structure before deciding how to denormalize. SOPs (A) are procedural documents describin
Question
A database professional is considering denormalizing a database. Which of the following documents should be used to analyze the database's structure?
Options
- ASOP
- BData dictionaries
- CUML diagrams
- DERD
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D84% (21)
Explanation
An Entity Relationship Diagram (ERD) is the correct tool because it visually maps tables, columns, primary/foreign keys, and relationships between entities - exactly what you need to analyze structure before deciding how to denormalize. SOPs (A) are procedural documents describing how to perform tasks, not data structure. Data dictionaries (B) describe individual fields and their metadata but don't show how tables relate to one another structurally. UML diagrams (C) model software objects and behavior, not relational database schema.
Memory tip: ERD = "Entity Relationship Diagram" - the word relationship is your clue that it shows how data structures connect, making it the go-to for any structural database analysis.
Topics
Community Discussion
No community discussion yet for this question.