Think about data collected and used by Netflix.

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

1. Cash receipt tableunchecked
2. Sales tableunanswered
3. Employee codeunanswered
4. Customer tableunanswered
5. Payment detailunanswered

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 nameunanswered
2. Customer zipunanswered
3. Salary basicunanswered
4. Customer#unanswered
5. Customer phone#unanswered
6. Customer email addressunanswered

Sales table:

1. Item#unanswered
2. Customer#unanswered
3. Purchaseunanswered
4. Sales dateunanswered
5. Sales#unanswered
6. Employee#unanswered

Cash receipt:

1. Cash receipt dateunanswered
2. Cash receipt amountunanswered
3. Account detailunanswered
4. Cash receipt#unanswered
5. Customer#unanswered
6. Sales#

Question

contestada

Respuesta :

Harrisonjob Harrisonjob · Answer 1 · 2020-09-17T03:14:45+02:00

Answer:

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

3. Employee code

5. Payment detail

4. Customer 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:

1. Customer name

4. Customer#

5. Customer phone#

6. Customer email address

2. Customer zip

Sales table:

1. Item#

3. Purchase

4. Sales date

5. Sales#

2. Customer#

Cash receipt:

1. Cash receipt date

3. Account detail

6. Sales#

2. Cash receipt amount

4. Cash receipt#

Explanation: