Modeling Data In The Organization(Database ) Questions and Answers
Question 1. A binary relationship is which of the following?
A relationship between two attributes
A relationship between two entities
An attribute with two different relationships
An entity with two different relationships
Explanation:-
Answer: Option B. -> A relationship between two entities
Question 2. 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?
Derived attribute
Optional one cardinality
Multi-valued attribute
Weak entity
Explanation:-
Answer: Option D. -> Weak entity
Question 3. Which of the following conditions should exist if you want to convert a relationship to an associative entity?
Some of the relationships for the participating entities are 'many'.
The resulting associative entity has an independent meaning.
The resulting associative entity has no attributes.
All of the above.
Explanation:-
Answer: Option B. -> The resulting associative entity has an independent meaning.
Question 4. A good identifier is which of the following?
One that can change over time
Can be null
One that is unique
Be intelligent
Explanation:-
Answer: Option C. -> One that is unique
Question 5. A relationship is which of the following?
A person, place, or thing
Property or characteristic of an entity
Link between entities
Weak entity
Explanation:-
Answer: Option C. -> Link between entities
Question 6. A rectangle represents which of the following in an ERD?
Attribute
Entity
Optional One
Relationship
Explanation:-
Answer: Option B. -> Entity
Question 7. An entity name should be which of the following?
A singular noun
Specific to the organization
Concise
All of the above
Explanation:-
Answer: Option D. -> All of the above
Question 8. When the minimum and maximum number of instances of an entity is one, you know which of the following?
Mandatory one
Optional one
Mandatory many
Cannot tell
Explanation:-
Answer: Option A. -> Mandatory one
Question 9. An attribute name should be which of the following?
Singular verb or verb phrase
Follow a standard format
Use a alias
All of the above
Explanation:-
Answer: Option B. -> Follow a standard format
Question 10. An oval represents which of the following in an ERD?