Using Adobe ____ technology, Dreamweaver can import Microsoft Office or other software webpages and delete the unused code.

The RGB channel is called the ____channel because it is the result of combining the R, G, and B channels.

A. connection B. combination C. composite D. join

Consider the following relations that represent part of a real estate database:

``` Agent(Id, AgentName) House(Address, OwnerId, AgentId) Amenity(Address, Feature) ``` The Agent relation keeps information on real estate agents, the House relation has information on who is selling the house and the agent involved, and the Amenity relation provides information on the features of each house. Each relation has its keys underlined. Consider the following query: ``` SELECT H.OwnerId, A.AgentName FROM House H, Agent A, Amenity Y WHERE H.Address=Y.Address AND A.Id = H.AgentId AND Y.Feature = ’5BR’ AND H.AgentId = ’007’ ``` Assume that the bu?er space available for this query has 5 pages and that the following statistics and indices are available: 1. Amenity 10,000 records on 1000 houses, 5 records per page Clustered 2-level B+ tree index on Address Unclustered hash index on Feature, 50 features 2. Agent 200 agents with 10 tuples per page Unclustered hash index on Id 3. House 1000 houses with 4 records per page Unclustered hash index on AgentId Clustered 2-level B+ tree index on Address Answer the following questions (and explain how you arrived at your solutions). a. Draw a fully pushed query tree corresponding to the above query. b. Find the best query plan to evaluate the above query and estimate its cost. c. Find the next-best plan and estimate its cost.