Certified Data Management Professional – Fundamentals (CDMP) — Question 67

First Normal Form:

Answer options

• A. Ensures that each attribute has a balanced proportion of neutrons and protons
• B. Ensures that each entity has no hidden primary keys
• C. Ensures that the Party Role structure is correctly represented
• D. Ensures that each attribute is atomic without repeating groups
• E. Ensures that each attribute has a definition that makes sense

Correct answer: D

Explanation

The correct answer is D because First Normal Form requires that all attributes in a database table are atomic, meaning they cannot contain multiple values or repeating groups. Options A, B, C, and E do not accurately describe the requirements of First Normal Form, as they relate to other aspects of database design.