Consider the database for an organization. Write the queries for the following 1. Create the database 2.
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Posted Date: