Question
a.
Together they constitute a composite key for the table
b.
Knowing the value in one column determines the value stored in another column
c.
The table is in 3NF
d.
Together they constitute a foreign key
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. A dependency exist between two columns when
Similar Questions
Discover Related MCQs
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
Q. Which of the following gives a logical structure of the database graphically ?
View solution
Q. The entity relationship set is represented in E-R diagram as
View solution
Q. The Rectangles divided into two parts represents
View solution
Q. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
View solution
Q. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________
View solution
Q. An entity set that does not have sufficient attributes to form a primary key is termed a __________
View solution
Q. For a weak entity set to be meaningful, it must be associated with another entity set, called the
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!
