Question $3$

$(40$ marks$)$

Develop a Python application for managing product inventory using Tkinter for the graphical user

interface and SQLite for database storage.

Requirements:

$1.$ Database Setup: $--$

Use SQLite to create a database named "inventory.db$"$

Create a table named "products" with the following columns:

$$ id $($Integer $-$ Primary Key$)$

$$ name $($Text$)$

$$ description $($Text$)$

$$ quantity $($Integer$)$

$$ price $($Real$)$

$2.$ Graphical User Interface: $--$

Create a main window with the title "Inventory Management System"

Implement the following Tkinter widgets:

$$ Entry widgets for product details $($name$,$ description, quantity, price$)$

$$ Buttons for Add, Update, and Delete operations

$$ A Text widget to display all product details

$$ A Scrollbar for the Text widget

$$ A Combobox for sorting options

$$ A Label to show the total number of products $($status bar$)$

$3.$ Functionality: $---$

Implement functions to perform the following operations:

$$ Add a new product to the database.

$$ Update an existing product's details.

$$ Delete a product from the database.

$$ View all products in the Text widget.

$$ Sort products by name, price, or quantity $($ascending and descending$)$

Ensure proper input validation for all entry fields.

Implement error handling with appropriate message boxes.Name

Description:

Quentity:

Price:

ID: $1$

Name: Rice

Descripeion: $10$ kg

Ouantity: $5$

Pxice: $8150\mathrm{.}00$

ID: $2$

Name: Sugar

Deberipeion: $10$ kg

Quanticy: $50$

Price: $$200\mathrm{.}00$

Sort by:

Total products: $2$

the picture is to show u how my program should be when i run it and how it should work $,$ pls do it correctly for me pls