Question

which of the following field of table"Book" can act as primary key?​

Answer 1

Answer:

Book_Id can acts as the primary key of the table "Book" as it can uniquely identify all the books in the table.

Explanation:

Primary Key:

A primary key is the column that can uniquely identify all the records of a particular table. Without a primary key, we cannot access a particular record because there will be no medium to identify the record.

For a column to be a primary key, there are some essential rules that are as follows:

1. The primary key should not contain any duplicate values.
2. It should not have any NULL values.

In the book table, Book_Id is associated with all the books and it does not have any duplicate or NULL values.

So it can be used as the primary key of the Book table.

#SPJ3

Answer 2

Answer:

book number

Explanation:

it is a data recording key of unique values