Which is true from functional dependency shown as A->(X, Y)?
a) X is functionally dependent on A
b) A determines Y
c) A is determinant
d) all of these
Which of the following should not be placed in a relational table?
a) entity
b) attributes
c) relationships
d) repeating group
In BCNF, every….in a table is candidate key.
a) determinant
b) entity
c) primary key
d) atomic attributes
An index is a…….
a) makes retravel faster
b) always generated for primary key
c) increase the space needed
d) both a & b
A 3NF violation means……
a) an attribute can have several values
b) an attribute only one part
c) an attribute in table belongs entity
d) table has no primary key
What is normalization?
a) identifies incorrect integrity
b) identifies incorrect placement
c) identifies incorrect cardinality
d) identifies incorrect foreign keys
