Question

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.

Customer table

Cash receipt table

Payment detail

Employee code

Sales table

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

Customer table:

Customer phone#

Salary basic

Customer#

Customer email address

Customer name

Customer zip

Sales table:

Sales#

Purchase Item#

Customer#

Sales date

Employee#

Cash receipt:

Sales#

Cash receipt date

Customer#

Account detail

Cash receipt#

Cash receipt amount

Answer 1

a.

Customer table

Cash receipt table

Sales table- These tables contain customer or subscription data.while other two tables mentioned in the Q are no where related to subscirption or customer data

b.

(i)

Customer table: should contain following data

Customer phone#

Customer#

Customer email address

Customer name

Customer zip

while Salary basic is no where related to customer table

(ii)

Sales table: should contain the following data

Sales#

Customer#

Sales date

The following Purchase Item#, Employee# have no correlation to sales table

(iii)

Cash receipt should contain the following

Sales#

Cash receipt date

Customer#

Account detail

Cash receipt#

Cash receipt amount

All the above data is relevant to cash receipt data