What is the difference between entity integrity and referential integrity?
What will be an ideal response?
Entity 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
You might also like to view...
An offeror can be given an amount of money to keep the offer open for a time, which is usually ________ days
A) 15 B) 30 C) 60 D) 90
A good layout requires determining:
A) material handling equipment. B) capacity and space requirements. C) environment and aesthetics. D) cost of moving between various work areas. E) all of the above
Which of the following is an advantage of convertible bonds??
A. ?Investors can convert the bonds into higher coupon rate bonds. B. ?Investors can choose to hold the company's bonds or convert the bonds into its stock. C. ?Investors are paid a penalty on the conversion of the bonds. D. ?Investors are redeemed for the difference between the face value and the market price on redemption of the bonds. E. ?Investors can claim interest for the remaining life of the bonds on the bonds' early conversion.
Offering a marketing mix that is like what is available from competitors usually
A. amounts to a feasible strategy. B. doesn't provide superior value. C. provides differentiation for the seller. D. offers a competitive advantage. E. reveals where customers are located.