View the step-by-step solution to:

Question

Based on the attached Database scheme, I am trying to figure out SQL query for the following steps

/>

  1. The administrator adds 3 products for sale: iPhone XS ($1000), light bulb ($8), a box of AA battery ($20).
  2. A customer registers an account with the name "Tom Cruise".
  3. Then, the customer adds two addresses to his account: one is home address (for shipping and billing), the other is the company address (for shipping purpose).
  4. After that, he adds two credit cards. Both cards use his home address as the billing address.
  5. Now that the account is ready, he browses the website and adds these to his shopping cart: 1 iPhone XS, 3 light bulbs, 4 boxes of AA batteries.
  6. Then, he places the order.
  7. To make sure he placed the correct order, he opens the order detail page and see the order's status, date, credit card used, shipping/billing address, total amount, and a list of items he bought.
  8. After some time, the administrator updates the light bulb's price to $10 dollars. After the price update, if the customer checks the order he placed a long time ago, will he be able to see the same total amount as before? Explain why.

DBS.JPG

DBS.JPG

Top Answer

8. To ensure the customer will not see the updated price, the query on #6... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question