The following logical dimensional model is built for a book publisher to track sales. There is a need to track sales by calendar, by book, and by location. Sales is the fact table and Calendar, Book, and Location are the dimensions.
This model can answer questions such as, “What was our sales on the book Data Modeling for the Business in May 2009 for the Northeast?” Notice in the Book dimension there is a data element called Book Cost Amount. Shouldn’t Book Cost Amount reside in the fact table instead of a dimension? Why or why not?
Thanks to Lakshmi Mangipudi for submitting the idea for this challenge!