How does normalization resolve the data integrity problem?
What will be an ideal response?
Normalization is the process of converting a poorly structured table into two or more well-structured tables. If an attribute is entered correctly in one row and incorrectly in another, this leads to a problem called a data integrity problem. The data integrity problem can occur only if data are duplicated. Because of this, one easy way to eliminate the problem is to eliminate the duplication of data. The general goal of normalization is to construct tables such that every table has a single topic or theme. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.
You might also like to view...
Revenue is earned when the business has ________
A) entered into an agreement with the customer about the goods or services to be delivered B) prepared a journal entry to record revenue C) received cash from the customer before goods or services are delivered D) delivered a good or service to the customer
Make an effort to be subjective when analyzing market research you have collected
Indicate whether the statement is true or false