Answered step by step
Verified Expert Solution
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,
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
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