Question 240
A data architect recommends this approach: Replace repeating product lists with atomic values represented in related rows. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for First normal form. The schema avoids storing multiple logical values in a single relational cell.
Incorrect Answers
The other situation is better matched to Use an INNER JOIN between orders and customers on their keys. Only matching combinations of rows appear in the result.
The other situation is better matched to Use HAVING to filter groups by the aggregate expense. Groups below the total threshold are removed after aggregation.
The other situation is better matched to Create a stored procedure encapsulating the routine. The database can execute a named parameterized sequence of SQL operations.