Chapter 6, Problem 1TD

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.

Table Creation:

Creating table comes under Data Definition Language (DDL).

• The CREATE command is employed for establishing databases on our platform by constructing tables in an already existing database.

The Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

  Column1 datatype,

  Column2 datatype,

  …

);