see attached

1 answer below »

see attached

module-three-lab-guidelines-and-rubrichtml-dpwcxluz.zip

Answered 3 days After May 28, 2022

Solution

Salony answered on Jun 01 2022

100 Votes

SELECT statement for the Employee table to check that reconnected to the right information.
Alter table command to changes the name of table . Alter table command can also be used for column name change or drop any column
Select Command to show that Alter table worked properly
First join statement Joins are used for combining two or more tables to get required results. There are different types of joins exist but in this assignment we had make use of inner join
Second join statement for department_ID=2
THird join statement for department_ID=3
THird join statement for department_ID=4. It return 0 result as we can see from select that there is no record for department_ID=4.
Insertion of 10 new columns in employee table
After Insertion again same join statement with ID=1
After...

SOLUTION.PDF

see attached

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment