Explain the pragmatic reason for using surrogate keys
What will be an ideal response?
Primary keys are commonly included in indexes, and are used to identify records to be retrieved by users. The ideal primary key is short, numeric and fixed. When the primary key contains a lengthy text field, this creates a large amount of duplicated data that must be frequently manipulated. For these reasons, it is often practical to use a surrogate key that is generated by the system and is relatively small and easy to manipulate.
You might also like to view...
Assume that you want to determine the profit margin for a company. Which one of the following financial statements is the best source of this information?
a. Statement of retained earnings b. Statement of cash flows c. Statement of stockholders' equity d. Income statement
Frank is an agent for private home owners wishing to locate tenants to lease their homes. Frank's duties include advertising for tenants, processing the paperwork for the lease, collecting the rent payment from the tenants and issuing the proceeds to
the owners, and serving as a conduit for messages. Near the end of his one year contract with home owners John and Becky Ward, Frank tells the tenants that the Wards are going to evict them. In reality, the Wards have no intentions of evicting the Wards. Frank convinces the Wards to move out early, saving themselves the embarrassment of eviction, but forfeiting their security deposit (which Frank conveniently holds in escrow.) What fiduciary duties has Frank violated?