Relational database and application for cosmetics store in MySQL and javafx.
The application allows wholesalers to manage their products. Its main task is to smartly plan deliveries and sales of products. The customer enters only the delivery and departure dates of products, the application updates all relevant values on an ongoing basis. It is very flexible, allows you to add new types of products, brands and suppliers from the application level. The application also allows you to give different levels of access to different users.
The database is managed by MySQL, including the following tools:
- functions
- procedures
- triggers