Question 14 Consider the following schema and answer the following questions: Project(projld: integer, proj_name: varchar) Employee(empld: integer, jobTitle: varchar, salary: number, projld: integer,...


Question 14<br>Consider the following schema and answer the following questions:<br>Project(projld: integer, proj_name: varchar)<br>Employee(empld: integer, jobTitle: varchar, salary: number, projld: integer, deptld: integer)<br>Department(deptld: integer, dept_name: varchar)<br>a. Write the following queries in relational algebra.<br>I. Find the jobTitle of employees who worked in project with id=

Extracted text: Question 14 Consider the following schema and answer the following questions: Project(projld: integer, proj_name: varchar) Employee(empld: integer, jobTitle: varchar, salary: number, projld: integer, deptld: integer) Department(deptld: integer, dept_name: varchar) a. Write the following queries in relational algebra. I. Find the jobTitle of employees who worked in project with id= "2654". ii. Find the IDs of employees who are earn salaries more than 1000. i. Find IDs of projects who accomplished by employee with id = "7452".

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here