Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: In the partial database given below, indicate the table name(s) that are linked with the listed tables. If more than one table is applicable,
Required: In the partial database given below, indicate the table name(s) that are linked with the listed tables. If more than one table is applicable, select the option that contains multiple tables. Author Table Author ID Last Name AU-1 Adams AU-2 Brown AU-3 Davis AU-4 Newport AU-5 Pham AU-6 Sviokla First Name Eric Jennifer Keith Kevin John Julia Email Eric168@yahoo.com jenifferb@gmail.com keithd@gmail.com kevinn@hotmail.com johnpham@gmail.com jsviokla@yahoo.com Phone Number (714) 833-2419 (619) 596-0012 (212) 342-5680 (301) 947-7741 (617) 645-3647 (805) 498-1688 Book Table Book ID Title B-1 Accounting Principles B-2 Cost Management B-3 Accounting Information Systems B-4 Individual Taxation B-5 Intermediate Accounting B-6 Advanced Accounting Area Financial Accounting Management Accounting Information Systems Taxation Financial Accounting Financial Accounting Year Edition 2016 8 2017 3 2017 2 2018 6 2016 1 2017 1 Publisher Wiley McGraw-Hill McGraw-Hill Pearson Wiley McGraw-Hill Author_Book Table 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 Table Customer ID Last Name C-1 Black C-2 Brown C-3 Easton C-4 Jennix C-5 Venable C-6 White C-7 Williams First Name Emily Jack Anderson May Judy Ashley Eric Email Ewb2003@yahoo.com jackjack@gmail.com anderson. easton@gmail.com jennixm@hotmail.com Judy. Venable@gmail.com Ashley2015@yahoo.com Williams_e@yahoo.com Sales_line_item Sales Date Customer ID 9/1/2020 C-7 9/1/2020 C-7 9/1/2020 C-1 9/2/2020 C-5 9/2/2020 C-5 9/2/2020 C-3 9/2/2020 C-3 9/2/2020 C-3 9/3/2020 C-2 Book ID B-3 B-1 B-6 B-2 B B-5 B-2 B-6 B-4 B-1 Quantity 1 1 30 60 25 1 1 1 1 1 Unit Price $205 $221 $195 $199 $210 $245 $215 $160 $221 Table Name Linked With Author Table Book Table Author_Book Table Customer Table Sales_Line_Item
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started