Question

In: Accounting

Think about data collected and used by Netflix. (You may select more than one answer. Single...

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

Solutions

Expert Solution

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.


Related Solutions

Think about the data collected and used by Netflix. A) Identify three tables that would contain...
Think about the data collected and used by Netflix. A) Identify three tables that would contain customer or subscription data. B) For each table identified in a list five attributes (you may include primary and foreign keys as well as non-key attributes) C) Describe each attribute using elements from data dictionary (e.g. descriptions, field length, field type, etc.) D) Why would Netflix be interested in storing and tracking these attributes (e.g. to enhance customer service or future customer sales, to...
Which of the following statements always apply to corporations?  (You may select more than one answer. Single...
Which of the following statements always apply to corporations?  (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.) Unlimited liabilityunchecked Limited lifeunchecked Ownership can be transferred without affecting operationsunchecked Managers can be fired with no effect...
Which of the following is/are true about FUTA obligations? (You may select more than one answer....
Which of the following is/are true about FUTA obligations? (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.) FUTA is subject to a 5.4 percent reduction based on employer and state factors.unanswered FUTA applies to...
(Select all correct answers; one or more than one answer may be correct.) In cases of...
(Select all correct answers; one or more than one answer may be correct.) In cases of renal failure, plasma (extracellular) concentrations of K+ may increase from normal levels of 4-5 mM to 10 to 12 mM. From what you know of the effects of increasing extracellular K+ on the membrane potential (EK = RT/zF x ln[Ko/Ki) and the effects of membrane potential on the HCN channel (hint, remember what H stands for), you would expect the increased extracellular concentration of...
1. Which of the following describes an endocytosis? There may be more than one answer. Select...
1. Which of the following describes an endocytosis? There may be more than one answer. Select one or more: a. A cell engulfs a bacterium by pushing its cell membrane around the bacterium forming a phagosome that will pinched off from the cell membrane and enter the cytoplasm. b. Specific solutes accumulate along an indented cell membrane that will form into an endosome and it will pinch off from the cell membrane and enter the cytoplasm. c. A process that...
Indicate which of the following explain wage stickiness. Instructions: You may select more than one answer....
Indicate which of the following explain wage stickiness. Instructions: You may select more than one answer. Click the box with a check mark for correct answers and click to empty the box for the wrong answers. Minimum wage laws unanswered Union contracts unanswered Efficiency wages unanswered Wages paid to oil and gas workers unanswered Fast-food workers unanswered Trailing indicators unanswered
1.Which of the following characterizes a relative polycythemia? There may be more than one answer. Select...
1.Which of the following characterizes a relative polycythemia? There may be more than one answer. Select one or more: a. A type of polycythemia that promotes erythropoiesis; therefore, increases the number of circulating erythrocytes above normal. b. A type of polycythemia that does not promote erythropoiesis but increases the number of circulating erythrocytes above normal. c. Hypovolemic shock d. Anemia e. High altitude 2.What is TRUE about diabetes? There may be more than one answer. Select one or more: a....
What is TRUE about the autonomic division? There may be more than one answer. (2 pts)...
What is TRUE about the autonomic division? There may be more than one answer. (2 pts) Select one or more: a. The autonomic division consists of the parasympathetic and sympathetic divisions that target the cardiac cells, smooth muscle cells, and glands. b. The parasympathetic and sympathetic divisions are made of pre-ganglionic neuron that synapses with the post-ganglionic neuron at the neuromuscular junction. c. The pre-ganglionic neuron of both parasympathetic and sympathetic would secrete acetylcholine at the axon terminal and it...
US firms are: ( you may choose more than one answer) a. all subject to the...
US firms are: ( you may choose more than one answer) a. all subject to the same corporate governance provisions and their shareholders enjoy similar rights b. allowed to have multiple classes of shares c. incorporated in a state and their corporate governance follows the laws of that state d. usually rank among the top in term of corporate governance in the world
You may choose more than one answer. Which of the following is a mechanism of signal...
You may choose more than one answer. Which of the following is a mechanism of signal amplification in the cAMP-PKA pathway? One signal molecule, epinephrine, activates lots of G-proteins. When activated, adenylyl cyclase synthesizes many cAMP molecules. cAMP-activated protein kinase A (PKA) can activate a number of target proteins by phosphorylation. Proteins phosphorylated by PKA can further activate other proteins that make other products
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT