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

Design program that will serve as database for keeping track

You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing

Write one sql statement to implement

Write ONE SQL statement to implement each of the tasks. Please do not hardcode to skip joins (your code need to work regardless of rows in the tables) - write an anonymous P

Normalize the following table into first normal form

Normalize the following table into first normal form. The table uses one row to record information about each student. A student may take one or more electives. This table i

Explain what information is available in relational database

Explain what information is available from relational database containing one relation with attributes Name, Employee identification number, and Address which is not availab

Create and test a database in mysql

CSC00228 - Database Systems - create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements th

Create a mysql database

Create a Database and modify your script to reference your Database. Download the tutorial Creating a Database in MySQL Omnymbus Environment from the folder in Doc-Sharing ti

Develop a domain model for the case study

The objective of the assignment is to apply and consolidate skills acquired in the requirement and analysis disciplines through analysis of a simple case study, and to expre

Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all c


Write a Review

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