Primary-key columns were discussed in the preceding lesson.
Primary-key columns contain values that uniquely identify a record within a table.
Sometimes a single column does not contain sufficient information to distinguish one record from every other record in the table.
Consider the Line Item table:
No single column contains enough information to set a record apart from every other record in the table,
though OrderNo and CDNo are the most likely prospects.
The problem is, an order can contain more than one CD and a CD can be part of more than one order.
It is possible to create a CDOrderID column, but there is an easier solution:
Create a concatenated primary key.
You should create a concatenated primary key
based on the existing columns in the database table.
A concatenated primary key
is a primary key made up of two or more columns.
In the case of the Line Item table, each record is uniquely identified by the combined values of
the OrderNo and
columns located at the extreme left of the table.
We are assuming a particular CD will not occur more than once in an order.