Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.
Answer the following statement true (T) or false (F)
True
You might also like to view...
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 bu er
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.
The width attribute sets the width of a text field
Indicate whether the statement is true or false
To specify that your document was created in the Arabic language, which reads right-to-left, you would set the ____ attribute to rtl.
A. dir B. id C. lang D. class
In a three-tier architecture, the ____ tier contains the classes that display information and accept user input.
A. validation B. presentation C. business D. persistence