When designing a relational database, which field setup best reflects the user's use of atomic-level data?
A) Age and sex are listed in one field.
B) First and last names are in separate fields.
C) Systolic and diastolic blood pressures are key fields.
D) First and last names are in one field with first name also in a separate field.

Question

Quizplus · Accepted Answer

Atomic-level data refers to the practice of breaking down information into the smallest useful pieces. By having first and last names in separate fields, the database can more easily and flexibly manage, search, and manipulate these individual pieces of data, adhering to the principle of atomicity in database design.

When Designing a Relational Database, Which Field Setup Best Reflects