Question
1. Suppose there are n physical inventory counts represented in the database. Which inventory counts are needed to compute shrinkage by week for all weeks
1. Suppose there are n physical inventory counts represented in the database. Which inventory counts are needed to compute shrinkage by week for all weeks for which there are sufficient data?
Question options:
the first n 1 counts | |
the last n 1 counts | |
all n counts | |
all but the first and last counts |
Please help me with those questions! Please be sure the answers are correct!
2. The best strategy for calculating the percentage of sales by food category by store is to:
Question options:
sort by food category, store, and percentage, find sales by category by store, find sales by store, join (left outer) the two queries, and calculate the percentages | |
find sales by store, find sales by category by store, join (inner) the two queries, calculate the percentages, and sort by food category, store, and percentage | |
find sales by store, find sales by category by store, join (right outer) the two queries, calculate the percentages, and sort by food category, store, and percentage | |
calculate the percentages, find sales by store, find sales by category by store, join (inner) the two queries, and sort by food category, store, and percentage |
Please be sure the answers are right! Thanks !
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