What is the difference between entity integrity and referential integrity?
What will be an ideal response?
ntity integrity is the rule that no field that is part of the primary key may accept null values. Entity integrity guarantees that each record will indeed have its own identity. In other words, preventing the primary key from accepting null values ensures that you can distinguish one record from another. Referential integrity is the rule that if table A contains a foreign key that matches the primary key of table B, the values of this foreign key must either match the value of the primary key for some row in table B, or be null.
You might also like to view...
Hallmark's classic "When you care enough to send the very best" slogan appeals to which need category in Maslow's hierarchy?
A) physiological B) social C) esteem D) self-actualization E) safety
Which of the following laws is most relevant to the marketing mix category of price?
A) the National Do Not Call Registry B) the Consumer Products Safety Commission Act C) the Nutrition Labeling and Education Act D) the Sherman Antitrust Act E) the Consumer Credit Protection Act
Ashbrook Services, Inc acquired 128,000 shares of Gamma Metals, Inc on January 1, 2017
Gamma declares a cash dividend of $2.00 per share on February 15, 2017 and pays the cash dividend on March 2, 2017. With the current investment, Ashbrook Services, Inc holds 11% of Gamma's voting stock. Which of the following will be the correct journal entry for the day when the dividend payment is made (March 2, 2017 )? A) Cash 256,000 Long-term Investments-Trading Investments 256,000 B) Cash 256,000 Long-term Investments-Available-for-Sale 256,000 C) No Entry D) Cash 256,000 Dividend Revenue 256,000
The primary trial court in the federal system is the A) United States district court
B) United States Supreme Court C) United States appellate courts. D) various appeals courts.