A functional dependency is a relationship between or among
attributes
Well Done. Your Answer is Correct Keep it Up!
relations
rows
tables
Category: Computer Science
The database environment has all of the following components except
The database environment has all of the following components except
users
Well Done. Your Answer is Correct Keep it Up!
separate files
database
database administrator
A relation is in ……………………… if an attribute of a composite key is dependent on an attribute of other composite key.
A relation is in ……………………… if an attribute of a composite key is dependent on an attribute of other composite key.
3NF
Well Done. Your Answer is Correct Keep it Up!
2NF
BCNF
1NF
The ………… is related to the concept of multi-valued dependency.
The ………… is related to the concept of multi-valued dependency.
fourth normal form
Well Done. Your Answer is Correct Keep it Up!
fifth normal form
boyce codd normal form
third normal form
In 2NF
In 2NF
No partial functional dependencies exist
Well Done. Your Answer is Correct Keep it Up!
No partial multivalued dependencies exist.
No multivalued dependencies exist.
No functional dependencies exist.
Dependency preservation is not guaranteed in
Dependency preservation is not guaranteed in
BCNF
Well Done. Your Answer is Correct Keep it Up!
3NF
4NF
DKNF
If two relations R and S are joined, then the non matching ruples of both R and S are ignored in
If two relations R and S are joined, then the non matching ruples of both R and S are ignored in
inner join
Well Done. Your Answer is Correct Keep it Up!
full outer join
right outer join
left outer join
Fifth Normal form is concerned with
Fifth Normal form is concerned with
Join dependency
Well Done. Your Answer is Correct Keep it Up!
Functional dependency
Multivalued dependency
Domain key
The operation which is not considered a basic operation of relational algebra is
The operation which is not considered a basic operation of relational algebra is
Join
Well Done. Your Answer is Correct Keep it Up!
Selection
Union
Cross product
Relational Algebra does not have
Relational Algebra does not have
Aggregation operator
Well Done. Your Answer is Correct Keep it Up!
Division operator
Projection operator
Selection operator