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

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
Get step-by-step solutions from verified subject matter experts
