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

(i) Create the database

(ii) Select the current database

(iii)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).

 (iv) Include necessary constraints.

(v) List all the tables in the current database

(vi) Display the structure of the employee table

(vii) Add a new column Designation to the employee table

(viii) Drop the column location from Dept table

(ix) Drop the tables

(x) Delete the database

Answer rating: 100% (QA)

CREATE DATABASE emp This is the command used to create a database Use emp To select emp as the curre... View the full answer