Question

A retail company stores customer orders in a relational database. Each customer's name and address are currently repeated in every order row, causing inconsistencies when a customer moves. A data engineer proposes splitting the data into separate Customer and Order tables linked by a customer ID. What primary benefit does this relational design provide?

Accepted Answer

It reduces data redundancy and improves consistency by storing each piece of information once

Answer

It allows the database to store unstructured binary files more efficiently

Answer

It eliminates the need to define a schema before loading data

Answer

It converts the workload from transactional to analytical processing