Question

1. Write SQL Query for the following questions: a. Create a table as emp_review that has the following fields similar to Employees table. (Don't copy any rows from the employees table. Only copy the listed fields below) i. Employee_ID ii. First_Name iii. Last_Name iv. Email v. Salary b. Insert corresponding employee information from employees table who works under Manager having First Name Neena into emp_review. c. Insert a new row into emp_review of your choice. d. Merge employees and emp_review into emp_review based on Emploee_ID. Rows from the employees table are superseded by rows from the emp_review table. 2. Write the SQL Query for following scenarios on the Departments table. a. Insert a new row of your choice into the Departments Table having location_id=3500. b. Question C will return an error while defining Location_ID as Foreign Key. Implement necessary SQL query so that this error can be resolved. c. Define Location_ID in departments table as a Foreign Key where the referenced column is Location_ID in Locations Table. Any changes made in the parent table needs to be implemented automatically in the child table.

          1. Write SQL Query for the following questions:
a. Create a table as emp_review that has the following fields similar to
Employees table. (Don't copy any rows from the employees table. Only copy
the listed fields below)
i. Employee_ID
ii. First_Name
iii. Last_Name
iv. Email
v. Salary
b. Insert corresponding employee information from employees table who works
under Manager having First Name Neena into emp_review.
c. Insert a new row into emp_review of your choice.
d. Merge employees and emp_review into emp_review based on Emploee_ID.
Rows from the employees table are superseded by rows from the
emp_review table.
2. Write the SQL Query for following scenarios on the Departments table.
a. Insert a new row of your choice into the Departments Table having
location_id=3500.
b. Question C will return an error while defining Location_ID as Foreign Key.
Implement necessary SQL query so that this error can be resolved.
c. Define Location_ID in departments table as a Foreign Key where the
referenced column is Location_ID in Locations Table. Any changes made in
the parent table needs to be implemented automatically in the child table.

1. Write SQL Query for the following questions:
a. Create a table as empreview that has the following fields similar to
Employees table. (Don't copy any rows from the employees table. Only copy
the listed fields below)
i. EmployeeID
ii. FirstName
iii. LastName
iv. Email
v. Salary
b. Insert corresponding employee information from employees table who works
under Manager having First Name Neena into empreview.
c. Insert a new row into empreview of your choice.
d. Merge employees and empreview into empreview based on EmploeeID.
Rows from the employees table are superseded by rows from the
empreview table.
2. Write the SQL Query for following scenarios on the Departments table.
a. Insert a new row of your choice into the Departments Table having
locationid=3500.
b. Question C will return an error while defining LocationID as Foreign Key.
Implement necessary SQL query so that this error can be resolved.
c. Define LocationID in departments table as a Foreign Key where the
referenced column is LocationID in Locations Table. Any changes made in
the parent table needs to be implemented automatically in the child table.

Added by Nuria B.

Question

Please give Ace some feedback