Consider the database for an organization. Write the queries for the following

1. Create the database

2. Select the current database

3. Create the following tables.

 

a. employee (emp_no,emp_name,DOB, address, doj, mobile_no, dept_no, salary).

b. department (dept_no, dept_name, location).

 

4. Include necessary constraints.

5. List all the tables in the current database

6. Display the structure of the employee table

7. Add a new column Designation to the employee table

8.Drop the column location from Dept table

9. Drop the tables

10.Delete the database