Please test an application providing a Tkinter based GUI to user stock market activities. The information stored by application has to survive application restart. The application must use SQLite library and at least one table to store user activities.

Input:

Must provide clear indication to the user of any steps that must be completed in order (if needed).

Must provide user with proper feedback (e.g. Saved successfully on Record, Search returned nothing on search, etc...)

Requirements:

Application should store the following information for stock activity (choose types that are the best fit for the attribute):

oDate of transaction (choose your preferable format which make it easy for you e.g. 2021-03-13)

oSymbol of transacted stock (e.g. MSFT, AMZN, GME) - note: one word, no spaces

oTransaction type: BUY, SELL - just two values

oStock Quantity involved in a transaction (e.g. 100)

oPrice of transacted stock (e.g. 12.34)

Application consists of two top level windows

Right window titled "Activity Display" contains two buttons on the top: Summary and Activities

oSummary is a default setting for the top window. When user clicks on the button the following information should be displayed

Oldest Transaction Date (should display name of stock transacted as well. If more than one stock then display just one name)

Newest Transaction Date (should display name of stock transacted as well. If more than one stock then display just one name)

Number of unique stock symbols in all activities (list them)

The cheapest price paid for any stock (should display name of stock transacted as well. If more than one stock then display just one name)

The most expensive price paid for any stock (should display name of stock transacted as well. If more than one stock then display just one name)

The stock symbol for the most traded stock

oWhen user clicks on the "Activities" button list of all activities should be displayed ordered by date from oldest to latest (format example: 2021-03-13 GME BUY 100 $123.00)

Left window titled "Activity Entry" contains:

oinputEntry elements for everyactivity attribute (you can use different elements for input if you want to)

o"Record" button when clicked stores the activity in the db - remember to validate input

o"Clear" button when clicked it cleans all input elements.

o"Search" button when clicked it searches DBfor an activity with values specified in input fields and display it below the buttons area- note: you can chain multiple conditions in WHERE statement using AND operator.