O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Types of Data Integrity

Consider a commercial database in which you store information about products, customers, sales, and so on. You can measure the integrity of the data contained in that database in different ways:

  • Is the information related to one specific product stored in a consistent way, and is it easy to retrieve?

  • Do you have different products with the same name or code?

  • Can you identify your customers in a unique manner, even if they have the same name?

  • Are there any sales that are not related to a specific customer?

  • Do you have any sales of nonexistent products?

  • Do you have a consistent price structure for your products?

To guarantee the integrity of the data contained in a database, you should ensure

  • That every individual value conforms ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required