Describe the update cascade option (for implementing a referential integrity constraint)
What will be an ideal response?
The update cascade option allows the primary key value of a record to be changed if its primary key value is referred to by a foreign key value. However, all the foreign key values that refer to the primary key being changed are also changed and set to the new value of the primary key.
You might also like to view...
Name and describe at least four major barriers to organizational diversity?
What will be an ideal response?
Hercules Sports Equipment Company projected sales of 79,000 units at a unit sales price of $12 for the year. Actual sales for the year were 75,000 units at $14 per unit. Variable costs were budgeted at $3 per unit, and the actual amount was $5 per unit. Budgeted fixed costs totaled $387,000, while actual fixed costs amounted to $450,000. What is the flexible budget variance for variable costs?
A) $158,000 unfavorable B) $150,000 unfavorable C) $150,000 favorable D) $158,000 favorable
Mutual funds _____.
A. are depository institutions that are owned by its depositors, who are often members of a common organization or association B. are investment companiesthat use funds provided by savers to buy various types of financial assets, including stocks and bonds, in the financial markets C. cater to savers, especially individuals who have relatively small savings or need long-term loans to purchase houses D. are organizations that distribute new issues of securities for corporations E. are groups of investment banking firms formed to spread the risk associated with the purchase and distribution of a new issue of securities
The Thomas Company, a small furniture manufacturer, divides its organization into marketing, human resources, accounting, and production departments. This is an example of departmentalization by
A. location. B. specialty. C. product. D. taste. E. function.