1. What kind of business scenarios might have use of a CHECK constraint?
2. What kind of business scenarios might call for disabling a constraint?
3. What types of limits would you place on the average database user? On an expert user?© BrainMass Inc. brainmass.com April 3, 2020, 3:58 pm ad1c9bdddf
1) when you want to allow data entry for a datafiled ,check constrain is very usefull.
A CHECK constraint on the salary and commissions columns to prevent the commission from being larger than the salary for a marketing company.
2) disabling a constaints
-When loading large amounts of ...
What kind of business scenarios might call for disabling a constraint?