SQL Queries for Pine Valley Furniture Corporation

Assignment Help Database Management System

Reference no: EM131729448

Database Management Assignment - SQL Queries for Pine Valley Furniture Corporation

Part 1: In this part, you will continue with the queries for Pine Valley Furniture Corporation that you worked with in Assignment 3.

Work to Submit

7-60 (You can defined two subqueries and then use UNION to merge rows from the two tables)

7-63 (This requires a self-join of table with itself. Alternatively, you can you a nested query)

7-67 (You can defined two subqueries and then use INTERSECTION only rows that are common to both)

7-71 (You may want to define a view to find the average order quantity for each product and then use the result of this view to find orders that have orders for each product that exceed the average)

7-73 (This query assumes that a product can come up more than once in a query. Use a nested query where the inner query finds the sum of quantity for each customer id and product id. The outer query then keeps only one row for each product corresponding to maximum value of the sum of quantity across different customers)

Part 2: you will use normalization to come up with 3NF tables.

4-28

4-31

4-54

4-55 Hint for part a: The functional dependencies for this relation are given in the following diagram.

Textbook - Modern Database Management, 12th Edition by Jeffrey A. Hoffer, V. Ramesh and Heikki Topi

Attachment:- Assignment Files.rar

Reference no: EM131729448

Questions Cloud

What percentage of the time does the sum of the dots : Determine what percentage of the time does the sum of the dots on the two dice equal 8 in the simulation - Writing a program that generates an accurate output

Identify the components of a tree : Familiar with the Tree data model. You're required to identify the components of a Tree using the MS Word.

Calculate the population parameter of interest : A question in a 2007 Gallup poll asked, "Do you think the penalties for underage drinking should be made more strict, less strict, or remain the same?"

Explain issue being debated about american healthcare system : Explain a current issue being debated about the American healthcare system. Explain two competing solutions to this problem.

SQL Queries for Pine Valley Furniture Corporation : ISGB 7973, Database Management Assignment - SQL Queries for Pine Valley Furniture Corporation. ou can defined two subqueries and then use UNION to merge rows

Considering replacing an old piece of machinery : A company is considering replacing an old piece of machinery, What is the sunk cost in this situation?

Compute ci that estimates the proportion of us families : Refer to Exercise. Calculate an 80% confidence interval that estimates the proportion of U.S. families with children that always has the television.

Write an essay about national security : Write an essay about National Security. Identify a current issue being debated about American national security. Explain two competing solution to this problem.

Integrative management practice module : Assuming you successfully completed the Integrative Management Practice module

User Account

All Pages