Question
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Explanation
Data model: a central Sales table holds foreign keys to Customer, Product, SalesPerson and Warehouse, and none of those tables references another table, so the model is a star schema; a snowflake schema would have dimension tables linked to further sub-dimension tables. Customer: Customer describes an entity that the Sales facts are analyzed by and has no foreign keys of its own, so it is a dimension table; Sales is the fact table, and a bridge table would resolve a many-to-many relationship, which this model does not have.
