Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Textbook Of Financial Accounting And Analysis

Authors: Gaurav Agrawal

1st Edition

9350840901, 9789350840900

More Books

Students also viewed these Accounting questions

Question

Discuss the importance of project risk management

Answered: 1 week ago

Question

=+Does it present new cocktails or review restaurants?

Answered: 1 week ago

Question

=+Is the message on-strategy?

Answered: 1 week ago