Describe the star schema design with one Fact Table (Fact_Sales) and four Dimension Tables (Dim_Customer, Dim_Product, Dim_Date, Dim_Store), including key metrics, granularity, and relationships.

In a star schema, the Fact_Sales table holds the measurable metrics such as Sales_Amount, Quantity_Sold, Profit, and Discount_Amount. Each row represents a single transaction line item, providing a granularity of one product sold to a customer in a store on a specific date. The Fact_Sales table is linked to four dimension tables: Dim_Customer (via Customer_ID), Dim_Product (via Product_ID), Dim_Date (via Date_ID), and Dim_Store (via Store_ID). These dimension tables store descriptive attributes like customer demographics, product details, calendar information, and store characteristics. The star shape arises because the fact table sits at the center with direct one‑to‑many relationships to each dimension, enabling efficient querying and aggregation for business reporting.