medium10 pts · first answer countsdata-modelling

Repeated data in a table

An Orders table repeats the customer's name and address on every order row. What is the main problem and fix?

A.The table will be too slow to read, so add more indexesB.There is no problem as long as the data is copied carefullyC.Split the table by year so each year has its own copyD.Redundancy causes update anomalies; move customer details to a Customer table linked by customer ID

Discussion 0

Join free to post in the discussion.

Repeated data in a table

Discussion 0

Related questions