Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions