Create program that can be used by a bookstore clerk

Assignment Help Computer Engineering

Reference no: EM133370227

Question: USING PYTHON AND sqlite

Create 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 below

Populate the table with the below 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

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	Alice in Wonderland	12

Reference no: EM133370227

Questions Cloud

Describe some proactive approaches that leadership can take : Describe some proactive approaches that leadership can take to strengthen relationships with staff and physicians. Why are these steps important?

Share physical hardware resources with virtual machines : Virtualization is used to share physical hardware resources with virtual machines - List three (3) main resources that a host shares with Virtual Machines.

Record above transactions in expanded accounting equation : Received a bill for utilities to be paid later, $120. Collected cash on account from clients, $700. Paid the amount due for utilities. Withdrew $500

Give a high-level diagram of the application : Services sector company SSC approached our software development company DevX for the automation of their Customer Activity Reports (CARs) process

Create program that can be used by a bookstore clerk : Create 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

Provide the entry that box ltd. should record : Box Ltd. exchanged a piece of equipment for land and paid $30,000 cash. The equipment was acquired at a cost of $600,000 in previous years.

How was the zoe data gathered and how it was used : data on infections and symptoms was gathered by the Zoe Health Study. how was the Zoe data gathered and how it was used

Does the architecture support the structure : Does the architecture support the structure or structures, as well as (b) the views and patterns of the software system? Critique it

Explain the components of security operation centers : CSMT 6222 Columbus State University List and Explain the Components of Security Operation Centers (Socs) List and explain the tools and technologies

User Account

All Pages