You merge data from Sales_Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.
What should you do next to meet the reporting requirements of the executives?
You merge data from Sales_Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.
What should you do next to meet the reporting requirements of the executives?
To meet the reporting requirements of the executives, you should create a hierarchy in the Region table that has the manager name, followed by the sales manager name. This hierarchy will enable executives to drill down from region managers to the sales managers who report to them, providing a clear and structured overview of the management hierarchy, which is essential for understanding the organizational structure and reporting lines.
Explanation is correct but given answer is wrong.
It should be D according to the explanation
Correct answer is D
D is the correct answer as per description.
D seems to be correct because the Executives will only be able to see Region managers and Sales managers that report to them in a hierarchy, besides there is nothing to measure there so A is actually wrong
D is correct
ThariCD is right, the answer is correct but they trap the chossen
The given answer is not correct but the explanation is correct. The answer should be D
I have a question... there is no common column in Sales_manager with other three tables, how come it can be merged with them?