Follow these steps: • 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 o 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 3001 3002 3003 3004 3005 Title A Tale of Two Cities Harry Potter and J.K. Rowling the Philosopher's Stone The Lion, the Witch and the Wardrobe The Lord of the Rings Alice in Wonderland Author Charles Dickens 1. Enter book 2. Update book 3. Delete book 4. Search books e. Exit C.S. Lewis J.R.R Tolkien Lewis Carroll Qty 30 40 25 37 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: The program should perform the function that the user selects. The implementation of these functions is left up to you.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Follow these steps:
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
o 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
3001
3002
3003
3004
3005
Title
A Tale of Two
Cities
Philosopher's
Stone
Harry Potter and J.K. Rowling
the
The Lion, the
Witch and the
Wardrobe
The Lord of the
Rings
Alice in
Wonderland
Author
1. Enter book
2. Update book
3. Delete book
Charles Dickens
4. Search books
e. Exit
C.S. Lewis
J.R.R Tolkien
Lewis Carroll
Qty
30
40
25
37
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:
12
The program should perform the function that the user selects. The
implementation of these functions is left up to you.
Transcribed Image Text:Follow these steps: 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 o 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 3001 3002 3003 3004 3005 Title A Tale of Two Cities Philosopher's Stone Harry Potter and J.K. Rowling the The Lion, the Witch and the Wardrobe The Lord of the Rings Alice in Wonderland Author 1. Enter book 2. Update book 3. Delete book Charles Dickens 4. Search books e. Exit C.S. Lewis J.R.R Tolkien Lewis Carroll Qty 30 40 25 37 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: 12 The program should perform the function that the user selects. The implementation of these functions is left up to you.
Expert Solution
steps

Step by step

Solved in 9 steps with 10 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY