Question 1:
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
Answer: _________
Question 2:
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
Answer: _________
Question 3:
A ternary relationship involves how many entities?
A.
3 or less
B.
3
C.
More than 3
D.
3 or more
Answer: _________
Question 4:
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
Answer: _________
Question 5:
A good business rule is which of the following?
A.
Declarative
B.
Imprecise
C.
Redundant
D.
Compound
Answer: _________
Question 6:
An attribute is a person, place, object, event in a user environment.
A.
True
B.
False
Answer: _________
Question 7:
Output reports should be included as part of an ERD.
A.
True
B.
False
Answer: _________
Question 8:
Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.
A.
True
B.
False
Answer: _________
Question 9:
Relationships cannot have attributes.
A.
True
B.
False
Answer: _________
Question 10:
Business rules and policies are universal.
A.
True
B.
False
Answer: _________
Question 11:
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
Answer: _________
Question 12:
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
Answer: _________
Question 13:
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
Answer: _________
Question 14:
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.
Answer: _________
Question 15:
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
Answer: _________
Question 16:
A rectangle represents which of the following in an ERD?
A.
Attribute
B.
Entity
C.
Optional One
D.
Relationship
Answer: _________
Question 17:
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
Answer: _________
Question 18:
An oval represents which of the following in an ERD?
A.
Attribute
B.
Entity
C.
Optional One
D.
Relationship
Answer: _________
Question 19:
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
Answer: _________
Question 20:
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
Answer: _________
Question 21:
A relationship is an association representing the interaction between attributes.
A.
True
B.
False
Answer: _________
Question 22:
A binary relationship is a relationship between two or more entities.
A.
True
B.
False
Answer: _________
Question 23:
Some business rules cannot be represented in common data modeling notation.
A.
True
B.
False
Answer: _________
Question 24:
A time stamp is a time value that is associated with a data value.
A.
True
B.
False
Answer: _________
Question 25:
A logical representation of the data for an organization or for a business area is known as an entity-relationship model.
A.
True
B.
False
Answer: _________
Question 26:
A derived attribute is an attribute whose values can be calculated from a related relationship.
A.
True
B.
False
Answer: _________
Question 27:
A fact is a word or phrase that has a specific meaning for the business.
A.
True
B.
False
Answer: _________
Question 28:
A strong entity is an entity whose existence depends on some other entity type.
A.
True
B.
False
Answer: _________
Question 29:
Multiple and binary relationships are the same thing.
A.
True
B.
False
Answer: _________
Question 30:
No two attributes of the same entity type should have the same name.
A.
True
B.
False
Answer: _________
Answer Key
1:
A
2:
D
3:
B
4:
D
5:
A
6:
B
7:
B
8:
A
9:
B
10:
B
11:
B
12:
D
13:
C
14:
B
15:
C
16:
B
17:
D
18:
A
19:
A
20:
B
21:
B
22:
B
Solution: Binary relationship is the relationship between two entities. Not more than two.
23:
A
24:
A
25:
A
26:
B
27:
B
28:
B
29:
B
30:
A