Write a program that connects to the database for the business where sales data include where customer purchase record is there. computer database system include attributes(manufacture , type, model, color). The program will be a text menu based application that allows someone to manipulate and access the data in your database. Your program should meet the following criteria. 3 menu options for Adding, Updating, and Removing data Each menu should lead to a sub-menu where you will specify the table to add, update, or delete from You should prompt for the information needed to perform the add, update, or delete. You should not take direct entry of sql from the user.
Write a program that connects to the
The program will be a text menu based application that allows someone to manipulate and access the data in your database. Your program should meet the following criteria.
3 menu options for Adding, Updating, and Removing data
Each menu should lead to a sub-menu where you will specify the table to add, update, or delete from
You should prompt for the information needed to perform the add, update, or delete.
You should not take direct entry of sql from the user.
1 transaction menu option that executes multiple sql statements (example, adding an invoice to SaleCo).
At least 2 menu options that retrieve data from the database.
All programs should have the header documentation listed above as well as inline comments throughout the code.
To submit your assignment:
Submit your source code file (*.cpp)
Your sqlite .db file for your business
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
