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 modeling the many to many relationship in the business 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 creating the many to many join in the physical model
D. By creating a logical table source (LTS) that joins the Employees and Jobs tables
|
Download Printable PDF. VALID exam to help you PASS. |
 |