Please write

SQL statements to retrieve the records for task 2 together with the query results 

- SQL statements to modify the records for task 2 

- Execution result of the statements.'

Transcribed Image Text:

A major multi-national corporation has employed you to research and implement SQL statements to support their data management operations. The company consists of several departments located in cities all over the world. The company's database also contains information about the present and past jobs of its employees and about the present managerial structure. A conceptual schema of the database is given below. REGION region-name ID JOB job-title ID min-salary max-salary Belongs-to Involved-in COUNTRY country-name ID Has-current street-address postal-code city JOBHISTORY . end-date 0..1 Has-past start-date EMPLOYEE employee id ID first-name last-name email [0..1) phone-number 10..1] hire-date 0..1 salary [0..11 commission-pet [0..1 Has-supervisor Is-in LOCATION 0..1 state-province [0..1] Belonged-to Belongs-to DEPARTMENT department-name ID Has-manager Is-located-at A 0..1 Please use the files: A2dbcreate.sql, A2dbload.sql and A2dbdrop.sql to create the tables and load the records. You should study the statements in the script files as they hold important clues to guide you in your subsequent implementations of SQL statements. Requirement A major multi-national corporation has employed you to research and implement SQL statements to support their data management operations. The company consists of several departments located in cities all over the world. The company's database also contains information about the present and past jobs of its employees and about the present managerial structure. A conceptual schema of the database is given below. REGION region-name ID JOB job-title ID min-salary max-salary Belongs-to Involved-in COUNTRY country-name ID Has-current street-address postal-code city JOBHISTORY . end-date 0..1 Has-past start-date EMPLOYEE employee id ID first-name last-name email [0..1) phone-number 10..1] hire-date 0..1 salary [0..11 commission-pet [0..1 Has-supervisor Is-in LOCATION 0..1 state-province [0..1] Belonged-to Belongs-to DEPARTMENT department-name ID Has-manager Is-located-at A 0..1 Please use the files: A2dbcreate.sql, A2dbload.sql and A2dbdrop.sql to create the tables and load the records. You should study the statements in the script files as they hold important clues to guide you in your subsequent implementations of SQL statements. Requirement

Answer rating: 100% (QA)

1SELECT employeeidfirstnamelastnamejobtitleemail SELECT jobti... View the full answer