Question

1. Design a table named 'Book' for an online library database.
(a) Create the following fields: Book ID, Name of the book, Author's name, Date of
publication and Availability status.
(b) Set an appropriate data type for each field.
(c) Choose and set the primary key for the table.
(d) Enter data for 10 books.
(e) Create a query to display the book ID and the name of the book.
(f) Create a query to display the names of only those books which have not been
issued to students.​

Answer 1

Answer:

if I don't think I don't think I

Answer 2

Explanation:

. Design a table named 'Book' for an online library database.

(a) Create the following fields: Book ID, Name of the book, Author's name, Date of

publication and Availability status.

(b) Set an appropriate data type for each field.

(c) Choose and set the primary key for the table.

(d) Enter data for 10 books.