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
View Question
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
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies: F1->F3 F2->F4 (F1,F2)->F5
View QuestionRelation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
a) Zero b) More than zero but less than that of an equivalent 3NF decomposition c) ...
View QuestionWhich normal form is considered adequate for normal relational database design?
a) 2NF b) 5NF c) 4NF d) 3NF Answer: d Explanation: ...
View QuestionThe functional dependency can be tested easily on the materialized view, using the constraints ____________.
a) Primary key b) Null c) Unique d) Both Null ...
View QuestionThe algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
a) BCNF algorithm b) 2NF algorithm c) ...
View Question
Class (course id, title, dept name, credits, sec id, semester, YEAR, building, room NUMBER, capacity, TIME slot id)
The SET OF functional dependencies that we require TO hold ON class are:
course id->title, dept name, credits
building, room number->capacity
course id, sec id, semester, year->building, room NUMBER, TIME slot id
A candidate KEY FOR this schema IS {course id, sec id, semester, YEAR}
Consider the above conditions. Which of the following relation holds?
Class (course id, title, dept name, credits, sec id, semester, YEAR, building, room NUMBER, capacity, TIME slot id)
View QuestionR (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
a) A->B, B->CD b) A->B, B->C, C->D c) AB->C, C->AD d) ...
View QuestionWhat are the desirable properties of a decomposition
a) Partition constraint b) Dependency preservation c) Redundancy d) ...
View QuestionA relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
a) 2NF b) 3NF c) BCNF d) 1NF Answer: b Explanation: ...
View Question