Class ACC 3202: Accounting In x M MHE Reader X Search Results | Course Hero x * Homework Help - Q&A from Or x + A player-ui.mheducation.com/#/epub/sn_1400#epubcfi(%2F6%2F132%5Bdata-uuid-1b519ef8ce244308bf5d7c54812fce36%5D!%2F4%2F2%5Bdata-uui.. Background for Problems 10 through 14 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-to- many 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 AU-1 Adams Eric Eric168@yahoo.com (714) 833-2419 AU-2 Brown Jennifer jenifferb@gmail.com (619) 596-0012 AU-3 Davis Keith keithd@gmail.com (212) 342-5680 AU-4 Newport Kevin kevinn@hotmail.com (301) 947-7741 AU-5 Pham John johnpham@gmail.com (617) 645-3647 AU-6 Sviokla Julia jsviokla@yahoo.com (805) 498-1688 Book Book ID Title Area Year Edition Publisher B-1 Accounting Principles Financial Accounting 2016 8 Wiley B-2 Cost Management Management Accounting 2017 3 McGraw-Hill B-3 Accounting Information Systems Information Systems 2017 2 McGraw-Hill B-4 Individual Taxation 2017 Taxation 2018 6 PearsonClass ACC 3202: Accounting In x M MHE Reader X Search Results | Course Hero X Homework Help - Q&A from Or x + A player-ui.mheducation.com/#/epub/sn_1400#epubcfi(%2F6%2F132%5Bdata-uuid-1b519ef8ce244308bf5d7c54812fce3b%5D!%2F4%2F2%5Bdata-uui.. G Book Book ID Title Area Year Edition Publisher B-1 Accounting Principles Financial Accounting 2016 8 Wiley B-2 Cost Management Management Accounting 2017 3 McGraw-Hill B-3 Accounting Information Systems Information Systems 2017 2 McGraw-Hill B-4 Individual Taxation 2017 Taxation 2018 6 Pearson B-5 Intermediate Accounting Financial Accounting 2016 1 Wiley B-6 Advanced Accounting Financial Accounting 2017 1 McGraw-Hill 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-6Class ACC 3202: Accounting In x M MHE Reader X Search Results | Course Hero X Homework Help - Q&A from Or x + A player-ui.mheducation.com/#/epub/sn_1400#epubcfi(%2F6%2F132%5Bdata-uuid-1b519ef8ce244308bf5d7c54812fce3b%5D!%2F4%2F2%5Bdata-uui. Customer Customer ID Last Name | First Name Email C-1 Black Emily Ewb2003@yahoo.com C-2 Brown Jack jackjack@gmail.com C-3 Easton Anderson anderson.easton@gmail.com C-4 Jennix May jennixm@hotmail.com C-5 Venable Judy Judy. Venable@gmail.com C-6 White Ashley Ashley 2015@yahoo.com C-7 Williams Eric Williams_e@yahoo.com Sales_Line_Item Sales Date Customer ID | Book ID Quantity Unit price 9/1/2020 C-7 B-3 $205 9/1/2020 C-7 B-1 $221 9/1/2020 C-1 B-6 30 $ 195 9/2/2020 C-5 B-2 60 $ 199 9/2/2020 C-5 B-5 25 $210 9/2/2020 C-3 B-2 $245 9/2/2020 C-3 B-6 $215 9/2/2020 C-3 B-4 $160 9/3/2020 C-2 B-1 $221Class ACC 3202: Accounting In x M MHE Reader X Search Results | Course Hero x * Homework Help - Q&A from Or x + C A player-ui.mheducation.com/#/epub/sn_1400#epubcfi(%2F6%2F132%5Bdata-uuid-1519ef8ce244308bf5d7c54812fce3b%5D!%2F4%2F2%5Bdata-uui... -) Q ATA Sales_Line_Item Sales Date | Customer ID | Book ID Quantity |Unit price 9/1/2020 C-7 B-3 $205 9/1/2020 C-7 B-1 $221 9/1/2020 C-1 B-6 30 $195 9/2/2020 C-5 B-2 60 $199 9/2/2020 C-5 B-5 25 $210 9/2/2020 C-3 B-2 $245 9/2/2020 C-3 B-6 $215 9/2/2020 C-3 B-4 $160 9/3/2020 C-2 B-1 $221 10. Ellen asks you to give her a list of the books that each author wrote. Write a complete SQL statement to provide the Page 128 information to Ellen, including author names, book titles, publishers, and the years of publication. L LO 4-2, _LO 4-3 11. Ellen wants to know how many books each author wrote. Write a SQL statement to provide such information to Ellen. LLO 4-2, _ LO 4-3 12. You are going to send emails 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. LLO 4-2, L LO 4-3 13. Ellen wants to know how many copies of each book were sold. Write a SQL statement to obtain the necessary information you think Ellen wants. & LO 4-2, C LO 4-3 14. Ellen wants to know the dollar amount of total sales made on September 1, 2017. Write a SQL statement to obtain the necessary information you think Ellen wants. & LO 4-2, 5 LO 4-3
