1)We have a application where user can only modify the database they are not allowed to make new entries in database.
each modification effects 3 to 4 tables. how can this be implemented.
2) also i would like to know how they can modify in bulk for example add 15 % bonus to employees whose sal is > 80000K and 20 % whose sal is ess than < 80000
This will involve modification of around 25000 emp
each modification effects 3 to 4 tables. how can this be implemented.
2) also i would like to know how they can modify in bulk for example add 15 % bonus to employees whose sal is > 80000K and 20 % whose sal is ess than < 80000
This will involve modification of around 25000 emp