Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following UML is to be used for the next 5 questions If we want to find out which product has the highest sale value,

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The following UML is to be used for the next 5 questions If we want to find out which product has the highest sale value, it would make the most sense to link which tables? Products - Clothing Line Products - Cash Customers - Cash None of the above If we want to find out who (customer name) is our best customer (the one who we scored highest total sale on), it would make the most sense to link which tables? No need to link any table, we can just have to sort Customers table No need to link any table, we can just have to sort Sales table Sales - Customers Sales-Cash If we want to find out who (Employee name) is our best seller (the one who * 2p we scored highest total sale ), it would make the most sense to link which tables? Employee - Cash Employee - Cash Receipts Employee-Sales Employee-Customer If we want to find out which product has the highest selling price, it would 2p make the most sense to link which tables? No need to link any table, we can just have to sort Product table by Product price (descending) No need to link any table, we can just have to sort Cash Receipts by Cash receipt amount (descending) Product - Cash Receipts Product - [Sales- Product] If we want to find out which employee has least surfing experience, it would make the most sense to link which tables? No need to link any table, we can just have to sort Employees table by Year of surfing experience (ascending) No need to link any table, we can just have to sort Employees table by Employee names (ascending) Employees-Cash receipts Employees-Cash The following UML is to be used for the next 5 questions If we want to find out which product has the highest sale value, it would make the most sense to link which tables? Products - Clothing Line Products - Cash Customers - Cash None of the above If we want to find out who (customer name) is our best customer (the one who we scored highest total sale on), it would make the most sense to link which tables? No need to link any table, we can just have to sort Customers table No need to link any table, we can just have to sort Sales table Sales - Customers Sales-Cash If we want to find out who (Employee name) is our best seller (the one who * 2p we scored highest total sale ), it would make the most sense to link which tables? Employee - Cash Employee - Cash Receipts Employee-Sales Employee-Customer If we want to find out which product has the highest selling price, it would 2p make the most sense to link which tables? No need to link any table, we can just have to sort Product table by Product price (descending) No need to link any table, we can just have to sort Cash Receipts by Cash receipt amount (descending) Product - Cash Receipts Product - [Sales- Product] If we want to find out which employee has least surfing experience, it would make the most sense to link which tables? No need to link any table, we can just have to sort Employees table by Year of surfing experience (ascending) No need to link any table, we can just have to sort Employees table by Employee names (ascending) Employees-Cash receipts Employees-Cash

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

Wiley CPA Exam Review Auditing And Attestation 2011

Authors: Patrick R. Delaney, O. Ray Whittington

8th Edition

0470554347, 978-0470554340

More Books

Students also viewed these Accounting questions