Question
1. R(A, B) WITH productions { A --> B }
2. R(A, B) WITH productions { B --> A }
3. R(A, B) WITH productions {A —> B, B --> A }
4. R(A, B, C) WITH productions {A -->B, B --> A, AB --> C }
a.
1, 2 and 3 are in 3NF and 4 is in BCNF
b.
1 and 2 are in BCNF and 3 and 4 are in 3NF
c.
All are in 3NF
d.
All are in BCNF
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Consider the relation given below and ind the maximum normal form applicable to them 1. R(A, B) WITH productions { A --> B } 2. R(A, B) WITH productions { B --> A } 3. R(A,...
Similar Questions
Discover Related MCQs
Q. Which one is based on multi-valued dependency:
View solution
Q. If a relation is in BCNF, then it is also in
View solution
Q. If every non-key attribute is functionally depedent primary key, then the relation will be in
View solution
Q. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
View solution
Q. The term for information that describes what type of data is available in a database is:
View solution
Q. A data type that creates unique numbers for key columns in Microsoft Access is:
View solution
Q. A dependency exist between two columns when
View solution
Q. An ________ is a set of entities of the same type that share the same properties, or attributes.
View solution
Q. Entity is a _________
View solution
Q. The descriptive property possessed by each entity set is _________
View solution
Q. The function that an entity plays in a relationship is called that entity’s _____________
View solution
Q. The attribute name could be structured as a attribute consisting of first name, middle initial, and last name. This type of attribute is called
View solution
Q. The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is
View solution
Q. Not applicable condition can be represented in relation entry as
View solution
Q. Which of the following can be a multivalued attribute ?
View solution
Q. Which of the following is a single valued attribute
View solution
Q. In a relation between the entities the type and condition of the relation should be specified . That is called as______attribute.
View solution
Q. _____________ express the number of entities to which another entity can be associated via a relationship set.
View solution
Q. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
View solution
Q. ____________ is preferred method for enforcing data integrity
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
