COMPLETE THE FOLLOWING EXPERIMENT USING SQL PLUS

 

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)

Solutions i Create the database eno SMALLINT ename VARCHAR20 NOT NULL WITH DEFAULT age INTEGER1 job SMALLINT salary FLOAT4 dept SMALLINT WITH JOURNALI... View the full answer