A sales invoice typically includes the date of sale, salesperson, customer data,

Question

A sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Sales Table Invoice# S-101 S-105 S-107 S-108 Date Amount 10/05/2016 2549.90 11/01/2016 949.95 11/02/2016 1209.70 11/06/2016 699.90 Customer # Receipt # Inventory # Salesperson # Sales #

Explanation / Answer

Solution:

Inventory#, Cutomer#, salePerson# and sales# should be the foreign key to make it possible.

Customer # will be used to fetch the customer details

Inventory # will be used to fetch the items

Salesperson # will be used to fetch the Salesperson details

Sales # will be used to fetch the Sales details

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.