a. Modify the Data analysis if Desert Gear Supply does not release 3-D designs: If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis, The Orders and parts view without gear supply is represented as: The screen shot of Orders and Parts View: The customer summary without desert gear supply is represented as: The screen shot of Customer Summary:

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

You need to provide two files. 1. word/pdf report file 2. you code in *.sql/.txt file 1. word/pdf report file: 1st task: You have to choose a suitable topic. Many topics are available in the internet/other sources. It is better (not mandatory) if your topic is an unique one. 2nd task: Give a description of your topic. Don't put unnecessary description which is not required in generating the ER diagram. (for example: In University DB managament project, you may write that our university is a world class university etc.) 3rd task: You may identify your entities/relationships (not mandatory). Draw you ER diagram according to your description. 4th task: Draw your schema diagram from your ER diagram. It means you have now all the tables with constraints. 5th task: Create the database, tables/objects. Then insert some dummy data (10-20-40 rows). Provide the *.sql file seperately. 6th task: You have already studied the chapter-3 where you studied different query related topics. Apply your…

Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical and one is non technical Record type. you have to write a SOQL query to fetch All the reocrd type of the ID of Technical Record Type. Please Run the SOQL Query on the Anonymous Window. also please attach the screenshot of the output.

The chr21_genes.txt file lists genes from human chromosome 21, in their order along the chromosome, as described in Hattori et al. (Nature 405, 311-319) (Links to an external site.). For each gene, the file gives the gene symbol, description and category. The fields are separated by tabs. You will need to get the the meaning of each category. You can find these meanings in the original paper (Links to an external site.), under the "Gene categories" section. Create a file named chr21_genes_categories.txt that store this information in tab separated fields:

Answer 2

Expert Solution & Answer

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Answer 8

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Answer 9

Chapter AE, Problem AE9.3

Explanation of Solution

a.

Modify the Data analysis if Desert Gear Supply does not release 3-D designs:

If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,

The Orders and parts view without gear supply is represented as:

The screen shot of Orders and Parts View:

The customer summary without desert gear supply is represented as:

The screen shot of Customer Summary:

Answer 10

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Answer 11

Explanation of Solution

b.

Repeat the analysis with different criteria:

Large customers have ordered more than 900 parts.

Frequent purchases are occurred minimum 25 times per year.

Average order of 3 or less are qualified as small quantities.

The parts which cost less than $75 are inexpensive parts.

The shipping weight is less than 4 pounds.

The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:

The screen shot of Big Customers – Part 2:

Answer 12

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Answer 13

Explanation of Solution

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Answer 14

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Answer 15

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Answer 16

Expert Solution & Answer

Answer 17

Expert Solution & Answer

Answer 18

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 19

Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Explanation of Solution

Explanation of Solution

Explanation of Solution

c. Mention how the second set of criteria changes the result: The second set of criteria changes the result in the following ways: The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

Explanation of Solution

d. Mention recommendations that one can make in light of analysis: It can be concluded that the revenue potential i...

Want to see the full answer?

Chapter AE Solutions

c.

Mention how the second set of criteria changes the result:

The second set of criteria changes the result in the following ways:

The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...