Relationships cannot have attributes.
Answer: B
Correct answer: False
A relationship can carry attributes of its own, and a many-to-many relationship usually must: the grade a student earned in a course belongs to neither the student nor the course but to the enrolment joining them. Such a relationship is generally converted to an associative entity to hold them.
Please log in or register to report this question.
A relationship is an association representing the interaction between attributes.
Answer: B
Correct answer: False
A relationship associates entities, not attributes. Attributes describe the entities and relationships they belong to; they do not associate with one another. Substituting one term for the other reverses the structure of the model entirely.
Please log in or register to report this question.
A binary relationship is a relationship between two or more entities.
Answer: B
Correct answer: False
A binary relationship is between exactly two entity types. Adding “or more” would cover ternary and higher relationships too and lose the distinction the term exists to make - the degree of a relationship is a precise count, not a lower bound.
Please log in or register to report this question.
Some business rules cannot be represented in common data modeling notation.
Answer: A
Correct answer: True
Notation captures structure, cardinality and identifiers; it does not capture rules such as a credit limit depending on a payment history, or an order not being shippable before a deposit clears. Those are recorded as text and implemented in constraints, triggers or application code - which is why the rules are documented alongside the model rather than only within it.
Please log in or register to report this question.
A time stamp is a time value that is associated with a data value.
Answer: A
Correct answer: True
A time stamp records when a value applied, which is what makes a time-varying attribute possible: an employee’s salary is not one value but a series of values each with the period it held for. Storing history this way is how a database answers questions about the past rather than only the present.
Please log in or register to report this question.
A logical representation of the data for an organization or for a business area is known as an entity-relationship model.
Answer: A
Correct answer: True
The entity-relationship model is a logical representation of an organisation’s data - what exists and how it relates - independent of how it will be stored or of what software will hold it. That independence is what lets the same model be implemented on different products, and what makes it worth validating with users.
Please log in or register to report this question.
A derived attribute is an attribute whose values can be calculated from a related relationship.
Answer: B
Correct answer: False
A derived attribute is calculated from other attribute values - an age from a date of birth, a total from unit price and quantity. Deriving it from a relationship is not the definition. The reason for marking it as derived is that its value must never be stored and updated independently of the values it comes from.
Please log in or register to report this question.
A fact is a word or phrase that has a specific meaning for the business.
Answer: B
Correct answer: False
A word or phrase with a specific meaning for the business is a term. A fact is an association between two or more terms, such as a customer placing an order. Terms and facts together are the raw material from which entities, attributes and relationships are drawn.
Please log in or register to report this question.
A strong entity is an entity whose existence depends on some other entity type.
Answer: B
Correct answer: False
An entity whose existence depends on another is a weak entity. A strong entity exists in its own right and has an identifier of its own. The statement has given the definition of one under the name of the other, which reverses the relationship it describes.
Please log in or register to report this question.
Multiple and binary relationships are the same thing.
Answer: B
Correct answer: False
Multiple and binary are unrelated terms. Binary describes the degree of a relationship, meaning two entity types take part. Multiple describes an attribute that can hold more than one value for a single instance. Confusing the two mixes up a property of relationships with a property of attributes.
Please log in or register to report this question.
