Explain the differences between fact tables and dimension tables. Draw a star schema to illustrate a concrete
Fantastic news! We've Found the answer you've been seeking!
Question:
Explain the differences between fact tables and dimension tables. Draw a star schema to illustrate a concrete example of a fact table in a data mart and its associated dimension tables. In this example, you are an airline and your fact table concerns transactions regarding ticket sales. Create your fact table and at least three dimension tables for your schema. You may draw the star schema by hand or use Excel, MS Paint, PowerPoint, Word, etc.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: