Question: Could use some please and thanks 1) What do you obtain when you apply the selection operator sT. where T is the condition Time -
Could use some please and thanks


1) What do you obtain when you apply the selection operator sT. where T is the condition Time - 3:00pm, to the database in Table 7? TABLE 7 Teaching schedule ProfessorDepartment Cruz Cruz Farber Farber GrammerPhys Room A100 A100 A100 A110 ? 505 N521 N502 Course numher Tume Zoology 335 412 501 617 544 518 575 9:00 A.M. 8:00 A.M. 3:00 P.M 11:00 A.M. 4:00 P.M 2:00 P.M. 3:00 P.M Psychology Psychology Computer Science Mathematics 2) Display the table produced by applying the projection P1.34 to Table 8 TABLE8 Flights. Airline Nadir Acme Acme Acmc Nadir Acmc Nadir Flight number 122 221 122 323 199 DestinationDeparture time 34 Detroit 08:10 08:17 08:22 08:30 08:47 09:10 09:44 Anchorage 34 13 322 34 Detroit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
