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