1. Create a table Information where attributes are name, age, id. Here id is foreign key...

Transcribed Image Text:

1. Create a table "Information" where attributes are name, age, id. Here id is foreign key which refers to the primary key of employee table. Insert 5 rows in information table. Then delete first 2 rows from employee table. But you can't delete those rows from information table before deleting from employee table. 2. Update the department id of those employees whose department id is null. And set it as those employees whose job id ends with "S". 3. Create a view "info" where you will include first name, last name, salary of those employees whose salary is greater than any salary of those employee who works in Texas 1. Create a table "Information" where attributes are name, age, id. Here id is foreign key which refers to the primary key of employee table. Insert 5 rows in information table. Then delete first 2 rows from employee table. But you can't delete those rows from information table before deleting from employee table. 2. Update the department id of those employees whose department id is null. And set it as those employees whose job id ends with "S". 3. Create a view "info" where you will include first name, last name, salary of those employees whose salary is greater than any salary of those employee who works in Texas

Answer rating: 100% (QA)

To accomplish the tasks youve described you will need to perform several SQL operations Assuming you ... View the full answer