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, 04.07.2019 18:10

Afluid flows with a velocity field given by v=(x/t)i.. determine the local and convective accelerations when x=3 and t=1.

Answers: 2

Answer

Engineering, 04.07.2019 18:10

Shafts are machine elements that are used to a) carry axial loads b) direct shear loads c) transmit power d) rotate at constant speed e) none of the above circular and square shafts subjected to the same torque under the same circum behave a) the same way b) almost the same way

Answers: 2

Answer

Engineering, 04.07.2019 18:10

The higher the astm grain size number, the finer the gran is. a)-true b)-false

Answers: 2

Answer

Engineering, 04.07.2019 18:10

The flow rate of air through a through a pipe is 0.02 m5/s. a pitot static tube is placed in the flow. the radius of the pitot static tube is 1 mm. assuming the flow to be steady and the air to be at 300k, calculate the difference in total and static pressure if the diameter of the pipe is: (a) d 0.1 m d 0.05 m (c) d 0.01 m

Answers: 2

Answer

You know the right answer?

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

Questions