Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Python program Create a program that can be used by a bookstore clerk. The program should allow the clerk to: o enter new books

A Python program

image text in transcribed

Create a program that can be used by a bookstore clerk. The program should allow the clerk to: o enter new books into the database o update book information o 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 Qty 3001 30 3002 40 Title Author A Tale of Two Cities Charles Dickens Harry Potter and J.K. Rowling the Philosopher's Stone The Lion, the Witch C.S. Lewis and the Wardrobe The Lord of the J.R.R Tolkien Rings Alice in Lewis Carroll Wonderland 3003 25 3004 37 3005 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 The program should perform the function that the user selects. The implementation of ese functions are left up to you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions