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...

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)

Computer Science & Information Technology

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.

Computer Science & Information Technology

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

Computer Science & Information Technology

In Prolog, the __________ describes the relationship between the arguments.?

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology