Engineering, 18.12.2019 07:31 jaimes04

Write sql commands to support photo applications, sales applications and reporting applications. photo applications include adding a new photo, deleting an existing photo, changing photo information, and querying photo information. sales applications include processing a sale, viewing a sale (given transactionid), finding sales (given different features e. g. date, customer name reporting application involve generating reports (e. g. find the total sales per customer).

in particular, write sql commands to support the following actions. you should be able to demonstrate the implementation of these actions.

1. list customers who spent more than 100$ for the photos.
2. list photos which were not bought.
3. list customers who bought all photos (portraits) in which a model x modeled.
4. list photographers who influenced exclusively photographers who are us citizens.
5. list photographers which took only portrait photos.
6. list transactions (transid) which contain more than 3 photos.
7. list models who modeled in all photos taken by photographer y.
8. rank the photographers by the total cost (sum of prices) of the photos they took.
9. delete from relation photo the photo with photoid=x.
10. update the photographer name of the photo with photoid=x to y.
11. compute total sales per customer 12. compute total sales per photographer sorted by photographer 13. compute total sales by photo type (portrait, landscape

Answers: 1

Show answers

Another question on Engineering

Engineering, 03.07.2019 14:10

Amass of m 1.5 kg of steam is contained in a closed rigid container. initially the pressure and temperature of the steam are: p 1.5 mpa and t 240°c (superheated state), respectively. then the temperature drops to t2= 100°c as the result of heat transfer to the surroundings. determine: a) quality of the steam at the end of the process, b) heat transfer with the surroundings. for: p1.5 mpa and t 240°c: enthalpy of superheated vapour is 2900 kj/kg, specific volume of superheated vapour is 0. 1483 m/kg, while for t 100°c: enthalpy of saturated liquid water is 419kj/kg, specific volume of saturated liquid water is 0.001043m/kg, enthalpy of saturated vapour is 2676 kj/kg, specific volume of saturated vapour is 1.672 m/kg and pressure is 0.1 mpa.

Answers: 3

Answer

Engineering, 04.07.2019 18:10

Ifa component is made of two or more materials with different modulus of elasticity (e), it is called a composite member and we calculate the factor·n". mention the formula for calculating n". also, ifn> 1, explain what will happen to the 1. transformed.gi) ifn 1, what will happen to the material when transformed material when

Answers: 1

Answer

Engineering, 04.07.2019 19:20

Afan that can provide air speeds up to 60 m/s is to be used in a low-speed wind tunnel with atmospheric air at 35 c. if one wishes to use the wind tunnel to study flat-plate boundary layer behavior up to reynolds numbes of re 10, what is the minimum plate length that should be used? at what distance from the leading edge would transition occur if the critical reynolds nurnber were rer,e = 5 × 105?

Answers: 2

Answer

Engineering, 05.07.2019 10:10

What is the correct way to measure the overall length of a boat? measure from the tip of the bow to the highest point on the gunwale. measure from the tip of the bow in a straight line to the stern of the boat. measure from the tip of the bow in a straight line to the back seat. measure from port to starboard at the boat's widest point.

Answers: 1

Answer

You know the right answer?

Write sql commands to support photo applications, sales applications and reporting applications. pho...

Questions