In a star schema, what type of table is the central fact table surrounded by?
Practice Questions
Q1
In a star schema, what type of table is the central fact table surrounded by?
Dimension tables
Normalization tables
Transaction tables
Index tables
Questions & Step-by-Step Solutions
In a star schema, what type of table is the central fact table surrounded by?
Correct Answer: Dimension tables
Step 1: Understand what a star schema is. It is a type of database design used in data warehousing.
Step 2: Identify the central part of the star schema, which is called the fact table. This table contains numerical data or metrics.
Step 3: Recognize that the fact table is surrounded by other tables. These are called dimension tables.
Step 4: Know that dimension tables provide additional information or context about the data in the fact table, such as time, location, or product details.
