When is it important to delete duplicate data in a database?

What will be an ideal response?


It is possible that two (or more) identical values exist that should be treated as one. For example, generally you only want one CustomerID per customer so that you can identify all of his or her related orders and get an accurate view of the data.

Computer Science & Information Technology

You might also like to view...

MC Which of the following correctly calls a function with the following header: def ( name, number1 = "one", number2 = "two" ):?

a) test ( number1 = "two", "Name" ). b) test ( "Name", number2 = "one" ). c) test ( number1 = "three" ). d) All of the above.

Computer Science & Information Technology

An instruction is fetched and executed during __________.

a. I-time b. a machine cycle c. E-time d. a fetch

Computer Science & Information Technology

Plug-ins are software programs that extend the capabilities of a web browser

Indicate whether the statement is true or false

Computer Science & Information Technology

Microsoft Edge is the search engine that is included with Windows 10

Indicate whether the statement is true or false

Computer Science & Information Technology