Question

Write the important points to be kept in mind while creating the primary key of a table

Answer 1

Answer:

Points to Note regarding Primary Key

The value of primary key should be unique for each row of the table. The column(s) that makes the key cannot contain duplicate values. The attribute(s) that is marked as primary key is not allowed to have null values.

Answer 2

A primary key

Explanation:

Definition: A primary key is a minimal set of attributes (columns) in a table that uniquely identifies tuples (rows) in that table.

important points to be kept in mind while creating the primary key of a table

• The value of primary key should be unique for each row of the table.
• The column(s) that makes the key cannot contain duplicate values.
• The attribute(s) that is marked as primary key is not allowed to have null values.
• Primary keys are not necessarily to be a single attribute (column). It can be a set of more than one attributes (columns).

Learn more :

While designing a table, description field is mandatory.

https://brainly.in/question/11380490