Introduction on the term Star Schema

Question

Provide a brief introduction on the term Star Schema?

Answer 1

In a star schema encompasses of dimension and fact tables. Fact table holds the fact or the real data. Generally numeric data is stored with many columns and multiple rows. Dimension tables hold smaller granular data or attributes. The fact table in start schema will have foreign key references of dimension tables.