You are developing a learning management system (LMS) for a local community college. Categorize the following requirements into ‘functional’ or ‘non-functional”.

A researcher conducted an experiment with this hypothesis: Extra salt in the water affects the growth of coral. Which one of the following is a dependent variable?

A relation schema R that meets Generalized 3NF criteria may have transitive dependencies

Match the following HTTP methods with their purpose:

Pick the TRUE statement, with respect to creating an index on a column:

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency A → B holds for the database state shown. (true or false) .

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency B → A holds for the database state shown. (true or false)

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency B → C holds for the database state shown. (true or false)

Given R(A, B, C) with state: A B C a f m a g m b h m b i n c j n c k n The functional dependency C → B holds for the database state shown. (true or false)

What is the best choice for an index for the following query: select name, fav_color from employee where fav_color=’blue’;