5.1. Implement Entity Integrity
Entity integrity is the guarantee that a single entity in the database represents a single unique entity in the real world. Since databases generally store information about real-world objects, it is important that the relationship between the object and the data about the object is maintained. A database administrator will generally enforce entity integrity through keys. Unique keys in the database will ensure that you do not inadvertently duplicate data about a single real object in the real world.
Each row in a data table represents some real object in the real world. For example, information about a customer in the real world must be tracked in the database. However, we need to make sure that the data about ...
Get SQL Server® 2008 Administration: Instant Reference 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.
