2/14/2020 FDs & Normalization in DBMS | Print - Quizizz
NAME :
CLASS :
FDs & Normalization in DBMS
DATE :
24 Questions
1. An attribute A is said to functionally determine attribute B if
each value of A is associated with _____ value of B
a) only one b) more than one
c) either one or none d) more than zero
2. What is the name of A here
a) Dependent b) Determinant
c) child d) parent
3. What is the name of B here
a) Dependent b) child
c) parent d) Determinant
4. If A and B are attributes of a relation, B is ____ on A if it is
functionally dependent on A, but not on any subset of A.
a) fully functionally dependent b) Partial Functional Dependent
c) Transitive Functional Dependent d) functional dependent
5. If A and B are attributes of a relation, B is ___ on A if it is
dependent on subset of A.
a) Full Functional Dependent b) partially functional dependent
c) Transitive Functional Dependent d) functional dependent
6. If A, B, and C are attributes of a relation such that if A -> B and
B -> C, then C is ____ on A via B.
a) Full Functional Dependent b) Partial Functional Dependent
c) Transitive Functional Dependent d) functional dependent
https://quizizz.com/print/quiz/5e43ce1032d39a001b113fc6 1/5
2/14/2020 FDs & Normalization in DBMS | Print - Quizizz
7. Consider a relation which is used to store marks scored by
students in various courses.Student(StudentId, Name,
ContactNo, Course, Marks, Grade)
Studentid ------> name is
a) Full FD b) partial FD
c) No FD d) Transitive FD
8. Consider a relation which is used to store marks scored by
students in various courses.Student(StudentId, Name,
ContactNo, Course, Marks, Grade)
StudentId, name -----> ContactNo
a) partial FD (StudentId) b) Full FD
c) Transitive FD d) No FD
9. Consider a relation which is used to store marks scored by
students in various courses.Student(StudentId, Name,
ContactNo, Course, Marks, Grade)
StudentId -----> Course
a) Full FD b) Partial FD
c) Transitive FD d) No FD
10. Consider a relation which is used to store marks scored by
students in various courses.Student(StudentId, Name,
ContactNo, Course, Marks, Grade)
StudentId, Course -----> Grade
a) Full FD b) Partial FD
c) Transitive FD d) No FD
11. A functional dependency is a relationship between or among
a) Entities b) Rows
c) Attributes d) Tables
12. Which functional dependency types is/are present in following
dependencies?StaffNo, BranchNo -> StaffName,
BranchName, Position, DOBStaffNo -> StaffName, Position,
DOBBranchNo -> BranchName
a) Full functional dependency b) Partial functional dependency
c) Transitive functional dependency d) No functional dependency
https://quizizz.com/print/quiz/5e43ce1032d39a001b113fc6 2/5
2/14/2020 FDs & Normalization in DBMS | Print - Quizizz
13. Which functional dependency types is/are present in the
following dependencies?Empno -> EName, Salary, Deptno,
DNameDeptNo -> DNameEmpNo -> DName
a) Full functional dependency b) No functional dependency
c) Partial functional dependency d) Transitive functional dependency
14. Consider a relation R(A, B, C, D) with the following functional
dependencies: A -> (B, C, D), (A, D) -> (B, C) and (C, D) -> (A,
B).Identify the candidate key(s).
a) {A} b) {A}, {C, D}
c) {A}, {C, D}, {A, D} d) {C, D}
15. A -> B also means that B -> A. State if the statement is True or
False.
a) True b) False
16. _____ is the process of reorganizing data in a database so
that data redundancy is reduced
a) Normalization b) Functional Dependency
c) Join d) Entity Relationship
17. A relation R is in 1NF if and only if
a) Each attribute contains atomic values (that b) There is no partial dependency between non-
cannot be split further) key attributes and key attributes.
c) None of these d) Value of each attribute contains single value
from domain i.e. no multivalued attributes.
18. A relation is in second normal form if and only if
a) R is already in 1NF b) Transitive dependency does not exists
between key attributes and non-key attributes
through another non-key attribute.
c) There is no partial dependency between non- d) None of these
key attributes and key attributes.
19. A relation R is said to be in the Third Normal Form (3NF) if and
only if :
a) It is in 2NF b) none of these
c) R should be fully functional dependecy d) Transitive dependency does not exists
between key attributes and non-key attributes
through another non-key attribute.
https://quizizz.com/print/quiz/5e43ce1032d39a001b113fc6 3/5
2/14/2020 FDs & Normalization in DBMS | Print - Quizizz
20. The database design prevents some data from being stored
due to _______.
a) Deletion anomalies b) Insertion anomalies
c) Update anomaly d) None of these
21. A relation is in 2NF if:
a) All the values of non-key attributes are b) Any non-key attribute that are dependent on
dependent fully on the candidate key. only part of the candidate key should be
moved to another relation where the partial
key is the actual full key.
c) It must be already in the 1NF. d) All of the above.
22. 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
23. Consider the relation Sale(Date, Customer, Product, Vendor,
VendorCity, SalesRep){Date, Customer, Product} is the
composite candidate key and the following functional
dependencies are also given:Vendor -> VendorCity, Product ->
VendorWhat is the highest normal form of the sale relation?
a) 2NF b) 3NF
c) 0NF d) 1NF
24. Which of the following statement(s) is/are FALSE about
OLAP? (Choose all that apply)
a) OLAP involves long running slow b) OLAP involves frequent insert, update and
transactions that read lot of data delete operations
c) OLAP requires data to be in De-Normalized d) OLAP requires complex joins to aggregate
form for optimal processing data from multiple tables
https://quizizz.com/print/quiz/5e43ce1032d39a001b113fc6 4/5
2/14/2020 FDs & Normalization in DBMS | Print - Quizizz
Answer Key
1. a 7. a 13. a,d 19. a,d
2. b 8. a 14. b 20. b
3. a 9. d 15. b 21. d
4. a 10. c 16. a 22. d
5. b 11. c 17. a,d 23. d
6. c 12. a,b 18. a,c 24. b,d
https://quizizz.com/print/quiz/5e43ce1032d39a001b113fc6 5/5
