Aktham Mahmoud

Aktham Mahmoud

  • NA
  • 720
  • 34.6k

Best way to check column value.

Jan 19 2020 10:05 PM
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 

Answers (1)