DS0-001 practice question 4 of 15

A database administrator is updating an organization's ERD. Which of the following is the best option for the database administrator to use?

Full set: 80 questions
Answer options
A: Word processor
B: Spreadsheet
C: UML tool Correct answer
D: HTML editor
Correct Answer:
C. UML tool
Explanation

An Entity-Relationship Diagram (ERD) is a specialized, structured diagram used in database design to model entities, their attributes, and the relationships between them. A UML (Unified Modeling Language) tool is the most appropriate choice as it is specifically designed for creating and managing such formal diagrams. These tools provide the correct notations (e.g., for entities, relationships, cardinality) and often include features for validation, version control, and even generating SQL Data Definition Language (DDL) from the model. This makes them far superior to general-purpose applications for this specific database administration task.

Why Incorrect

A. Word processor: A word processor is designed for text documents and lacks the specialized features, constraints, and notations needed for accurate and efficient ERD creation.
B. Spreadsheet: A spreadsheet is optimized for organizing and calculating tabular data; it is not a diagramming tool and is unsuitable for modeling database structures.
D. HTML editor: An HTML editor is used for coding web pages. It has no functionality relevant to database design or creating visual schema models like ERDs. ---

References

1. Garcia-Molina

H.

Ullman

J. D.

& Widom

J. (2009). Database Systems: The Complete Book (2nd ed.). Pearson Prentice Hall. In Chapter 4

Section 4.5

"Unified Modeling Language

" the text discusses how UML

particularly its class diagrams

is a common and powerful tool used for database design

stating

"There are many other notations for database design... Perhaps the most common today are... UML..." (p. 148).

2. Elmasri

R.

& Navathe

S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. Chapter 9

Section 9.1

discusses relational database design using ER-to-Relational mapping

a process best supported by CASE (Computer-Aided Software Engineering) tools. The text notes

"A variety of CASE tools are available for designing databases... These tools often use a variation of the ER or EER notation..." (p. 291). Modern UML tools are a primary category of such CASE tools.

3. Object Management Group. (2017). OMG Unified Modeling Language (OMG UML)

Version 2.5.1. OMG Document Number formal/2017-12-05. Section 11

"Structured Classifiers

" details the components of class diagrams

which are the UML equivalent used for modeling data structures like those in an ERD. This specification underpins the functionality of UML tools. (Available at https://www.omg.org/spec/UML/2.5.1/PDF)

Scroll to Top