:::danger This quiz reviews chapter 07 :::

Question 1

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
_ can help us detect poor E-R design.
Select one:
a. E-R Design Process
b. Functional dependencies
c. Relational scheme
d. Database Design Process

Question 2

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
Select one:
a. A one-to-many relationship set
b. A multivalued attribute of an entity set
c. A many-to-many relationship set
d. Both A many-to-many relationship set and A multivalued attribute of an entity set

Question 3

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Representations such as the in the deptyearrelation, with one column for each value of an attribute, are called _ they are widely used in spreadsheets and reports and in data analysis tools.
Select one:
a. Cross-tabs
b. Snapshot
c. Both Cross-tabs and Snapshot
d. All of the mentioned

Question 4

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
The normal form which satisfies multivalued dependencies and which is in BCNF is
Select one:
a. 4 NF
b. 3 NF
c. 2 NF
d. All of the mentioned

Question 5

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
Select one:
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. None of the mentioned

Question 6

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
A relation is in __ if an attribute of a composite key is dependent on an attribute of other composite key.
Select one:
a. 1NF
b. BCNF
c. 3NF
d. 2NF

Question 7

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:
{F1->F3, F2->F4, (F1,F2)->F5,
in terms of normalization, this table is in
Select one:
a. 1NF
b. 2NF
c. 3NF
d. None of the mentioned

Question 8

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Consider a relation R(A,B,C,D,E) with the following functional dependencies: ABC -> DE and D -> AB.
The number of superkeys of R is:
Select one:
a. 2
b. 7
c. 10
d. 12

Question 9

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Empdt1 (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, empdt1 is a relation in
Select one:
a. 2 NF and hence also in 1 NF
b. 3NF and hence also in 2NF and 1NF
c. 1 NF only
d. BCNF and hence also in 3NF, 2NF and 1NF

Question 10

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
In 2NF
Select one:
a. No partial MVDs exist
b. No partial FDs exist
c. No functional dependencies (FDs) exist
d. No multivalued dependencies (MVDs) exist

Question 11

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Inst_dept (ID, name, salary, dept_name, building, budget) is decomposed into
instructor (ID, name, dept_name, salary)
department (dept_name, building, budget)
This comes under
Select one:
a. Lossy-join decomposition
b. Lossy decomposition
c. Lossless-join decomposition
d. Both Lossy and Lossy-join decomposition

Question 12

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs are known to hold:
{AB->CD, DE->P, C->E, P->C, B->G}.
The relation schema R is
Select one:
a. in 3NF, but not in BCNF
b. not in 2NF
c. in 2NF, but not in 3NF
d. in BCNF

Question 13

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
Select one:
a. AB->C, C->AD
b. A->B, B->CD
c. A -> BCD
d. A->B, B->C, C->D

Question 14

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Relation dept_year(dept_name, total_inst_2007, total_inst_2008, total_inst_2009). Here the only functional dependencies are from dept_name to the other attributes. This relation is in
Select one:
a. Fourth NF
b. Third NF
c. BCNF
d. Second NF

Question 15

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Tables in second normal form (2NF):
Select one:
a. Eliminate the possibility of a insertion anomalies
b. Have all non key fields depend on the whole primary key
c. Have a composite key
d. Eliminate all hidden dependencies

Question 16

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
The main task carried out in the __ is to remove repeating attributes to separate tables.
Select one:
a. Third Normal Form
b. First Normal Form
c. Second Normal Form
d. Fourth Normal Form

Question 17

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Thus a _ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
Select one:
a. Instance
b. Snapshot
c. Both Instance and Snapshot
d. All of the mentioned

Question 18

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Which forms are based on the concept of functional dependency:
Select one:
a. 1NF
b. 2NF
c. 3NF
d. 4NF

Question 19

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Which normal form is considered adequate for normal relational database design?
Select one:
a. 4NF
b. 2NF
c. 5NF
d. 3NF

Question 20

Complete
Marked out of 1.00
Not flaggedFlag question
Question text
Which of the following is a tuple-generating dependencies?
Select one:
a. Functional dependency
b. Non-functional dependency
c. Equality-generating dependencies
d. Multivalued dependencies