1. Create the following table CATALOG with the following fields:

(BOOK_ID, BOOK_TITLE, AUTHOR, AUTHOR_ID, PUBLISHER_ID, CATEGORY_ID, YEAR, ISBN, PRICE)

Select appropriate datatypes for each of the fields. Identify the primary key. Input meaningful data of at least 10 records.

2. For the above table created in Q.l, answer the following queries using SQL:

To display all the books of the CATEGORY_ID: "COMPUTERS".

List all the books whose PRICE is greater than or equal to RS 1000/-.

List all the books whose PUBLISHER_ID is "Tata McGraw-Hill".

List all the books whose YEAR of publication is 2013.

List all the BOOK_TITLEs whose AUTHOR_ID is "123".