Please! First, download the DB browser(SQLite): https://sqlitebrowser.org/dl/
Please read chapter 6 to get to know concepts before starting the assignment.
There are three files that you need to use for the assignment. It is not allowed me to upload the database file in this chatbox, so I can send you through an email address. Please! Provide me with your email address to send that file to you.
Once, you got the database file, open the DB browser and click on “file” to pick “open database.”
Finish populating the database using the data in the PDF file.
After you have the database completely populated create a few SQL queries to answer at least 12 queries of the most common questions accountants ask. For instance, list the sales orders pending to be picked; list the invoices a given employee has created, list all the invoices with complete information. (please find more most common questions account ask)
0 comments