A star schema is a database schema used to store data in a star format. This schema consists of a central table, called the “fact table,” and several directly connected other tables, called “dimension tables.”
The fact table contains information about metrics or measures, while the dimension tables contain information about descriptive attributes. The star schema is very simple and easy to understand, making it ideal for cloud data warehousing and business intelligence applications.

Characteristics of Star Schema:-

The star schema is characterized by a denormalized data structure, with all data related to a particular subject stored in a single large table and connected to smaller, dimensional tables through a single join.
1. A single one-dimensional table can represent each aspect in a star schema.
2. The collection of attributes should be in the dimension table.
3. Using a foreign key, the dimensions table is connected to the fact table.
4. No connections are made between the dimension tables.
5. Key and measure would be in the fact table.
6. Tables for the dimensions are not standardized. As an OLTP architecture would have it, the Country ID in the image above does not have a Country lookup table.
7. BI Tools provide extensive support for the schema.