Question: Please solve Quickly Apply the INGRES algorithm (the detachment technique) to the following query: Select std_name,std_dpt FROM std_info,std_absence WHERE std_info.std_id=std_absence.std_id AND std_absence.abs_hrs > 1 AND

Please solve Quickly

Please solve Quickly Apply the INGRES algorithm (the detachment technique) to the

Apply the INGRES algorithm (the detachment technique) to the following query: Select std_name,std_dpt FROM std_info,std_absence WHERE std_info.std_id=std_absence.std_id AND std_absence.abs_hrs > 1 AND std_absence.date = '2020-12-06'; std_info I std_id I std_name I std_dpt I std_avg 1 | Ahmed I Information: 75 1 2 Ali Networks 1 80 I std_absence I std_id I std_name i date abs_hrs : 1 | Ahmed I 2020-12-06 1 2 1 Ali I 2020-12-06 2 1 | Ahmed I 2020-12-08 : 2

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!