Rules for Selecting Primary key {3}

by Jamal A
The article I read talks about how primary key individually identifies each record inside a table.
According to the article the main purpose of a primary key is to uniquely identify a row in a table
and relate records to additional data stored in other tables. The primary Key simply points between
interrelated records in different tables. The article talks about the rules that are necessary for
developers to follow when selecting a primary key for each table. For Instance: “The primary key must
uniquely identify each record. A record’s primary-key value can’t be null. The primary key value must
exist when the record is created. The primary key must remain stable. The primary key must be compact
and contain the fewest possible attributes. The primary key value can’t be changed”. These are some of
the important rules that are a must for developers to follow in order to have stable database. read more...