Write SQL statements:

a$.$ Create the database "cis$395$Demo".

b$.$ Create a database user "cis$395\_$dev$1"$ with password "dolphins".

c$.$ Grant user "cis$395\_$user$1"$ with "select" $,$"delete" and "execute"

permission to DB "cis$39.$

d$.$ Revoke the privilege "delete" for the user "cis$395\_$user$1".$

Explain the difference between user and role.

$3$ Write three command statements to back up the Table for data

only, structure with data and structure only using mysqldump.

Using Mysqldump.exe to backup the CIS$395$ database and using mysql

to restore the backed database.

Write the command statement to import the data using mysqlimport from

customers.csv file.

What's the difference to use the LOAD DATA LOCAL INFILE vs

mysqlimport.