I am reading about Relational and Object databases, and in this context I would guess that dimensional design is still a part of the relational approach, but where dimensional is focused on OLAP and not OLTP? That is why QlikView care less about NF?
Edit: I switched OLTP/OLAP around, so it makes more sense now.
When I make applications, I look at data and make a data model from that. Then I listen to the user and tweak the data model.
In other words: The data model is really decided from data and not from the user wanting to see this or that in a pivot table. A good, logical data model will meet most (or all) user demands without any changes.
But then I dont understand all this hype with fact/dimension database design in a star design, why is that so important? I dont find that "logical" to work with, I find thematic tables side by side, perceptual easier too figure out and work with.
.png "Former Employee"){kind=icon}