How many of the artist works have been sold

Assignment Help Database Management System
Reference no: EM13335047

a. List the details of any works of art (including the Artist who created the work) that have more than one copy recorded in the database.

b. List the details of any work of art (including the Artist who created the work) that has an Expressionist style.

c. List the details of the works of art (including the Artist who created the work, and the acquisition and asking price details) currently held in the gallery (i.e., works of art that have not been sold).

d. List the sales for each customer (i.e., when a customer purchases a work of art from the Gallery, a transaction line is created. For a purchase, there will be values in the DateSold and SalesPrice columns). The query should include the details of the customer, the transaction and the work of art purchased.

e. List the names of the deceased artists and the number of years of age they were when they died (for example, an artist born in 1950 and deceased in 2001 has an age of 51).

f. The sum of the acquisition price of works of art for each year (for example, if there were two works of art purchased for $1500 and $1000 in
2007, and one work of art purchased for $500 in 2008, then the sums would be $2500 and $500, for 2007 and 2008 respectively).

g. Calculate the profit made on works of art that have been sold (i.e., the profit/loss on an individual work of art is the difference between the
acquisition price and the sales price).

h. Which artist has had the most works of art sold, and how many of the artist's works have been sold?

i. Sales of which artist's works have resulted in the highest average profit (i.e., the average of the profits made on each sale of works by an artist), and what is that amount?

j. Customer name of any customers who have an interest in ALL artists.

Reference no: EM13335047

Questions Cloud

Decribe the concept of six sigma and the levels : Decribe the concept of Six Sigma and the levels. How will this impact the TQM/CQI process in the U.S. Healthcare system if adopted?
The value of real gdp in 1997 : The value of real GDP in 1997? The value of nominal GDP in 1998? The rate of inflation between 1997 and 1998?
Calculate the intensity of the light : A perfectly reflecting flat mirror is uniformly illuminated by light striking it perpendicularly. Calculate the intensity of the light
What is the time required to complete three full revolutions : You hold a 23.5-kg car tire in your hand and, standing in place, rotate the tire in a horizontal circle of radius r = 1.10 m starting from rest. What is the time required to complete three full revolutions
How many of the artist works have been sold : List the names of the deceased artists and the number of years of age they were when they died (for example, an artist born in 1950 and deceased in 2001 has an age of 51).
What is the altitude of the projectile at this instant : A projectile is fired straight upward from the Earth's surface at the South Pole with an initial speed equal to one third the escape speed. What is the altitude of the projectile at this instant
What is the centripetal acceleration of the child : A 55.0-kg child takes a ride on a Ferris wheel that rotates four times each minute and has a diameter of21.0 m. What is the centripetal acceleration of the child
Explain the law of diminishing marginal utility : Explain the law of diminishing marginal utility.
What is the mass of the copper block : A copper block is removed from a 301?C oven and dropped into 1.20kg of water at 20.1?C. What is the mass of the copper block

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd