CS403P Final Term Graded Quiz 3 by Team Aiza

1: Consider the following functional dependency:A → BIn above functional dependency, attribute B is_______ on A.Select the correct option

Terminated · Dependent · Projected · Reflected

2: The only time we are concerned about 2nd Normal Form is when ___________.Select the correct option

Primary key consists of single attribute · Primary key is composite · Primary key contains redundant values · Primary key contains non-unique values

3: ______________ is a step by step process to reduce data redundancy and improve data integrity to build a more efficient and accurate database design. Select the correct option

Classification · Integration · Normalization · Modeling

4: If a relation CLASS (crId, stId, stName, fId, room, grade) has following Functional Dependencies:crId, stId → stName, fId, room, gradewhich of the following functional dependency is in above functional dependency? Select the

Squencial dependency

5: A relation is in third normal form if ________.Select the

It has a partial dependency · It has a transitive dependency · It is already in second normal form

6: Consider the following relation:STD(stId, stName, stAdr, prName, prCrdts)stId → stName, stAdr, prName, prCrdtsprName → prCrdtsWhich of the following dependency exist in above relation?Select the correct option

Terminal dependency

Composite dependency

7: A table is in third normal form if it is in second normal form and there is no __________. Select the correct option

Consistency

8: 2nd Normal Form is based on which of the following dependency?Select the correct option

9: Suppose A → B, then which of the following is valid Functional dependency for augmentation?Select the correct option AC → BC AD → B A → C AB → C 10: In functional dependency, if one attribute is determinant of all other attributes of the relation then the relation has at least __________.Select the correct option

Random key · Super key · Secondary key · Relational key

11: The anomalies caused by transitive dependency in a relation are removed by __________.Select the correct option Changing primary key