Question: Make 2 queries based on the ERD diagram on Microsoft Access that include GROUP BY, multi-table join, self join, non-correlated or correlated subqueries. It must

Make 2 queries based on the ERD diagram on Microsoft Access that include GROUP BY, multi-table join, self join, non-correlated or correlated subqueries. It must have combination of >2 of the below features
Concessionaire HPK Concessionaire ID FName LName Address FK PK City Zip Permit Phone Permit ID FK Service PK

Concessionaire HPK Concessionaire ID FName LName Address FK PK City Zip Permit Phone Permit ID FK Service PK Permit ID Issue Date Expiration Date Product ID Category Concessionaire ID +H Park PK FK Park ID Name Location Concessionaire ID Facility PK FK Facility ID Name Type Location Capacity Park ID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Explanation This is a self join query that counts the number of subordinates for each employee The E... View full answer

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!

What is the difference in the cost of Widget A, per product, using a traditional labor allocation vs. activity based costing method, assuming the three main cost activities are: Widget A Widget B...

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...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Assume electricity is generated by three technologies: a base load technology with cost function C b (x b ) and proportional emission coefficient b ; gas turbines with cost function C g (x g ) and...

Max Corporation is a hardware store chain operating in the Atlantic provinces. The following selected accounts appear in the ledger of Max Corporation on June 1, 2015, the beginning of the current...

Exercise 1-15 (Algo) Identifying effects of transactions using the accounting equation LO P1 Ming Chen started a business and had the following transactions in June. a. Owner invested $59,000 cash in...

=+c) Would you use this model? Explain.

Will Beck, Trevor Beck, and Barb Beck formed the BBB Partnership by making capital contributions of $142,500, $118,750, and $213,750, respectively. They predict annual partnership net income of...

12. The following balance sheet information is for the partnership of Abele, Boule, and Cayman: Cash $ 210,000 Liabilities $ 510,000 Other assets 1,500,000 Abele, Capital (40%) 300,000 Boule, Capital...

1. What is the cost of debt for Sunrise Bakery? 2. What is their cost of equity? 3. What is the WACC? 4. Which cost of capital should be used to evaluate the feasibility of the oven purchase? 5....

Lynch Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: Variable costs per unit: Manufacturing: Direct materials Direct...

Provide a Situation Analysis: Review the current situation facing Suez Canal and develop in detail the PESTLE Analysis looking at the Strengths, Weaknesses, Opportunity, and Threats (SWOT) analysis,...

5.29 The fighter aircraft F/A-18 (Hornet) has a takeoff mass of 25,400 kg, a wing area of 37.16 m, and two turbofan engines that each produces 71.2 kN of thrust. If AR = 3.5, e = 0.85, CD, = 0.02 a....

III. Prove by induction the following problems:4. 52n+1 . 2n+2 + 3n+2 . 22n+1 is divisible by 19 for any positive integer n

QS 17-17 Profit margin L04 Calculate the profit margin for 2017 and evaluate the result against the industry average in Exhibit 17.11, explaining why it compares favourably or unfavourably (round to...

The following are partial balance shoels for Bank of Canada and 14 LVTS Participants BANK OF CANADA 14 LVTS Participants/Primary Dealers Consolidated Balance Sheet Assets(SB) Liabilities (3)...

What are the four classificaiton tree biases and how they can be addresses?

Compare and contrast debt financing and equity financing as ways of starting a new business. Does one have an overall advantage over the other? What situation is more favorable to the use of debt...

Write an SQL query to produce a list of all the products (i.e., product description) and the number of times each product has been ordered. Show how you constructed this query using a Venn or other...

Modify Problem and Exercise 7-51 so that you include the number of products in product line Basic that the customer ordered in March 2015.

In what ways is starting a data modeling project with a packaged data model different from starting a data modeling project with a clean sheet of paper?

What single payment six months from now would be equivalent to payments of $500 due (but not paid) four months ago, and $800 due in 12 months? Assume money can earn 7.5% compounded monthly.

Mohinder has financial obligations of $1000 due in 3 1/2 years and $2000 due in 5 years. 22 He wishes to settle the obligations sooner with a single payment one year from now. If money is worth...

What amount, 1 years from now, is equivalent to $7000 due in 8 years, if money can earn 6.2% compounded semiannually?