Answered step by step
Verified Expert Solution
Link Copied!

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,

3. 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 4 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 3 letters of customer last name, then the number produced by multiplying the customer birthday by their birth month, and then the uppercase first 3 letters of their first name. For example: John Smith has a birthday on 7/18, so his new password would be smi126JOH. Order by customer first name, alphabetically. (35%)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Knowledge Discovery In Databases

Authors: Animesh Adhikari, Jhimli Adhikari

1st Edition

3319132121, 9783319132129

More Books

Students also viewed these Databases questions