You are going to send e-mails to inform the customers that the books ordered have been shipped.

Question:

You are going to send e-mails to inform the customers that the books ordered have been shipped. Write a SQL statement to obtain the complete information on the book title(s), unit price(s), and the number of each book purchased to be sent to the customers?


Use the following information:
Ellen Novotny started an online bookstore in 2017. You are Ellen€™s best friend and promised to help her. Ellen asked you to create a small database to track the information on books and authors. You created the following tables: Author, Book, and Author_Book. The table Author_ Book is a relationship table to link the Author table and Book table because of the many-tomany relationship between the two tables. That is, each author may write many books and each book may have multiple authors. In general, each customer can purchase many books in a single transaction. Also, copies of the same book can be sold to different customers. Once an order is processed, the books are shipped right away. Based on these tables you have (see below), help Ellen to extract the information she needs from the database.


Author

Author ID Last Name First Name Email Phone number Eric 168@yahoo.com Eric (714) 833-2419 AU-1 Adams Jennifer (619) 596-0


Book

Book ID Title Year Edition Publisher Area B-1 Accounting Principles Financial Accounting 2016 8 Wiley McGraw-Hill Manage


Author_Book

Author ID _________ Book ID
AU-1 ............................. B-2
AU-1 ............................. B-5
AU-2 ............................. B-6
AU-3 ............................. B-2
AU-3 ............................. B-3
AU-4 ............................. B-2
AU-5 ............................. B-4
AU-6 ............................. B-1
AU-6 ............................. B-6


Customer


Sales_Line_Item

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Accounting Information Systems

ISBN: 978-1260153156

2nd edition

Authors: Vernon Richardson, Chengyee Chang, Rod Smith

Question Posted: