I have the Python code for the task.

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:

id	Title	Author	Qty
3001	A Tale of Two Cities	Charles Dickens	30
3002	Harry Potter and the Philosopher's Stone	J.K. Rowling	40
3003	The Lion, the Witch and the Wardrobe	C. S. Lewis	25
3004	The Lord of the Rings	J.R.R Tolkien	37
3005	Alice in Wonderland	Lewis Carroll	12

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

0. Exit

What will be the code for Mysql database so my program can find the books from that table ? My code :

class Book:

def __init__(self, number, qty, title, author):

self.id = number

self.qty = qty

self.title = title

self.author = author

def __str__(self):

return f"Book [id: {self.id}\tqty: {self.qty}\ttitle: {self.title}\tauthor: {self.author}]"

class BookStore:

# Create empty list to hold books

def __init__(self):

self.bookList = []

# Create new book and add it to the list

def addNewBook(self, id, qty, title, author):

self.bookList.append(Book(id, qty, title, author))

# Remove book from the list

def removeBook(self, id):

b = self.searchBook(id)

if b is not None:

self.bookList.remove(b)

def searchBook(self, id):

for b in self.bookList:

if b.id == id:

return b

return None

# Function to update book

def updateCurrentBook(self, id, title, author):

if not self.bookList:

return

b = self.searchBook(id)

b.title = title

b.author = author

# Creating the menu

def showMenu():

print("1. Enter book.")

print("2. Update book.")

print("3. Delete book.")

print("4. Search books.")

print("5. Exit.")

print("Enter choice: ", end="")

def run(self):

print("Welcome to book Store:")

number, qty, title, author = 0, 0, "", ""

choice = 0

while choice != 5:

BookStore.showMenu()

choice = int(input())

# Get book details from user and add it to the list

if choice == 1:

number = int(input("Enter book id: "))

qty = int(input("Enter book quantity: "))

title = input("Enter book title: ")

author = input("Enter book author: ")

self.addNewBook(number, qty, title, author)

elif choice == 2:

# Get book id from user, search for the book and update its details

number = int(input("Enter book id: "))

b = self.searchBook(number)

if b is None:

print("No such book.")

else:

title = input("Enter new book title: ")

author = input("Enter new book author: ")

self.updateCurrentBook(number, title, author)

elif choice == 3:

# Get book id from user and remove it from the list

number = int(input("Enter book id: "))

self.removeBook(number)

elif choice == 4:

# get book id from user and display book details

number = int(input("Enter book id: "))

b = self.searchBook(number)

if b is None:

print("No such book.")

else:

print(b)

print("Goodbye!")

if __name__ == "__main__":

store = BookStore()

store.run()