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)

Menultems > MenultemID MenultemName Item CategoryID MenuListPrice ItemFoodCost MenultemCategory CategoryID CategoryDescription FrequentCustomerCards CardNumber FirstName LastName Address City State ZipCode Latitude Longitude Menuitems PurchaseMenultems PurchaseltemID CheckNumber MenultemID Quantity Served Item Total Doo Purchases CheckNumber Restaurant D MealDate NumGuests MethodofPayment FrequentDinerCard Employee D Food Total PercentageDiscount DiscountAmount Tax TotalBill Tip Restaurants RestaurantID Location Address City State ZipCode ManagerEmployeelD YearOpened Latitude Longitude Employees EmployeelD FirstName LastName CurrentRestaurantID StartDate