Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Alter table department to modify the size of DepartmentPhoneNum. 2. Modify the field name DepartmentPhoneNum of departments table to PhNo. 3. Rename Table Department
1. Alter table department to modify the size of DepartmentPhoneNum. 2. Modify the field name DepartmentPhoneNum of departments table to PhNo. 3. Rename Table Department as DEPT. 4. Alter Table department remove column PhNo. 5. Create a table COPYOFDEPT as a copy of the table DEPT. 6. Delete all the rows from COPYOF DEPT table. 7. Remove COPYOF DEPT table. 8. Add Foreign Keys using Alter Table. 9. Drop Foreign key defined on SuperSSN and add it using Alter table command. 10. Find the employee names having salary greater than Rs.25000. 11. Find the employee names whose salary lies in the range between 30000 and 70000 . 12. Find the employees who have no supervisor. 13. Display the bdate of all employee s in the format 'DDthMonthYYYY'. 14. Display the employee names whose bdate is on or before 1978. 15. Display the employee names having 'salt lake' in their address. 16. Display the department name that starts with 'M'. 17. Display the department names' that ends with ' E '. 18. Display the names of all the employees having supervisor with any of the following SSN 554433221, 333445555. 19. Display all the department names in upper case and lower case. 20. Display the first four characters and last four of the department names using substring function
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started