Give 2 examples for Star schema, Snowflake schema and Fact Constellation Schema.

1. Star Schema:

The Star Schema is a widely adopted schema design in data warehousing, characterized by a centralized fact table connected to multiple dimension tables. The fact table contains the quantitative data (facts), and the dimension tables store descriptive information related to the facts. Here are two examples of the Star Schema:

Example 1: Sales Data Warehouse

*Fact Table:* 
- `Sales_Fact`
  - sales_id (Primary Key)
  - product_id (Foreign Key)
  - time_id (Foreign Key)
  - quantity_sold
  - revenue

*Dimension Tables:*
- `Product_Dim`
  - product_id (Primary Key)
  - product_name
  - category_id (Foreign Key)
  - brand_id (Foreign Key)

- `Time_Dim`
  - time_id (Primary Key)
  - date
  - day_of_week
  - month
  - year

In this example, the `Sales_Fact` table contains quantitative data such as quantity_sold and revenue, while the `Product_Dim` and `Time_Dim` tables provide descriptive information about products and time, respectively.

Example 2: Human Resources Data Warehouse

*Fact Table:*
- `Employee_Performance_Fact`
  - employee_id (Primary Key)
  - project_id (Foreign Key)
  - performance_rating
  - hours_worked

*Dimension Tables:*
- `Employee_Dim`
  - employee_id (Primary Key)
  - employee_name
  - department_id ____ ____ ____ ___ _____ _____ _______ ___ __________ _______ __________ ___.
_________ _______ _________ ___ _____ __________ ___ __________ ______ ________ _______.
__________ ________ ________ ____ ___ _____ ________ ________ ___ ______.
________ ___ ______ ____ _______ ______ _________ _________ ________ ______ _______.
_____ ____ ______ _______ _______ ______ __________ ___.
__________ _________ _______ ________ _________ _________ ______.
__________ __________ ____ ___ _________.
______ __________ __________ ___ _______ ________.
_________ ____ _____ _____ _____ ________ _______ ________ __________.
____ ________ ____ ________ __________ _______.
_______ ______ ____ __________ ________ __________ ________ _________ ______ ______ ___ ________.
________ _________ ________ _________ ________ _________ ________ ________ ____ _____ ______ ________.
__________ _________ _______ __________ __________ _________ ________ _______ __________ ___ ______.
_________ ________ ____ ___ ___ ____ _________ ___ ___.
__________ ________ _____ ___ _______ ___ _____ ________ __________.
________ ____ _____ ___ _________ _________ _________ ______.
___ _______ ________ ____ _____ _____ ____ ___ _________ _______ __________.
____ ___ _________ _______ ___ _______.
___ ________ __________ ____ ________ ______ ____ ________ ______ ________.
_____ ________ ______ ____ ______ _______ _________ ________ _____.
___ _________ ___ _______ __________ __________ _______ _______.
____ _______ _____ _____ _____ _______ _________ ___ ______ _________.
_____ ____ _____ _________ ________ _______ _____ ______.
___ _______ __________ ______ __________ _______ _______ ____ _________ ________ _______ ___.
____ _______ _____ ________ ____.
_______ _______ ___ _______ ______ __________ __________ _____ __________ _____ _________.
___ ___ ________ _________ ______ _______ ________ ________ ________ _____ ___.
________ _____ _________ ____ _________ ___ __________ ________ ____ _________ ______.
_____ _______ ______ ____ _______ _______ ___ __________ __________ _________ ________.
__________ ______ ___ _______ _________ _______ ________.
___ _______ ______ _________ ____.
_____ ________ __________ _______ _______ ____ _________ _______ ____ ______ ___.
______ ________ ______ ________ __________.
_____ ___ _________ ___ __________ ________ _______ _________ _____ ________ ____.
__________ ________ ______ ______ ________ _________ _____ ________ ________.
___ _______ _________ ___ _________ _____ ______ _______.
_______ _________ ____ ___ _____ _________ __________ _______ _____ ____ _________ _____.
__________ _____ _________ _____ ___ ________ __________.
________ ____ _______ ______ ___ ______ _____ ______ ________.
_______ ____ _______ _________ __________ __________ ________.
______ ________ ________ ______ _____ ___.
_________ ___ _______ ________ ___ ______.
_____ ___ __________ ______ _________ ___ ________ ______ _______ ________ _________.
________ ________ __________ _________ ______ ___ ____ _____.
_______ _____ ___ ________ ______ _____ ___.
_________ __________ _________ _______ _____ __________ ______ __________ ___ _____.
______ ____ _________ ____ ___ ______ ___ ______ ______ _________ _________.
_____ ____ __________ ____ ________.
_______ ____ _____ ________ __________ ______ _____.
__________ ________ _________ _______ _____ _________ ________ _______ ______ _________.
____ _____ ________ _________ _______ __________ __________.
___ _____ ________ ________ ___ _______ __________.
_____ ________ _____ ____ ____ __________ _____ ______ _____.
__________ _____ ________ ___ _____ ______ _________.
________ __________ _____ _________ ________ ____.
____ _________ _________ ________ _____ _______ _________ ______ ________ _______.
_________ _______ __________ __________ ____ _____ _________ ________ ___ _________.
______ ________ ___ _______ ______ _____ ______ __________ _______ ________ _______.
_______ __________ ________ ___ ____ ____ ________ _______ _______ ________ ______ ________.
________ __________ _________ ___ ___ ___.
_______ ____ ____ ________ _____ ___ _________ _____.
_______ _______ _____ __________ ____ _____ ______.
_____ __________ ______ ________ ___ ______ ____ ________ ________ ______.
________ __________ _______ ________ ____ ______ _______ ___ ______ _____.
___ _____ _______ _____ ______ ___ ____ ____ _____ _______ _____ _________.
____ _________ _____ ______ _______ ____ _________ ______.
______ __________ ______ __________ _________ __________.
______ ________ _____ ______ _______ ___ _____ _________ ___.
________ ______ _________ _________ ________ _______.
_______ ___ _______ ___ _________ ____.
________ _____ _________ ____ ____ _____ _________ ________ ___ ________ _________ _____.
______ __________ ___ ____ _____ ________ ______ ___ ____.
_________ _________ ___ _________ __________ ____ ________ _________.
______ __________ ______ _________ _______ ____ ______.
_______ ____ ______ _______ ________ __________ _______ ______ _________ __________.
_______ ____ ______.
Get Full Answer on WhatsApp