1-20 data

In which type of below normal forms each determinant in relation is possible key?

• 3NF

• 2NF

• 1NF

• BCNF

• 4NF

The scientific method of splitting complex table structures to simple table structures according to certain rules is:

• Normalization

• Denormalization

• Generalization

• Concretization

What is the relation type of functional dependencies?

• 1:1

• 1:M

• M:1

• M: M  

What is used for normalization reducing?

• Bottom-up method

• Decomposition without redundancy

• Generalization

• E/R scheme

What is the type of NF, if the table is in previous NF and doesn't have multi-value dependencies?

• There is no such NF

• BCNF

• DKNF

• 4NF

• 5NF

What is the reason of the anomalies insertion in the database

• Relations between entities

• Concretization

• Functional dependency

• Normalization

• Redundancy

What functional dependency requires for functional definition of the other attributes?

• Doesn't require the attribute not to be the key

• Doesn't require the attribute to be the key

• Requires the attribute to be the key

• Requires the attribute not to be the key

• There is no any relation between key and functional dependency

What is the type of NF, when and only when the determinant in the table is possible key?

• 4NF

• BCNF

• 3NF

• 1NF

Record - "Descendant" can not have any number of records, "ancestors" in the data model:

• other

• hierarchical

Which of the actions in the design of a relational database is not included in the stage of deployment?

• other

• Testing and maintenance of the database