Exercise 1 Following Queries Query List Department Name Project Name Manager S Ssn Contro Q37294292

Exercise 1: For the following queries: Query A. List the department name, project name and the managers ssn of the controlliExercise 1: For the following queries: Query A. List the department name, project name and the manager’s ssn of the controlling department of the project, where the department is located in Dubai. Query B. List the names of dependents of employees whose salary is greater than 15000 Dirhams and work in the Research department. Develop the following 1) Write the SQL query 2) Translate the SQL query into Relational Algebra query. 3) Create an initial (canonical) Query

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.