Question

Create table BOOK

BOOK ID Char (4)

Bname Varchar (15)

Author Varchar (20)

Price Decimal

a) Identify the primary key of the Book Table, also mention the suitable reason

for choosing it as a Primary Key

b) Enter five records by using INSERT command.Keep the Author Name same

for all records.

c) Display all record by using SELECT command.

d) Change the Author Name for 4th record by using UPDATE command.

e) Remove the 2nd record by using DELETE command.


please answer immediately​

Answer 1

Answer:

...............................…