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 one table that contains the hierarchyid data type.
B.
Create one table that contains the uniqueidentifer data type.
C.
Create two tables. Establish a foreign key relationship between the tables.
D.
Create two tables. Create a trigger that maintains the relationship between the two tables.