This is a star schema for a company named something fish that wants to track average check
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: