Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the following statements is/are true about the table shown below? ItemQuantity Salesperson Number Subtotal Tax TotalDue 3 Item Number itemPrice 1 $1.30 2

image text in transcribed

Which of the following statements is/are true about the table shown below? ItemQuantity Salesperson Number Subtotal Tax TotalDue 3 Item Number itemPrice 1 $1.30 2 $2.00 1 CustomerInvoice InvNumber CustName 1 Andersen 1 Andersen 1 Andersen 2 Johnson 2 Johnson $0.27 SalesPersonName Smith Smith $12.73 CustNumber CustAddr 1 123 Elm 1 123 Elm 1 123 Elm 3 333 Main $3.90 $4.00 2 1 $0.28 $12.73 $12.73 3 $5.40 1 1 1 Smith $5.40 $0.38 $0.38 3 $5.40 1 2 Jones $5.40 $7.38 3 333 Main 4 $2.00 2 2 $0.11 $7.38 Jones Smith $1.50 $ $8.00 3 Jackson 4 456 1st 2 $2.00 4 1 $0.56 $15.35 $15.35 3 Jackson 4 456 1st 1 $1.30 2 1 Smith $2.60 $0.18 3 4 4 $2.00 5 1 Smith $0.26 $15.35 Jackson Andersen 456 1st 123 Elm $3.75 $1.30 4 1 6 $1.30 1 5 Andersen $0.09 $1.39 A. CustName -> InvNumber B. CustNumber -> Salesperson Number O C. ItemNumber -> ItemQuantity D. Salesperson Number -> Sales PersonName O E. Both A and B above are true. O Both A and C above are true. O All of the above are true

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

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions

Question

Why do HCMSs exist? Do they change over time?

Answered: 1 week ago