Best way to check column value.

Question

Greeting my friends..

 

Am working on web application (Training app.) 

 

I designed a database from scratch and I face this theoretical problem 

 

I have a SQL table to [store section] as this photo

 

 

All columns value have low number of quantity which not allow to decrease it as example:

Not allowed being a flour quantity less than 50 kilogram.

 

Scenario :

 

A [store section] following to chocolate shop..

another section called [Kitchen]..

there are daily orders from Kitchen to store ( to request a required quantity from [flour, egg, butter, milk, etc] 

So if today a kitchen sent quantity order to Store section [ I need 30 kilograms of flour], a scenario designed to substruct each order value from column value..

To inform a Storekeeper and admin by alert 

("Your quantity of flour be close to 50 kilograms, you should bye new quantity of this material)..

A followed Solution:

Can I do a last scenario by SQL stored Procedure and apply it to check each column quantity in each (Import/export) orders).

Or design it by SQl function.

I hope to provide me your opinion...

Thanks