Question: i) Create a database ORG with tables Worker (Worker ID, First Name, Last Name, Salary, Joining Date, Department (HR, Admin, Account)), Bonus ( Worker Ref

i) Create a database ORG with tables Worker (Worker ID, First Name, Last Name, Salary, Joining Date, Department (HR, Admin, Account)), Bonus ( Worker Ref ID, Bonus date, Bonus Amount) and Title ( Worker Ref ID, Worked Title, Affected from)

ii) Display the contents of tables Worker, Bonus and Title. iii) Delete the table Bonus. iv) Create a user Annie with password annie5346 and set password expire interval for 3 days. v) Verify the user Annie by authentication string. vi) Identify the user Annie with authentication plugin. vii) Create a user Rahul and identify using random password. viii) Change the user authentication of Annie and identify the user using mysql_native_password. ix) Lock the user Annie. x) Delete the user Rahul. xi) Unlock the user Annie.

i) Create a database ORG with tables Worker (Worker ID, First Name,

Last Name, Salary, Joining Date, Department (HR, Admin, Account)), Bonus ( Worker

Ref ID, Bonus date, Bonus Amount) and Title ( Worker Ref ID,

Sample Table - Worker Sample Table - Bonus Sample Table - Title

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!