Databases - Project

SQLite:

Hi There

Please help - Thanks in advance :)

I require the below code using sqlite3 with comments & Explanation.

(Also please check the code in your IDE to ensure it gives the correct output as required in the task question).

** Must use import sqlite3 **

Topics covered in my learning material so far are :

db = sqlite3.connect

cursor = db.cursor()

cursor.execute()

db.commit()

db.rollback() db.close()

llow these steps: - Create a program that can be used by a bookstore clerk. The program should allow the clerk to: add new books to the database update book information delete books from the database search the database to find a specific book. - Create a database called ebookstore and a table called books. The table should have the following structure: - Populate the table with the above values. You can also add your own values if you wish. - The program should present the user with the following menu: 1. Enter book 2. Update book 3. Delete book 4. Search books O. Exit The program should perform the function that the user selects. The implementation of these functions is left up to you, but a demonstration of the topics we have covered in the last module should be shown