Security and Backup (Poor Satisfactory 40% of the score) (70% of the score)
Criteria
Excellent (100% of the score) Answer provided the exact output all the time.
Answer provided the wrong output.
Answer provided the output but with error.
Correctness of Output
1. Create a user "myadmin" with a password "myadmin". This user has all the permissions and is capable of giving permissions to other users. Using the user "myadmin", create a user "myuser1" with a password "myuser1". This user is capable of...
2. Employee Data Type
Field Name ENumber EmpName Birthdate Address Salary Dnumber
Varchar(4), Primary Key, not null Varchar(50), not null Date, not null Varchar(50), not null Decimal(10,2), not null Varchar(4), not null
Department Data Type
Varchar(4), Primary Key, not null Varchar(20), not null
Field Name DNumber DName
3. Using the user "myadmin", create a user "myuser2" with a password "myuser2". This user is capable of altering, inserting, and selecting on the database "PE2Database". Add a new column "Gender" to the table employee. Insert the following, then show the rows/data on each table:
Employee Birthdate Address
Department Dumber Gender DNumber DName D001 HRMO Munoz 18000.00 D005 Female D002 MIS Munoz 23000.00 00 Female D003 Marketing D004 Accounting CLSU 21000.00 D004 Male D005 Records Maligaya 25000.00 D001 Female Maligaya 30000.00 D002 Female
4. Using the user "myadmin", create a user "myuser3" with a password "myuser3". This user can drop and select data from the database "PE2Database".
5. Using the user "myadmin", remove the permission you gave to the user "myuser2" and delete the user.
6. Backup the table "Employee" from the database "PE2Database" using the user "myadmin". Show also the backup copy created.
7. Using "myadmin", drop the table you backed up. Show all the tables before and after deleting.
8. Restore the table "Employee" using the user "myadmin". Show the rows/data of the table "Employee" to verify if the table was restored.
9. Create a copy of the table "Department" using INTO OUTFILE. Show also the backup copy created and the data on it.
10. Truncate the table you backed up, then insert the data from the backup you created using LOAD DATA INFILE. Show the rows/data of the table "Department" to verify if the row/data was restored.
