Although Windows Live Mail allows you to assign a message a High, or Low Priority, all outgoing messages are _________________________ Priority by default.

The ____ loop can be used to process each element of an array.

A. For Element B. For Array C. For Each D. For Value

Consider the following schema, where the keys are underlined:

Company is an unnormalized relation that contains information on the states where companies
are registered (Name ! RegistrationState is an FD) and the industries where they belong
(company-industry is a many-to-many relationship). The City relation contains information
about the number of people living in each city. Different cities can have the same name
in different states, but city names within the same state are unique. Consider the following
query:

SELECT C.Name, T.Name

FROM Company C, City T

WHERE C.RegistrationState = T.State AND

T.Population > 9000000 AND

C.Industry = 'Apparel'

ORDER BY C.Name

Assume the following statistical information:
 20,000 tuples in Company relation
 5,000 tuples in City relation
 50 tuples/page in each relation
 6-page buer
 The domain of Population consists of integers in the range of 1000 to 10,000,000
 There are 50 industries represented in the database and 50 states.
 Indices:
? Company relation:
On Industry: Clustered, hash
? City relation:
On State: Clustered, 2-level B+ tree
Question: Find the best execution plan for the above query, draw it, and estimate its cost.