31 + Mcqs in Data Modeling With The Entity Relationship Model in Database Page 1 McqOptions

1.	Entity instances are associated by relationship classes.
A.	1
B.
Answer» C.

Discussion

2.	A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
A.	1
B.
Answer» B.

Discussion

3.	A recursive relationship is a relationship between an archetype and an instance of that archetype.
A.	1
B.
Answer» C.

Discussion

4.	Entities use identifiers while tables use keys.
A.	1
B.
Answer» B.

Discussion

5.	Relationship classes are associations between entity classes.
A.	1
B.
Answer» B.

Discussion

6.	When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.
A.	1
B.
Answer» C.

Discussion

7.	A subtype entity is a special case of another entity called a supertype entity.
A.	1
B.
Answer» B.

Discussion

8.	1:1, 1:N and N:M relationships are also known as HAS-A relationships.
A.	1
B.
Answer» B.

Discussion

9.	An identifier typically uses more than one attribute.
A.	1
B.
Answer» C.

Discussion

10.	Composite identifiers consist of two or more attributes.
A.	1
B.
Answer» B.

Discussion

11.	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.
A.	1
B.
Answer» B.

Discussion

12.	An identifier determines the type of relationship that an entity has.
A.	1
B.
Answer» C.

Discussion

13.	Entities can be associated with one another in which of the following?
A.	Entities
B.	Attributes
C.	Identifiers
D.	Relationships
Answer» E.

Discussion

14.	In which of the following is a single-entity instance of one type related to many entity instances of another type?
A.	One-to-One Relationship
B.	One-to-Many Relationship
C.	Many-to-Many Relationship
D.	Composite Relationship
Answer» C. Many-to-Many Relationship

Discussion

15.	All instances of an entity class have the same attributes.
A.	1
B.
Answer» B.

Discussion

16.	An entity class is a collection of entities and is described by the structure of the entities in that class.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

17.	An entity is something that can be identified in the user's work environment; something that the users want to track.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

18.	Properties that describe the characteristics of entities are called:
A.	entities.
B.	attributes.
C.	identifiers.
D.	relationships.
Answer» C. identifiers.

Discussion

19.	A ternary relationship is so called because in contains two entities and one association between them.
A.	1
B.
Answer» C.

Discussion

20.	The degree of a relationship refers to the number of entity classes in the relationship.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

21.	In which of the following can many entity instances of one type be related to many entity instances of another type?
A.	One-to-One Relationship
B.	One-to-Many Relationship
C.	Many-to-Many Relationship
D.	Composite Relationship
Answer» D. Composite Relationship

Discussion

22.	A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.
A.	1
B.
Answer» C.

Discussion

23.	An attribute describes the entity's characteristics.
A.	1
B.
Answer» B.

Discussion

24.	In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
A.	parent
B.	child
C.	instance
D.	subtype
Answer» C. instance

Discussion

25.	Entities of a given type are grouped into a(n):
A.	database.
B.	entity class.
C.	attribute.
D.	ERD.
Answer» C. attribute.

Discussion

26.	In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
A.	One-to-One Relationship
B.	One-to-Many Relationship
C.	Many-to-Many Relationship
D.	Composite Relationship
Answer» B. One-to-Many Relationship

Discussion

27.	In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
A.	parent
B.	child
C.	instance
D.	subtype
Answer» B. child

Discussion

28.	An attribute that names or identifies entity instances is a(n):
A.	entity.
B.	attribute.
C.	identifier.
D.	relationship.
Answer» D. relationship.

Discussion

29.	Which of the following indicates the minimum number of entities that must be involved in a relationship?
A.	Minimum cardinality
B.	Maximum cardinality
C.	ERD
D.	Greater Entity Count (GEC)
Answer» B. Maximum cardinality

Discussion

30.	A recursive relationship is a relationship between an entity and ________ .
A.	itself
B.	a subtype entity
C.	an archetype entity
D.	an instance entity
Answer» B. a subtype entity

Discussion

31.	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.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

Explore topic-wise MCQs in Database.

Entity instances are associated by relationship classes.

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

A recursive relationship is a relationship between an archetype and an instance of that archetype.

Entities use identifiers while tables use keys.

Relationship classes are associations between entity classes.

When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.

A subtype entity is a special case of another entity called a supertype entity.

1:1, 1:N and N:M relationships are also known as HAS-A relationships.

An identifier typically uses more than one attribute.

Composite identifiers consist of two or more attributes.

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.

An identifier determines the type of relationship that an entity has.

Entities can be associated with one another in which of the following?

In which of the following is a single-entity instance of one type related to many entity instances of another type?

All instances of an entity class have the same attributes.

An entity class is a collection of entities and is described by the structure of the entities in that class.

An entity is something that can be identified in the user's work environment; something that the users want to track.

Properties that describe the characteristics of entities are called:

A ternary relationship is so called because in contains two entities and one association between them.

The degree of a relationship refers to the number of entity classes in the relationship.

In which of the following can many entity instances of one type be related to many entity instances of another type?

A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

An attribute describes the entity's characteristics.

In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

Entities of a given type are grouped into a(n):

In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

An attribute that names or identifies entity instances is a(n):

Which of the following indicates the minimum number of entities that must be involved in a relationship?

A recursive relationship is a relationship between an entity and ________ .

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.