The schema used in my project was a star schema.

• Star schema is a type of data warehouse schema where a central fact table is connected to multiple dimension tables.

• The fact table contains the measurem...read more

in Star schema I have used in my last project.

Star Schema:

 A centralized located fact table which surrounded by multiple dimension table..

 It looks like a star hence it is called star schema.