Explore BrainMass
Share

Database Constraints

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Business requirements are enforced by implementing database constraints on tables and columns. The database constraints available include the following.

PRIMARY KEY
FOREIGN KEY or REFERENTIAL INTEGRITY
NOT NULL
UNIQUE
CHECK

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 October 25, 2018, 7:50 am ad1c9bdddf
https://brainmass.com/computer-science/data-clustering/516960

Solution Summary

A Word doc of various SQL constraints and their implementation details with code examples.

$2.19
See Also This Related BrainMass Solution

Question 11.
What are "referential integrity constraints"? Provide an example.
Question 12.
What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

View Full Posting Details