Programming Course work - Database for smartphone shop

Introduction
In many stores and warehouses, inventory and sales are often managed manually, leading to
confusion and errors. This application aims to address this problem by providing a digital solution.
The application consists of four interconnected data structures: "smartphone" (store_id,
smartphone_id, brand, model, price, storage), "purchase" (purchase_id, smartphone_id, date,
month, year, worker_id), "worker" (worker_id, name, surname, job, salary, store_id), and "store"
(store_id, worker_count, storage_smartphone).
The main features of the application include the ability to add, edit, and view files, as well as
perform operations such as deletion, search, and sorting based on specific criteria. Additionally, it
provides insights such as the most popular smartphone, the best-performing worker, and the
average price of smartphones in the store. …