You need to create an application that will represent the relationship between managers
and employees. You must achieve this goal by using the minimum amount of tables. What
should you do?

A.
Create two tables. Create a trigger that maintains the relationship between the two
tables.

B.
Create one table that contains the hierarchyid data type.

C.
Create one table that contains the uniqueidentifer data type.

D.
Create two tables. Establish a foreign key relationship between the tables.

Explanation: