Question

Task 2 Background 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 the

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.

Fig: 1