Question

Searches related to a.) Create the following table named Employee. Field Name Data Type Size Remark Empid Number 5 Primary Key FName Varchar 20 Lname Varchar 20 SName Varchar 20 Dno Varchar 5 Should start with character ‘D’ DOB Date Should not take null value DOJ Date Should not take null value & Should later than Date Of Birth Salary Number 7 Should take only +ve value City Varchar 15 Should not take null value & values should take metro names b) Write the SQL commands for the following 1. Display empid, name and bonus for each employee.(Note – Bonus is 10% of the salary). 2. Increase the salary of each employee by 1000. 3. Display the year of service and age of each employee. 4. Delete the employee details whose salary is less than 5000. 5. Delete all the employee records. 6. Rename the table to EMP. 7. Add a new column mob no for storing mobile number of the employees. 8. Change the data type of the field empid, number to varchar with size 5. 9. Delete the existence of the table.

Answer 1

Explanation:

You may have as many columns as you'd like, and the constraints are optional. Example: create table employee (first