You need to design a table structure to ensure that certain users can see sales data for only certain districts
You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort