Consider a scenario of IT infrastructure where all employees can access the resources from a

centralized server. The server stores the database of employees such as employee details

$($EMP$\_$Details$)$ and login credentials $($EMP$\_$Logins$)$ of the employees to the centralized server.

Then assume that you are a database administrator who can set authentication and authorization

for employee$$s logins and privileged connecting to the database resided in the server.

$1.$ EMP$\_$Details table will contain attributes as EID, ENAME, designation, email, mobile,

address, bank$\_$acc$\_$no

$2.$ EMP$\_$Logins table will contain attributes as EID, Login$\_$ID$,$ password

a$.$ Login$\_$ID should be automatically created as EID@mycom.org and password should

be automatically created as EID@$123$ using trigger.

$3.$ The EMP$\_$Logins table should not be accessible by the employees.

$4.$ Employees can be given with a privilege to view their own details.

$5.$ As an administrator, create a view of EMP$\_$Details where the mobile and bank$\_$acc$\_$no of an

employee are de$-$identified and protect EMP$\_$Logins from active directory attacks. write down the mysql commands and insert some values into both tables and show the proper output of the commands using the inserted values and use ecryption commands like kyring, datamasking for step $5$ where the mobile and bank$\_$acc$\_$no of an employee are de$-$identified