Question

In: Computer Science

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 sell more affiliated products to customers, etc.(

Solutions

Expert Solution

Okay so as everyone knows that Netflix is quite a popular these days. And most of the people are basically using Netflix and chilling these days. But it's not easy to maintain such a large scale company and basically a lot of data is required. Now that data can be of various type i.e, Data provided by the user or data deduced by the software system itself on the basis of the activities. So some of the common tables that can be used to data can probably be:

A) Three tables that can contain customer data should be:

        (a) User Details - all the info required to make profile like name, contact info, etc.

        (b) Billing Details- Details related to monthly billing and subscription

        (c) User Activity- Rating and watch history based on which recommendations can be given.

B)

i) User Details: Name, Phone Number, Email Address, Username(profile name), Country, Gender, Date of Birth etc.

ii) Billing Details: Monthly/Yearly due, Day of subscription, the Expiry date of Subscription, Saved credit card details(for a fast forward mode of payment), Information of selected Subscription plan(premium, VIP sort of thing), phone number(for OTP), charges, payment mode etc.

iii) User Activity: watch history, IP of devices used for accessing Netflix, cookies, Searches, Ratings, Rewatch details, Nature of show etc

C) As I have given more than 5 attributes for each table I will use the top 5 attributes for description.

       a) i) Name( name of the user, varchar, length (50)(can be more as well people generally don't have that long names)).

        ii) Phone Number( users phone number, INT, length(15)).

             iii) Email Address( user's email id, VARCHAR, length(30)).

           iv) Profile name( name used on profile, VARCHAR, length(10)).

           v) Country ( country user living in, VARCHAR, length(20)).

      b) i) Due( monthly/yearly amount that is due, FLOAT, length(20)).

          ii) Day of subscription(the day on which user subscribed, DATE, length(8)).

          iii) Expiry of subscription( The day on which subscription ends, DATE, length(8)).

          iv) Saved credit card details( Credit card number, LONG INT, length(20)).

          v) Phone number( for OTP purpose, INT, Length(10)).

        c) i) watch history( VARCHAR, LENGTH(100)).

            ii) IP Addresses( IP of devices used for accessing Netflix, VARBINARY, length(16)).

            iii) Searches( Varchar, length(100)).

            iv) Ratings(rating out of 10, FLOAT, length(5)).

                v) Nature of show(genre, VARCHAR, length(20)).

D) Well, there are various reasons to do so, these big companies need and collect more and more data in order to improve their services, for example, IP address helps in keeping the track of devices you are using for accessing software so that if some other device is used you can be notified in advance for security reasons. Other than that credit card details are stored for making the payment process simple so that instead of typing for card number again you can just type few credentials and can make safe payment. All the cookies and histories are used to improve user interaction with the software, a lot of big analytics and machine learning is applied to that data in order to improve the recommendation system so that you can watch shows of a particular genre that you like. Phone numbers and email ids are used for account recovery in case the person forgets his login credentials. Hence these are several ways in which the data is used by Softwares like Netflix. And as we belong to a computer science background we know that data is key.


Related Solutions

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...
Identify a random variable for which data most be collected over time and you think the...
Identify a random variable for which data most be collected over time and you think the passage of time may influence the behavior tor of the random variable. Collect at least 30 observations on this random variable. Construct a time-series plot (or paste the plot created from Minicab). This section should include the definition of the random variable, why you think time may influence the data. how where you collected the data. the time-series plot. and meaningful commentary on the...
Tables:  Write the HTML code for a table data cell that contain the text “Holiday” and spans...
Tables:  Write the HTML code for a table data cell that contain the text “Holiday” and spans across 3 rows and 4 columns.
think about a company that sells clothes and the types of financial data that would be...
think about a company that sells clothes and the types of financial data that would be included and excluded in differential analysis. Propose which specific revenues and costs should be considered in an evaluation to drop or keep a: A)Customer and B)Product line. In addition, explain sunk and opportunity costs as they relate to your selected company. Should these costs be considered in differential analysis? Why or why not?
Think about the types of financial data that would be included and excluded in differential analysis....
Think about the types of financial data that would be included and excluded in differential analysis. Propose which specific revenues and costs should be considered in an evaluation to drop or keep a: Customer Product line In addition, explain sunk and opportunity costs as they relate to your selected company. Should these costs be considered in differential analysis? Why or why not?
Looking at Apple INC., think about the types of financial data that would be included and...
Looking at Apple INC., think about the types of financial data that would be included and excluded in differential analysis. Propose which specific revenues and costs should be considered in an evaluation to drop or keep a: Customer Product line, In addition, explain sunk and opportunity costs as they relate to Apple. Should these costs be considered in differential analysis? Why or why not?
Question 1) Identify the type of data that would be used to describe a response. Time...
Question 1) Identify the type of data that would be used to describe a response. Time in Line to Buy Groceries A. Qualitative (Categorical) B. Quantitative - Continuous C. Quantitative - Discrete Question 2) Identify the type of data that would be used to describe a response. Most Watched Television Show A. Quantitative - Discrete B. Quantitative - Continuous C. Qualitative (Categorical) Question 3. lege administrator wants to survey 250 students that attend her college to see if students are...
Description of Data The data being used for this lab are based on data collected after...
Description of Data The data being used for this lab are based on data collected after the 2009 war ended that was between Israel and the Hamas militias in the Gaza Strip. Responses were obtained from 200 individuals that were exposed to rocket attacks during that period. The variables in the study include: ID: Used to indicate the ID# of the participant family income: The household income of the individuals (expressed in thousands) gender: The gender of the individuals that...
Think about a healthcare area of interest that you would like to work. Identify one activity...
Think about a healthcare area of interest that you would like to work. Identify one activity a manager in this area does to advance organizational excellence in each of the following Baldrige framework categories: 1. Strategy 2. Customers 3. Workforce 4. Operations NO PLAGARISM & CITE REFERENCE
1. You have collected and partially analyzed the following data about three different stocks in MSM...
1. You have collected and partially analyzed the following data about three different stocks in MSM           Stock 1                         Standard Deviation of returns =12% Probability Return 50% Chance    20%                              50% Chance    -4%                                        Stock 2                         Standard Deviation of returns =19.5% Probability Return 30% Chance    30%                              40% Chance    10%                              30% Chance    -20%           Stock 3                        Standard Deviation of returns =12% Probability Return 10% Chance     30%     40% Chance     15% 40% Chance     10%           10% Chance    -21% Instructions: Assuming you are a rational...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT