Question: Consider the following database schema: Companies ( comp _ id , Comp _ name, address, dep _ number ) Employees ( Number , Name,Age, Salary

Consider the following database schema:
Companies (comp_id, Comp_name, address, dep_number)
Employees (Number, Name,Age, Salary)
Departments (dep_number, dep_name)
Supervision (Head, Emp)
Query: Find the registration numbers of the supervisors of the employees earning more than 100
Jordanian dinars. (In Relational Algebra).
Query: Find the registration numbers of the supervisors of the employees earning more than 100
Jordanian dinars. ( In Domain Relational Calculus).
 Consider the following database schema: Companies (comp_id, Comp_name, address, dep_number) Employees

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!