Think about data collected and used by Netflix. (You may select more than one an
ID: 394151 • Letter: T
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
Explanation / Answer
Customer Table, Payment Details, Sales Tables
Please note that all these tables are primarily related to the consumer. Customer table will have details around customer e.g. date of joining, last active, last payment date, current subscription etc. On the other hand, Payment tables will have details of all the payments made in a particular month. Also, Sales tables will have indicators which would show against each customer ID, how many sales are made in units for each product offering.
5 attributes from customer tables may be:
Customer Phone no., Salary basic, Customer # or ID, Customer email address, Customer Name
Among all the attributes, Customer # or Customer ID is supposed to be unique for all the customers. Thus, Customer # or Customer ID would be a primary key in the tables while all the other keys are foreign keys (e.g. Salary basic).
5 attributes from sales tables may be:
Sales #, Item#, Customer #, Sales Date and Employee date.
In Sales table, we are usually interested more in the units sold for a product. Thus, in this table, the primary key should be Item #. On the other hand, we are also interested in knowing which customer bought which product. Thus, Customer # or ID is the foreign key in this case.
5 attributes from cash receipt tables may be:
Sales#, Cash receipt dare, Customer#, Cash Receipt #, Cash Receipt Amount
In this table, we are interested more in knowing the details around a cash receipt. Thus, Cash receipt # should be considered as a primary key in this case. On the other hand, We are also interested in knowing which customer spent how much on a particular good. Thus, Item # or Customer # will prove to be a foreign key in this case which will allow us to map customer details from customer tables and items details from Sales table.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.