Two or more attributes or attribute collection that can be a key are called…
a) candidate key
b) determinants
c) primary keys
d) BCNF
A relation is in this form if it is in BCNF and has no multi-value dependencies….
a) second normal form
b) third normal form
c) fourth normal form
d) domain/key
If attribute A determine attribute B and B determines A, the relationship among their data values is………
a) one-to-one
b) many-to-one
c) normalized
d) many-to-many
If attribute A determine attribute B and B does not determine A, the relationship among their data values is………
a) one-to-one relationship
b) many-to-one relationship
c) normalized
d) many-to-many relationship
One solution to the multi-value dependency constraints problem is to…
a) split relation in two relations
b) change the theme
c) create a new relation
d) add a composite key
In ……..normal form, any multi-valued attributes have been removed.
a) first normal form
b) second normal form
c) third normal form
d) fifth normal form
