A friend commented like this:
I'd recommend separating out your transactional data and your reporting data into a separate database
And another one told me:
I would implement an E-R schema in the transactional data and a star schema for the reporting database
Can anyone make both clear for me? I ask, because I really didn't get difference?