Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 . The system is hacked! In an attempt to help protect customer information, Netflix now needs you to provide a query that will show,
The system is hacked! In an attempt to help protect customer information, Netflix now needs you to provide a query that will show, specifically in this order, all affected customers, the last digits of their credit card number, their current account password, a new system generated password, and email so that Netflix may notify them of the password change to come. Affected customers include Discover and Mastercard users. Customer name should be displayed in one column, with a space in between the first and last name ex: John Smith Credit card numbers should include asterisks in place of all digits preceding the last four digits, which will be left visible, regardless of credit card length. The new system generated password should be formatted as follows: lowercase first letters of customer last name, then the number produced by multiplying the customer birthday by their birth month, and then the uppercase first letters of their first name. For example: John Smith has a birthday on so his new password would be smiJOH Order by customer first name, alphabetically.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started