Question: 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.
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
Step by Step Solution
3.42 Rating (155 Votes )
There are 3 Steps involved in it
CREATE DATABASE emp This is the command used to create a database Use emp To select emp as the curre... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help