Could use some please and thanks 1) What do you obtain when you apply the select

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 - 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

Explanation / Answer

Answer:----

1.

2.

3. Property of Asymmetric relation, ===>>>> ( if (x,y) is in R then (y,x) not in R)

4. Composition Relation of S and R,

S o R = { (1,2),(1,3),(2,3),(2,4),(3,1) } o { (1,1),(3,1),(3,2),(3,3) }

=====> { (1,1),(1,2),(1,3),(2,1),(2,2),(2,3),(3,1) }

Professor Department Course_number Room Time Farber Psychology 501 A100 3:00 P.M. Rosen Mathematics 575 N502 3:00 P.M.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.