RelationalDBDesign
prev prev
  Course navigation
    Concatenated primary keys
Meaningful information
In the context of relational databases, the term meaningful information refers to information that describes an attribute of an entity represented in a table, such as a customer's first name, last name, address, or phone number.
It might be tempting to use one or more of those attributes in a primary key, but bear in mind that values for those attributes can change.
Customers can change their names, move, or install new phone numbers.
A customer could be entered into the table twice if one customer-relations staff member entered the address as "17th Ave. SE " and another entered the same address as "SE 17th Ave.".
When you assign arbitrary values, such as a CustID, to each customer, you avoid these problems.
Regardless of whether customers change their name or residence, you will always have their orders and other information tied to their original CustID value.
  Course navigation