Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Communication Audit In Globally Integrated R And D Project Teams

Authors: Justyna Alnajjar

1st Edition

3631666608, 978-3631666609

More Books

Students also viewed these Accounting questions

Question

Why are child custody evaluations value-laden?

Answered: 1 week ago

Question

5. Describe how contexts affect listening

Answered: 1 week ago