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

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)
1. Query: Find the registration numbers of the supervisors of the employees earning more than 100
Jordanian dinars. (In Relational Algebra)-
2. Query: Find the registration numbers of the supervisors of the employees earning more than 100
Jordanian dinars. ( In Domain Relational Calculus).

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!