Database Concepts (8th Edition)
Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 8, Problem 8.14RQ

Explanation of Solution

Star schema:

Star schema is the simplest of data mart schema that are mostly used in creating data warehouses and dimensional databases.

  • It is used by the dimensional database which contains data that are organized in the form of facts and dimensions.
  • By the name it resembles the star where it will contain fact table at its center and dimension table radiating from the center.
  • The contents of the fact table are completely normalized whereas contents of the dimension table can be non-normalized.
  • It is used as a part of OLAP (OnLine Analytical Processing) and it structure resembles to a central truth table connected to a measurement table...

Blurred answer
Students have asked these similar questions
What is a database system in relation to MYSQL?
What characteristics set NoSQL databases apart?
Why is the star schema well suited to data warehouse databases
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning