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