Business requirements are enforced by implementing database constraints on tables and columns. The database constraints available include the following.
FOREIGN KEY or REFERENTIAL INTEGRITY
Give a business requirement and the constraint that could be implemented to enforce it. Explain the constraint you choose, and give the SQL to implement the constraint in the database. What are the long-term problems when these constraints are not implemented?© BrainMass Inc. brainmass.com June 22, 2018, 8:42 am ad1c9bdddf
A Word doc of various SQL constraints and their implementation details with code examples.