Question: Consider the following relations: Technicians ( SSN , tech _ name, address, phone _ number ) , Tests ( FAAid , test _ name, max

Consider the following relations: Technicians(SSN, tech_name, address, phone_number), Tests(FAAid, test_name, max_score), Planes(Pid, model), and Examine(SSN, FAAid, Pid, date, score)
Find the plane IDs that have examination scores lower than 60% of the max_score of that test, and the corresponding techicians' name and phone nunber who gave that examination.
Write a relational algebric expression.

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 Programming Questions!