Question: what are the advantages disadvantages of star schema?
Answer: Data integrity is not enforced well since in a highly de-normalized schema state.
Not flexible in terms if analytical needs as a normalized data model.
Star schemas don't reinforce many-to-many relationships within business entities – at least not frequently.