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