Table TT{A, B, C, D, E, F} and a set of functional dependencies A,C,E->D,F; B->C,D,F; A->B,C,F;
The closure of {A D} is:
A -
A B C D F
B -
A B C D E
C -
E B C D F
D -
A E C D F
2-
Table TT{A, B, C, D, F,G, H} and a set of functional dependencies A,B->G,H; F->A,B,C; C,G-
>D,H; C,D,F->G; A,B,H->F;
The closure of {C G} is:
A -
CGD
B -
BGDH
C -
CGDH
D -
AGDH
3-
If the relation (A,B,C,D) with primary key A, is in 2NF but not in 3NF, Which of the following
could not be true?
A -
B->C
B -
A->C
C -
A->B
D -
C->A
4-
A relation can be in 3NF
A -
Being in 2NF
B -
Without being in BCNF
C -
Without being in 2NF
D -
None of these answers.
5-
Table TT {A, B, C, D, E} and a set of functional dependencies A->D,E; D->B,C; A,C->B; The
primary key is:
A -
A
B -
AE
C -
DA
D -
AB
6-
Table TT {A, B, C, D, E} and a set of functional dependencies A->D,E; D->B,C; A,C->B; Table TT
is:
A -
BC
B -
2NF
C -
1NF
D -
3NF
7-
Which of the following is true about a key?
A -
All of the above
B -
It may be unique
C -
In may identify more than one row
D -
It may be non-unique.
8-
Which one of the following is not correct :
A -
If a relation is in 3NF and does not have a composite key , it is in BCNF.
B -
If a table is a relation, it is in 1NF
C -
2NF and 3NF are based on functional dependencies, BCNF is not.
D -
The primary aim of 2NF, 3NF and BCNF is to ensure that each table has information only about one thing.
9-
MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)
Given the above functional dependency, which of the following statement is not known to be true?
A -
MedicineCode is a determinant.
B -
MedicineName is a determinant.
C -
Manufacturer is functionally dependent on MedicineCode.
D -
ShelfLife is functionally dependent on MedicineCode.
10-
Which normal form is defined as any table meeting the definition of a relation?