Question

1. 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#	Date	Amount
S-101	10/05/2016	2549.90
S-105	11/01/2016	949.95
S-107	11/02/2016	1209.70
S-108	11/06/2016	699.90

• Inventory #unchecked
• Salesperson #unchecked
• Customer #unchecked
• Sales #unchecked
• Remittance Advice #unchecked
• Cashier #unchecked
• Receipt #unchecked
• Cashunchecked

2.

Think about data collected and used by Netflix. (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.)

Required:

a. Identify three tables that would contain customer or subscription data.

1.Sales table unchecked

2. Cash receipt table unchecked

3.Payment detailunchecked

4.Employee codeunchecked

5.Customer tableunchecked

b. For each table given below, list five attributes (you may include primary and foreign keys as well as non-key attributes).

Customer table:

1.Customer name unchecked

2.Customer zip unchecked

3.Salary basic unchecked

4.Customer#unchecked

5.Customer phone#unchecked

6.Customer email addressunchecked

Sales table:

1.Purchaseunchecked

2.Sales#unchecked

3.Employee#unchecked

4.Sales dateunchecked

• Customer#unchecked
• Item#unchecked

Cash receipt:

• Cash receipt#unchecked
• Cash receipt amountunchecked
• Cash receipt dateunchecked
• Customer#unchecked
• Account detailunchecked
• Sales#unchecked

Answer 1

1. Sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Foreign keys that should be added to the table to link all of the data elements are as below:

• Inventory
• Salesperson
• Customer
• Sales

2. (a) Three tables that would contain customer or subscription data.:

• Sales table
• Cash receipt table
• Customer table

2. (b) 5 Attributes:

Customer Table:

1. Customer name
2. Customer zip
3. Customer
4. Customer phone
5. Customer email

Sales Table:

1. Sales
2. Employee
3. Sales date
4. Customer
5. Item

Cash Receipt:

1. Cash receipt
2. Cash receipt amount
3. Cash receipt date
4. Customer
5. Account detail