OIT551-DBMS QUIZ V

A function that has no partial dependencies of the form

• 3 NF

• 2 NF

• 4 NF

• BCNF NF

4 NF is designed with cope with

• Transitive dependency

• Join dependency

• Multivalued dependency

• None of these

5 NF is designed to cope with

• Transitive dependency

• Join dependency

• Multivalued dependency

• None of these

If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:

• Well-structured

• 1NF

• 2NF

• 3NF

Consider the schema R= ( S, T, U, V ) and the dependencies S→T, T→U, U→V and V→S. Let R (R1 and R2) be a decomposition such that R1∩R2 ≠ Ø. The decomposition is:

• Not in 2NF

• In 2NF but not in 3NF

• In 3NF but not in 2NF

• In both 2NF and 3NF

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?.

Please select all the correct answers.

• Link the relations by a common field and create a primary key(s) for the new relation

• Remove any functional dependencies from both relations

• Assign both relations the same primary key field(s)

• None of these

If relation is given as

R = ABCDEF, F = {A -> B, B -> D, C -> D, E -> F}

• ABD

• ACE

• BDE

• None of these

Emp(empcode, name, street, city, state, pincode).For any pincode, there is only one city and state. Also, for

given street, city and state, there is just one pincode.

In normalization terms, emp is a relation in

• 1 NF only

• 2 NF and hence also in 1 NF

• 3NF and hence also in 2NF and 1NF

• BCNF and hence also in 3NF, 2NF and 1NF

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

• Decomposition

• Functional dependency

• Database modeling

• Normalization

An advantage of normalization is:

• The storage space needed for a normalised database is likely to be smaller

• The process of normalizing a database is very easy and doesn’t require any skill

• It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry