how to create table book and identify the primary key of the book table also mention the suitable reason for choosing it a primary key
Answers
Answered by
2
eghjcjzjzjxkcjxjxjcyuuuuuyyuhxjcncjzsudkgidhcjvkvjchchc
Answered by
3
"A table book is created below for demonstration
Book_ID CHAR(20),
Bname VARCHAR(50),
Author VARCHAR(50),
Price DECIMAL(P,D),
PRIMARY KEY (Book_ID));
In the above example, Book_ID is chosen as the primary key.
Primary key is a unique key that is separate for each record that exists in a relational table. Here in this table, the Book_ID is the unique key that uniquely identifies each record in the table.
Bname, Author and Price cannot be primary key as they are not unique as the same book name, same author name or same price can be there for two different books.
"
Similar questions