searching book in database ,adding the price of all the books to be purchased. Using SQLite and python

create such an application for maintaining a database of book titles and their costs. Part 1: Write the script to create the required database and add data programmatically by using the Insert query. Part 2: Write a Python script connecting to the database created that has the following features: Module 5 Assignment Programming with Python • A books table having the title, author, and price as fields. • Accept input from the user for the title and quantity purchased by the customer. • Fetch the price from the table by executing the Select query. • Calculate the total amount and display i