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 ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.