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.
Computer Science & Information Technology
You might also like to view...
The decimal number 15 is represented in hexadecimal as ________
A) A B) B C) F D) D
Computer Science & Information Technology
To open the Create Table dialog box, click on the Table button in the Tables group on the ________ tab
A) INSERT B) DATA C) FORMULAS D) VIEW
Computer Science & Information Technology