Chapter 6, Problem 2SCG

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.

Insert values:

Inserting values comes under Data Manipulation Language (DML).

• The INSERT command in SQL is employed to add records to an existing table.

Syntax for inserting values into the table is as follows:

INSERT INTO TABLE_NAME VALUES('DATA 1', 'DATA 2');