Answer the following:

--> If X and Y are subsets of attributes of relation R, then we say that set Y is functionally dependent

on set X if:

for each X value there is only one Y value

for each Y value there is only one X value

no two X values have the same Y value

when two rows have the same Y value they also have the same X value

--> Which of the following is not one of the major objectives of normalization?

removing redundancy

improving eciency

removing anomalies

increasing model exibility

--> A constraint between two or more attributes in which a nonkey attribute is determined by a portion

of the key is called a

partial functional dependency

partial attribute dependency

transitive dependency

partial transitive dependency