Identify two examples of natural and surrogate keys in the property sales DM and discuss the benefits associated with using surrogate keys in general.
What will be an ideal response?
Natural key: branchNo; Surrogate key: branchID
Natural key: promotionNo; Surrogate key: promotionID
The use of surrogate keys allows the data in the warehouse to have some independence from
the data used and produced by the OLTP systems.
You might also like to view...
An organization's main assets consist of intellectual property rather than plants, buildings, or expensive computer hardware.
Answer the following statement true (T) or false (F)
Which of the following is part of the user provisioning phase of the employee life cycle?
A) The employee is added to the organization’s payroll. B) The employee is provided with a username or smart card. C) A background check is conducted for the employee. D) The employee expectations of privacy are determined.
Which of the following includes the name and/or job title of a writer of a business letter?
A) The complimentary closing B) The inside address C) The writer's signature block D) The salutation
In Prolog, the __________ describes the relationship between the arguments.?
Fill in the blank(s) with the appropriate word(s).