adplus-dvertising
frame-decoration

Question

If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

a.

DKNF

b.

BCNF

c.

Fourth

d.

Third

Posted under DBMS

Answer: (b).BCNF

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

Similar Questions

Discover Related MCQs

Q. The term for information that describes what type of data is available in a database is:

Q. A data type that creates unique numbers for key columns in Microsoft Access is:

Q. A dependency exist between two columns when

Q. An ________ is a set of entities of the same type that share the same properties, or attributes.

Q. Entity is a _________

Q. The descriptive property possessed by each entity set is _________

Q. The function that an entity plays in a relationship is called that entity’s _____________

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

Q. The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is

Q. Not applicable condition can be represented in relation entry as

Q. Which of the following can be a multivalued attribute ?

Q. Which of the following is a single valued attribute

Q. In a relation between the entities the type and condition of the relation should be specified . That is called as______attribute.

Q. _____________ express the number of entities to which another entity can be associated via a relationship set.

Q. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Q. ____________ is preferred method for enforcing data integrity

Q. Which of the following gives a logical structure of the database graphically ?

Q. The entity relationship set is represented in E-R diagram as

Q. The Rectangles divided into two parts represents

Q. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality