How can triggers be applied to accomplish referential integrity?
What will be an ideal response?
Foreign key constraints are used to enforce relationships between tables. If a parent key value, such as a department number, is modified, a foreign key error occurs if we still have products assigned to that department. Triggers provide a way to avoid this error and accomplish a cascade update action.
You might also like to view...
If only common stock is outstanding, total stockholders' equity divided by the number of shares of common stock outstanding is called the
A) par or stated value per share. B) call value per share. C) book value per share. D) market value per share.
Agreements providing for non union membership as a condition to employment are ________
Fill in the blanks with correct word
Business trends in one country rarely, if ever, influence trends in another country.
Answer the following statement true (T) or false (F)
The first step in the collection of overdue accounts is ________
A) a letter B) contacting a collection agency C) legal actions D) a personal visit