$12-$A relation that contains no multivalued attributes and has non$-$key attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

a$)$ first

b$)$ second

c$)$ third

d$)$ fourth

e$)$ none of them

$13-$ When all multivalued attributes have been removed from a relation, it is said to be in:

a$)$ first normal form

b$)$ second normal form

c$)$ Boyce$-$Codd normal form

d$)$ third normal form

e$)$ none of them

$14-$All of the following are the main goals of normalization except:

a$)$ minimize data redundancy

b$)$ maximize storage space

c$)$ simplify the enforcement of referential integrity

d$)$ make it easier to maintain data

e$)$ increase manageability

$15-$ A constraint between two attributes is called a$($n$)$:

a$)$ functional relation

b$)$ attribute dependency

c$)$ functional dependency

d$)$ functional relation constraint

e$)$ none of them

$16-$ A candidate key must satisfy all of the following conditions except:

a$)$ the key must uniquely identify the row.

b$)$ the key must indicate the row's position in the table.

c$)$ the key must be nonredundant.

d$)$ each non$-$key attribute is functionally dependent upon it$.$

e$)$ all of them should be satisfied

$17-$ The attribute on the left$-$hand side of the arrow in a functional dependency is:

a$)$ determinant

b$)$ candidate key

c$)$ foreign key

d$)$ primary key

e$)$ none of them

$18-$ What does the following query return from the database?

select c$\_\_$id from section as S where semester $=$ 'Fall' and year $=2009$ and not exists $($select $*$ from section as T where semester $=$ 'Spring' and year $=2010$ and S$.$c$\_$id $=$ T$.$c$\_$id$)$;

a$)$ all courses taught in Spring $2010$ but not in Fall $2009$

b$)$ all courses taught in both Fall $2010$ and Spring $2009$

c$)$ all courses taught in both Fall $2009$ and Spring $2010$

d$)$ all courses taught in Fall $2009$ but not in Spring $2010$

e$)$ none of them

$19-$ SQL applies predicates in clause after groups are formed, so aggregate functions may be used.

a$)$ group by

b$)$ with

c$)$ where

d$)$ from

e$)$ having

$3$