A sales invoice typically includes the date of sale, salesperson, customer data,
ID: 2548094 • Letter: A
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
Foreign key is uded to link two data tables together.In this case foreign key can be Customer, Receipt and Sales
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.