SQL relational algebra tree(관계 대수 질의 트리), 트랜잭션 선행 그래프 예시

1. 쿼리 프로세싱(Query Processing) • Consider the Hotel Schema: 사용한 DB Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) Draw a relational algebra tree for each of the following queries and use the heuristic rules to transform the queries into a more efficient form. 1-1.

SELECT r.roomNo, r.type, r.price FROM Room r, Booking b, Hotel h WHERE r.roomNo = b.roomNo AND b.hotelNo = h.hotelNo AND h...