In the normalization process, if you find a candidate key that is not a determinant then you should:
A) place the columns of the functional dependency in a new relation.
B) make the determinant of the functional dependency the primary key of the new relation.
C) leave a copy of the determinant as a foreign key in the original relation.
D) All of the above
E) None of the above
D
You might also like to view...
The board of directors declared a $2 per share cash dividend on common stock and the corporation had 5,000 shares authorized and 4,000 shares outstanding and make a journal entry. The journal entry for the dividend payment would be
a. a debit to Cash Dividends for $8,000 and a credit to Common Dividends Payable for $8,000. b. a debit to Cash Dividends for $10,000 and a credit to Common Dividends Payable for $10,000. c. a debit to Cash Dividends Payable for $8,000 and a credit to Cash for $8,000. d. a debit to Cash Dividends Payable for $10,000 and a credit to Cash for $10,000.
Ben is responsible for the promotions and public relations of his firm, which produces rubber tires. A recent development in technology may change the way in which the rubber for tires is produced, allowing it to be sourced from the roots of dandelion plants. Ben would like to have a story run on the evening news or in the local newspaper about this development, but he knows that this story is likely to be rejected by media personnel because the material is
A. too long. B. written at too high a reading level. C. submitted by an organization that the media does not like. D. not persuasive enough. E. not newsworthy.
The average SAT verbal score for students from one high school over the last 10 exams is as follows:
508, 490, 502, 505, 493, 506, 492, 490, 503, 501 Do the scores support an increasing or a decreasing trend? What will be an ideal response?
If a portfolio had a return of 12%, the risk-free asset return was 4%, and the standard deviation of the portfolio's excess returns was 25%, the Sharpe measure would be
A. 0.12. B. 0.04. C. 0.32. D. 0.16. E. 0.25.