Software & Apps Apps 27 27 people found this article helpful Determinants and Their Role in a Database Determinants identify values assigned to other attributes by Mike Chapple Writer Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Mike Chapple Updated on July 27, 2019 Hero Images / Getty Images Apps Best Apps Tweet Share Email A determinant in a database table is an attribute that can be used to determine the values assigned to other attributes in the same row. By this definition, any primary key or candidate key is a determinant, but there may be determinants that are not primary or candidate keys. For example, a company might use a table with the attributes <Employee_id>, <First_name>, <Last_name> and <Date_of_Birth>. Employee_id First_name Last_name Date of Birth 123 Megan Brown 01/29/1979 234 Ben Wilder 02/14/1985 345 Megan Chowdery 2/14/1985 456 Charles Brown 07/19/1984 In this case, the field <Employee_id> determines the remaining three fields. The name fields do not determine the <Employee_id> because the firm may have employees that share the same first or last name. Similarly, the <Date_of_Birth> field does not determine the <Employee_id> or the name fields because employees may share the same birthday. Determinant Relationships to Database Keys In this example, <Employee_id> is a determinant, a candidate key, and also a primary key. It's a candidate key because when the entire database is searched for 234, the row containing the information about Ben Wilder appears and no other record is shown. Another candidate key occurs when you search the database by the information in three columns; <First_name>, <Last_name> and <Date_of_Birth>, which also retrieves the same result. The <Employee_id> is the primary key because of all the combinations of columns that can be used as a candidate key, it is the easiest column to use as the primary reference to this table. Also, <Employee_id> is guaranteed to be unique to this table, no matter how many other employees there are, as opposed to the information in other columns. More from Lifewire Glossary of Common Database Terms Definition of Database Relation The Definition of a Candidate Key Full Functional Dependency in Database Normalization Database Relationships Basic Keys That Make Database Management Easy What Is Boyce-Codd Normal Form (BCNF)? What Is a Database? What Are Database Dependencies? A Database Attribute Defines the Properties of a Table Normalizing Your Database: First Normal Form (1FN) Multivalued Dependency in Database Design Choosing a Primary Key Creating Databases and Tables in SQL Introduction to Database Relationships What Is a Primary Key?