Question: 1/50
A data analyst is asked to explain why a relational database is preferred over a spreadsheet for a customer ordering system that has customers, orders, and order line items. Which concept BEST justifies the database choice?
Normalization reduces redundancy and enforces relationships with keys
Denormalization improves write performance by duplicating data
Indexing eliminates the need for primary keys
A flat file structure prevents update anomalies