Python task: cocktail ordering system

Main task:
Develop a project: "Cocktail Ordering System".
Components of the system:
- the system consists of a database that holds the ingredients for cocktails: (
Products (name, price, type (""), quantity in stock), containers (type, price, quantity, time needed for reuse);
Users (bartender (salary, tips, qualification), warehouse owner);
Cocktail recipes (optional)
- an order processing system: every cocktail is made from a recipe, depending on the availability of the components and the complexity of preparation;
- a warehouse management system: the owner manages the availability of components
)
Requirements:
- adding stock manually through a form and by importing from a CSV file
- the ability to add new cocktail recipes and new components
- components that can substitute for one another
- several cocktails can be ordered at the same time; the most expensive one has the highest priority.
The deliverable is:
The final version of the product.
Mandatory requirements:
A non-desktop database (MSSQL, MySQL)
Use of creational design patterns (factory method, abstract factory, builder)
Optional requirements:
Use of a NoSQL database
With many simultaneous orders, finding the most efficient way to serve them all
Substitute products (if a cocktail needs a product that is currently out of stock, it must be replaced with another suitable one). This must also be taken into account when calculating the most efficient serving path.