Project created as part of learning the basics of SQL. The script allows you to save, read, edit and visualize your own financial statistics.
When you run the main file, the main program menu will be shown:
- Allows you to create a new table - the year should be the name of the table
- Adding a new month to the table. It will be necessary to provide such data as: month name, income, VAT and tax
- Reading data from the selected month
- Updating any data in a selected month
- Deletion of all data from a specific month
- Reading the best and worst months from a given table
- Print all data from all tables
- Visualization of data from a specific year and visualization comparing revenues from all years
- Close the program
The entered data represents the complete two years of data and the third, unfinished year.
