An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.
Select an option to see the answer and solution.
Database · all questionsData Modeling with ER Model
Data Modeling with ER Model
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
A ternary relationship is so called because in contains two entities and one association between them.
Select an option to see the answer and solution.
All instances of an entity class have the same attributes.
Select an option to see the answer and solution.
A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.
Select an option to see the answer and solution.
An attribute describes the entity's characteristics.
Select an option to see the answer and solution.
The degree of a relationship refers to the number of entity classes in the relationship.
Select an option to see the answer and solution.
Entities use identifiers while tables use keys.
Select an option to see the answer and solution.
Composite identifiers consist of two or more attributes.
Select an option to see the answer and solution.
When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.
Select an option to see the answer and solution.
A subtype entity is a special case of another entity called a supertype entity.
Select an option to see the answer and solution.
An entity is something that can be identified in the user's work environment; something that the users want to track.
Select an option to see the answer and solution.
Entity instances are associated by relationship classes.
Select an option to see the answer and solution.
1:1, 1:N and N:M relationships are also known as HAS-A relationships.
Select an option to see the answer and solution.
In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship.
Select an option to see the answer and solution.
A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
Select an option to see the answer and solution.
An entity class is a collection of entities and is described by the structure of the entities in that class.
Select an option to see the answer and solution.
Relationship classes are associations between entity classes.
Select an option to see the answer and solution.
An identifier typically uses more than one attribute.
Select an option to see the answer and solution.
An identifier determines the type of relationship that an entity has.
Select an option to see the answer and solution.
A recursive relationship is a relationship between an archetype and an instance of that archetype.
Select an option to see the answer and solution.