normal forms

In the _____normal form, a composite attribute is converted to individual attributes.

• First
  

• second

• Third

• Fourth

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

• Functional dependency

• Database modeling

• Normalization

• Decomposition

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

• Axioms

• Armstrong’s axioms

• Armstrong

• Closure

A relation is in 2NF if:

• All the values of non-key attributes are dependent fully on the candidate key.

• Any non-key attribute that are dependent on only part of the candidate key

• It must be already in the 1NF.

• All of the above.

4NF is designed to cope with :

• Transitive dependency

• Join dependency

• Multi valued dependency

• None of these

5NF is designed to cope with :

• Transitive dependency

• Join dependency

• Multi valued dependency

• None of these

A ................. is an indirect functional dependency, one in which X→Z only by virtue of X→Y and Y→z

• multivalued dependencies
  

• join dependency

• trivial functional dependency

• transitive dependencies

When the values in one attribute must exist in another attribute, it is called _____?

• Transitive dependency

• Insertion anomaly

• Referential integrity constraints

• Normal forms

Which is TRUE from functional dependency shown as A → (X, Y)?

• X is functionally dependent on A

• X and Y are functionally dependent on A

• A is a determinant

• All of the above

A relation is not allowed to have _____?

• Two columns with the same values

• Two columns with the same domain

• Two columns with the same names

• None of these