A _______ dependency arises between two attributes when any non-key attribute is functionally dependent on some other non-key column which is in turn functionally dependent on the primary key
A _______ dependency arises between two attributes when any non-key attribute is functionally dependent on some other non-key column which is in turn functionally dependent on the primary key
In ______normal form all the columns in the table must be composed of atomic values.
In ______normal form all the columns in the table must be composed of atomic values.
every relation which is in BCNFform is also in ____normal form
every relation which is in BCNFform is also in ____normal form
_____normal form allows decomposing a relation into three or more relations.
_____normal form allows decomposing a relation into three or more relations.
A table is said to be in a specific normal form if it fulfils a particular set of ______ which are defined for that normal form
A table is said to be in a specific normal form if it fulfils a particular set of ______ which are defined for that normal form
Normalisation technique is established on the idea of _______ forms
Normalisation technique is established on the idea of _______ forms
BCNF stands for ______
BCNF stands for ______
The essential condition for a relational schema R to be in BCNF is that“whenever any nontrivial FD X "A holds in R, then X must be a _______ key of R"
The essential condition for a relational schema R to be in BCNF is that“whenever any nontrivial FD X "A holds in R, then X must be a _______ key of R"
Any attribute (column) is said to be _______ dependentif its value can be determined by any one or more attributes of the primary key, but not all
Any attribute (column) is said to be _______ dependentif its value can be determined by any one or more attributes of the primary key, but not all
In the ______ normal form objective is to resolve transitive dependencies
In the ______ normal form objective is to resolve transitive dependencies