From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Eliminate inconsistent data

Eliminate inconsistent data

From the course: Learning Relational Databases

Start my 1-month free trial

Eliminate inconsistent data

“

- [Instructor] Typographic errors and spelling mistakes can completely wreck even the most well planned database. These types of errors are difficult to predict and often occur when data entry tasks are being performed by human beings. We simply get in a hurry and can get a little sloppy with our typing skills. Related to this is the common problem of having different entry styles among a variety of individuals. Different people might be in charge of putting data into the database. Some people like one abbreviation over another, and others will choose to spell out information completely. Let's take a look at an example using the products table that we created in the last movie. Here we have the various olive oils that are available for sale and the manufacturers of those products. In the manufacturer's column, you can see that they're all produced by the Two Trees Olive Oil company. But, one of them was input as a numeral two instead of the word two written out. While this gets the…

Contents