DMT Normalization Practice Quiz
10. Which functional dependency types is/are not present in the following dependencies? Empno -> EName, Salary, Deptno, DName DeptNo -> DName EmpNo -> DName A. Full functional dependency B. Partial functional dependency C. Transitive functional dependency D. Both B and C
B
2. For some relations, changing the data can have undesirable consequences called: a. referential integrity constraints b. modification anomalies c. normal forms d.transitive dependencies
B
6. A function that has no partial functional dependencies is in _______ form : a. 3NF b. 2NF c.4NF
B
7. A relation is in 3NF if it is in 2NF and if it has no ____________ a) Functional Dependencies b) Transitive Dependencies c) Trivial Functional Dependency d) Multivalued Dependencies
B
3. If attributes A and B determine attribute C, then it is also true that: a. A --> C. b. B --> C. c. (A,B) is a composite determinant. d.C is a determinant.
C
9. Which of the following is not a restriction for a table to be a relation? a) The cells of the table must contain a single value b) All of the entries in any column must be of the same kind c) The columns must be ordered d) No two rows in a table may be identical
C
1. A functional dependency is a relationship between or among: a. tables b. rows c. relations d.attributes
D
11. If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be: A. Well-structured B. 1NF C. 2NF D. 3NF
D
8. A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z. a) Multivalued Dependency b) Join Dependency c) Trivial Functional Dependency d) Transitive Dependency
D
4. If attribute A determines both attributes B and C, then it is also true that: a. A --> B. b. B --> A. c. C --> A. d.(B,C) --> A.
A
5. One solution to the multivalued dependency constraint problem is to: a. split the relation into two relations, each with a single theme. b. change the entity. c. create a new theme. d.add a composite key.
A
