1 what is the difference between a primary key and a business key?
Sometimes database designers uses two unique keys on each table, a "business key," for example orderid, and a "counter", used as the primary key. ... The PK is chosen from a group of Alternate Keys (AKs), any one of which can uniquely identify any of the rows in the table. A primary key should have several characteristics.