Using your populated star schema, create DML select statements for the following requirements If you can't answer all five questions with your existing schema, you may need to alter your schema and then repopulate it with new values Return the total bid dollar amount by customer zip code Return the avg bid dollar amount by customer state Return the total bid dollar amount by month Return the total bid dollar amount by customer zip code having a total bid dollar amount greater than $100 Once you have completed all your DML (select commands) copy and paste the script into a Word document and submit it

The Answer is in the image, click to view ...

Question: Using your populated star schema, create DML select statements for the following requirements. If you can't answer all five questions with your existing schema, you

Using your populated star schema, create DML select statements for the following requirements. If you can't answer all five questions with your existing schema, you may need to alter your schema and then repopulate it with new values.

Return the total bid dollar amount by customer zip code.
Return the avg bid dollar amount by customer state.
Return the total bid dollar amount by month.
Return the total bid dollar amount by customer zip code having a total bid dollar amount greater than $100.

Once you have completed all your DML (select commands) copy and paste the script into a Word document and submit it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...

What type of DML Commands would be necessary to query the following information (Please provide scripts). Return the total bid dollar amount by customer zip code. Return the avg bid dollar amount by...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Apply Theorem 3 to calculate the matrix exponential e At for each of the matrices in Problems 35 through 40. A = 13 3 3 3 01 3 3 00 23 0002

Pharmahelp, Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market segments: a. General supermarket chains b. Drugstore chains c. Mom-and-pop...

Whistler Corp. is a new audit engagement for your firm. Whistler backs up all its sales transaction detailed data for each month on a portable hand-held disk drive. The drive is retained offsite for...

How does the literal nature of computers limit them? How have advances in computing enabled machine learning to remove these limitations?

Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the banks call centers in the Excel file Call...

T/F 4. Investments with lower standard deviations can be expected to produce higher rate or return.

Northwest Desserts, Inc., (NDI) produces a variety of premium cheesecakes and sells them in individual packages directly to retail customers and in packages of 10 cakes to restaurants in Washington,...

Problem 2 2 - 3 A ( Algo ) Departmental income statements LO P 3 Garcia Company has two operating departments ( Phone and Earbuds ) and one service department ( Office ) . Its departmental income...

What one modification would you recommend to the "Temporal-Three" evacuation signal to increase its "recognition" and perception of "urgency". In your response justify your modification financially...

A crate starts from rest and is pulled by a force P of 500 N. Determine the speed of the crate after 4 s if between crate and surface is 0.2. Take mass of crate as 80 kg. REMEMBER: use Fdt = m(v -v)...

The answers should identify the capabilities,understandings and knowledge you have gained during the course and how your learning has affected your abilities in a group. 3. discuss the pros and cons...

On November 14, US department store chain Macy's alerted customers of a security breach discovered in October on its website that led to the compromise of payment card details and customer...

Recommend one strategy at each level - Corporate Level, Business Level and Functional Level for Airbnb arise from pandemic

Suppose Jesse knows the following 1. He can complete 200 hours of business consulting per month 2. His business's only cost is rent of $1,000 per month At what price per hour does Jesse need to sell...

True & False The basis of an asset must be reduced by the depreciation allowable, 2. Adjusted gross income (AGI) is the basis for a number of phase-outs of deductions. 3. A change to adjusted gross...

A massive re began in the production building of Pugerville Co. in the early morning of September 18, 2009. The re destroyed all the companys work in process. To determine the amount of the loss,...

CALAir is a small charter airline company that operates between San Francisco and Los Angeles. On January 2, 2009, CALAir purchased a jet costing $2,600,000 with an estimated salvage value of...

Following are several duties performed by accountants. (a) Valuation of investments (b) Cost of goods manufactured calculation (c) Production of intermittent reports for management (d) Budgeting...

1. Define attachment.

Irreversibility is the inability to imagine undoing a process.

4. Describe at least two cross-cultural findings regarding behavioral inhibition.