A binary relationship is which of the following?
A. A relationship between two attributes
B. A relationship between two entities
C. An attribute with two different relationships
D. An entity with two different relationships
Select an option to see the answer and solution.
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
A. Derived attribute
B. Optional one cardinality
C. Multi-valued attribute
D. Weak entity
Select an option to see the answer and solution.
A relationship is which of the following?
A. A person, place, or thing
B. Property or characteristic of an entity
C. Link between entities
D. Weak entity
Select an option to see the answer and solution.
Which of the following conditions should exist if you want to convert a relationship to an associative entity?
A. Some of the relationships for the participating entities are 'many'.
B. The resulting associative entity has an independent meaning.
C. The resulting associative entity has no attributes.
D. All of the above.
Select an option to see the answer and solution.
A good identifier is which of the following?
A. One that can change over time
B. Can be null
C. One that is unique
D. Be intelligent
Select an option to see the answer and solution.
A rectangle represents which of the following in an ERD?
A. Attribute
B. Entity
C. Optional One
D. Relationship
Select an option to see the answer and solution.
An entity name should be which of the following?
A. A singular noun
B. Specific to the organization
C. Concise
D. All of the above
Select an option to see the answer and solution.
An oval represents which of the following in an ERD?
A. Attribute
B. Entity
C. Optional One
D. Relationship
Select an option to see the answer and solution.
When the minimum and maximum number of instances of an entity is one, you know which of the following?
A. Mandatory one
B. Optional one
C. Mandatory many
D. Cannot tell
Select an option to see the answer and solution.
An attribute name should be which of the following?
A. Singular verb or verb phrase
B. Follow a standard format
C. Use a alias
D. All of the above
Select an option to see the answer and solution.
A composite attribute is which of the following?
A. An attribute that can be broken into components
B. An attribute that cannot be broken into components
C. Multiple attributes
D. An identifier
Select an option to see the answer and solution.
A binary relationship cannot be which of the following?
A. One-to-One
B. One-to-Many
C. Many-to-Many
D. Zero-to-Zero
Select an option to see the answer and solution.
A ternary relationship involves how many entities?
A. 3 or less
B. 3
C. More than 3
D. 3 or more
Select an option to see the answer and solution.
When the minimum number of instances of an entity is one, you know which of the following?
A. Mandatory one
B. Optional one
C. Mandatory many
D. Cannot tell
Select an option to see the answer and solution.
A good business rule is which of the following?
A. Declarative
B. Imprecise
C. Redundant
D. Compound
Select an option to see the answer and solution.
An attribute is a person, place, object, event in a user environment.
Select an option to see the answer and solution.
Output reports should be included as part of an ERD.
Select an option to see the answer and solution.
Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.
Select an option to see the answer and solution.
Relationships cannot have attributes.
Select an option to see the answer and solution.
Business rules and policies are universal.
Select an option to see the answer and solution.