Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a star schema for a company named something fish that wants to track average check size, Food cost percentage ( as a %
This is a star schema for a company named something fish that wants to track average check size, Food cost percentage ( as a % of sales), Discounting (as a % of menu prices), Frequent customer repeat visits (%), payment methods (% by cash and credit card)
From the given schema design:
1. identify and define business processes,
2. Find the data items generated from each business process
3. group the data within by their level of detail ( granularity)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started