Star Schema, Its Parts and Use

Running head: STAR SCHEMA, ITS PARTS AND USE
STAR SCHEMA, ITS PARTS AND USE
Name of the Student
Name of the University
Author Note

1STAR SCHEMA, ITS PARTS AND USE
Executive Summary
The prime focus of this report is on one of the schema of data warehouse known as star schema.
Later in the discussion, the integral parts of star schema is discussed in detail which are
dimension table and fact table. The dependency between the tables is also discussed followed by
a graphical depiction of the tables. The report concludes with the concept of the easy use of star
schema and the level of dependency among the fact and dimension table.

2STAR SCHEMA, ITS PARTS AND USE
Table of Contents
Introduction......................................................................................................................................3
Discussion........................................................................................................................................3
Star Schema.................................................................................................................................3
Fact Table....................................................................................................................................4
Dimension Table..........................................................................................................................4
Requirement of the Star Schema.................................................................................................5
Fact Table and Dimension Table.................................................................................................5
Conclusion.......................................................................................................................................6
References........................................................................................................................................7