Keys in a Relational Database

A relation (table) must have distinct tuples — no two rows can be identical across all attributes. That means there should be at least one attribute (or combination of attributes) whose values are always unique and never NULL. That attribute is what lets us uniquely distinguish every tuple of a relation. …