(a) Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?
(b) What is the difference between a dimension used in a traditional star schema and SAPs' extended star schema?
(c) Describe what is meant by an In Line Dimension.
Explain how a business intelligence system might provide an organisation with a competitive advantage.