Microsoft Azure Data Fundamentals DP-900 Practice Question

Normalization reduces data redundancy and prevents update anomalies by ensuring each fact is stored exactly once. Repeating attributes that describe a product (its name and price) should be kept in a separate Products table that uses ProductID as its primary key. OrderDetails would then hold only the ProductID as a foreign-key reference, eliminating duplicated product information. Creating a composite column, adding extra price columns, or embedding attributes in JSON does not remove redundancy and therefore does not achieve the fundamental purpose of normalization.