Chapter 6, Problem 12SCG

Program Plan Intro

Primary key:

• To identify each record in a table, at least there must be one data field, which should be unique.
  • That is corresponding data field of every record should be unique.
  • It is called primary key.
• Primary key is used to identify the unique record from a collection of records.

“INTEGER” datatype:

• The numeric values with an implied scale of zero is accepted by the “INTEGER” datatype.
• It will store integer value between the range 2^-31 and 2^31-1.