How can the many to-many relationship issue be resolved?

An organization has its employees’ names in an Employees table, and information about
their jobs in a Jobs table. However, an organization’s employees can have multiple jobs,
and the same job can be performed by multiple employees. This situation would result in a
many to-many relationship between the Employees and Jobs tables. How can the many
to-many relationship issue be resolved?

An organization has its employees’ names in an Employees table, and information about
their jobs in a Jobs table. However, an organization’s employees can have multiple jobs,
and the same job can be performed by multiple employees. This situation would result in a
many to-many relationship between the Employees and Jobs tables. How can the many
to-many relationship issue be resolved?

A.
By creating the many to many join in the physical model

B.
By creating a bridge table that represents one employee doing one job, with several rows
for an employee who has several jobs

C.
By modeling the many to many relationshipin the business model

D.
By creating alogical table source (LTS) thatjoins the Employees and Jobs tables



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

answer is B). To address many-to-many relationship between dimension table, we can setup one bridge table between two dimension table and the bridge table is the fact table of two dimension tables.

http://docs.oracle.com/cd/E14571_01/bi.1111/e10540/busmodlayer.htm#BGBJGJIB

Modeling associated dimension tables into single logical dimension;
or
Modeling associated dimension tables into separate logical dimensions.