Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A global organization has a data warehouse and one of the dimensions is to keep track of sales employees; information such as name, email and

A global organization has a data warehouse and one of the dimensions is to keep track of sales employees; information such as name, email and location. A unique employee number is assigned to each salesperson by the HR. It is a business practice to transfer a salesperson from one location to another from time to time. Which of the following is the best way to design the primary key for the dimension? Group of answer choices Use the employee number as the primary key Use the employee number and email as a composite primary key Use the employee number and location as a composite primary key Create a surrogate key as the primary key

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Stage Managers Toolkit

Authors: Laurie Kincman

2nd Edition

1138183776, 978-1138183773

More Books

Students also viewed these General Management questions

Question

What are the functions of top management?

Answered: 1 week ago

Question

Bring out the limitations of planning.

Answered: 1 week ago

Question

Why should a business be socially responsible?

Answered: 1 week ago

Question

Discuss the general principles of management given by Henri Fayol

Answered: 1 week ago

Question

How does national culture relate to organizational culture?

Answered: 1 week ago