In: Accounting
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:
The following are the 3 tables that would contain client or membership information from Netfilx:
Client Table, Payment Details, Sales Tables
If it's not too much trouble take note of that every one of these tables are essentially identified with the buyer. Client table will have points of interest around client e.g. date of joining, last dynamic, last installment date, current membership and so forth. Then again, Payment tables will have points of interest of the considerable number of installments made in a specific month. Additionally, Sales tables will have pointers which would appear against every client ID, what number of offers are made in units for every item advertising.
Client Tables:
5 traits from client tables might be:
Client Phone no., Salary essential, Customer # or ID, Customer email address, Customer Name
Among every one of the qualities, Customer # or Customer ID gathered be novel for every one of the clients.
Therefore, Customer # or Customer ID would be an essential key in the tables while the various keys are remote keys (e.g. Pay fundamental).
Deals table
5 traits from deals tables might be:
Deals #,
Item#,
Customer #,
Sales Date and Employee date.
In Sales table, we are typically intrigued more in the units sold for an item.
Along these lines, in this table, the essential key ought to be Item #.
Then again, we are likewise inspired by knowing which client purchased which item.
Accordingly, Customer # or ID is the remote key for this situation.
Money Receipt
5 properties from money receipt tables might be:
Sales#,
Cash receipt set out,
Customer#,
Cash Receipt #,
Cash Receipt Amount
In this table, we are intrigued more in knowing the points of interest around a money receipt.
Therefore, Cash receipt # ought to be considered as an essential key for this situation.
Then again, We are likewise inspired by knowing which client spent how much on a specific decent.
In this way, Item # or Customer # will turn out to be a remote key for this situation which will enable us to delineate subtle elements from client tables and things points of interest from Sales table.