Create a database $$Bank$,$ and then create a table $$customer$$ with the columns $($Cust$\_$id$,$ Cust$\_$name, login$\_$id$,$ password,

Acc$\_$no$,$ Aadhar$\_$no$,$ PAN$\_$no$,$ Mobile, Email, Bal$\_$amount$)$

$($i$)$ Create a view $$Cust$\_$masking$$ to de$-$identify customer details as

$$ No masking on Cust$\_$id$,$ Cust$\_$name, Bal$\_$amount

$$ Apply masking on login$\_$id to reveal only last five positions and mask all the remaining with symbol $$x$.$

$$ Apply masking on password to mask all positions with symbol $*$

$$ Apply masking on Acc$\_$no to reveal only last four positions and all the remaining should be masked.

$$ Apply masking on Aadhar$\_$no to reveal first two and last two positions and mask all the remaining with symbol $$#$$

$$ Apply masking on PAN$\_$no to reveal first two and last four positions and mask all the remaining with symbol $$$$$

$$ Apply masking on mobile to reveal last three positions and mask all the remaining with symbol $*$

$2.$ Write SQL statement to $($Use the schema in Q$1)$

$($i$)$ apply masking on email to replace it with randomly generated email

$($ii$)$ apply masking on email to replace it with randomly generated email from a dictionary

$3.$ Let us assume an Amazon ecommerce maintains an ecommerce database and stores their customer purchases in a table

called Purchases. The fields that they store about different purchases are: cust$\_$id$,$ login$\_$id$,$ password, cust$\_$name,

mobile$\_$no$,$ item, amount, card$\_$no$.$ Write DDL commands to create ecommerce database and Purchases table with given

fields.

For the purpose of secure communication with their customers, they decided to mask the data as mentioned below. Create

a view according to the criterion required by the Amazon ecommerce for providing de$-$identified details of purchases.

$$ cust$\_$id$,$ cust$\_$name, item, amount should be displayed without any masking

$$ Password field should not be added in the view

$$ Only last four characters should be revealed in login$\_$id and all the remaining characters should be masked with $*$

$$ Only last three characters should be revealed in mobile$\_$no all the remaining characters should be masked with $$x$$

$$ Only last four characters should be revealed in card$\_$no all the remaining characters should be masked with $$x$$