In this assignment, we will develop a simple inventory database program (database application) for
a small computer store. We will use the database that we used in
The program is menu-driven. It should be capable to perform the following operations on the
database:
1. Find a record by product id
2. Insert a new record
3. Delete a selected record
4. Update a selected record (Update the \quantity" value in a record)
Your program should work as shown in the following sample run. (You can use a fancier menu in
your program if you like. The one shown below is a very basic one.)
Sample run:
(F) Find
(I) Insert
(D) Delete
(U) Update
(Q) Quit
Please select using a letter ==> f
Product ID: 1003
id = 1003
name = Dell Laptop Computer
price = 799.99
quantity = 20
(F) Find
(I) Insert
(D) Delete
(U) Update
(Q) Quit
Please select using a letter ==> i
Product ID: 5000
Product Name: IBM Desktop Computer
Unit Price: 1000.00
Quantity: 5
(F) Find
(I) Insert
(D) Delete
(U) Update
(Q) Quit
Please select using a letter ==> d
Product ID: 1001
Record deleted
(F) Find
(I) Insert
(D) Delete
(U) Update
(Q) Quit
Please select using a letter ==> u
Product ID: 1002
Quantity: 11
(F) Find
(I) Insert
(D) Delete
(U) Update
(Q) Quit
Please select using a letter ==> q
Good-bye!
Note that your program should show appropriate error messages for errors caused by the user.
After performing above operations on the database given on the web page, you should have the following
records in the database:
id = 1002
name = Gateway Desktop Computer
price = 649.99
quantity = 11
id = 1003
name = Dell Laptop Computer
price = 799.99
quantity = 20
id = 5000
name = IBM Desktop Computer
price = 1000.0
quantity = 5
Bobby1 0 Newbie Poster
Grn Xtrm 84 Posting Pro in Training
In this assignment, we will develop a simple inventory database program (database application) for
a small computer store.
No you will.
You cant just post your homework assignment and expect to get a quick answer. There is no instant gratification on Daniweb. You must show effort and we will try to help you work through your problems.
Grn Xtrm 84 Posting Pro in Training
How did my post get above the OP? And why does it say 1 hour ago when I posted a few minutes ago?
Daniweb sure has been acting strange lately ;)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.