MIS 3353 EXAM 2 QUESTIONS AND ANSWERS
In the conceptual design context, the common types of entities are... (Select any/all that
apply.) - Answers - weak, strong, associative entities
Customers, cars, and parts would most likely be examples of which one of the
following? - Answers - Entities
An entity type whose existence depends on another entity type is called a ________
entity - Answers - weak
A property or characteristic of an entity type that is of interest to the organization is
called a(n): - Answers - attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
- Answers - composite
The total quiz points for a student for an entire semester would most likely be an
example of a(n) ________ attribute - Answers - derived
An entity that contains attributes specific to the relationship between instances within
one or more entity(-ies) is called a(n)... (Select any/all that apply.) - Answers -
associative entity
The number of entities that participate in a relationship is called the _____. - Answers -
degree
The relationship between a weak entity type and its owner is a form of which one of the
following? - Answers - Identifying Relationship
A student can attend five classes, each with a different professor. Each professor has
30 students. The relationship of students to professors is a ________ relationship. -
Answers - many to many
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity - Answers - Cardinality Constraint
It would make sense to consider creating a super-type/sub-type relationship when... -
Answers - An entity's instances share some, but not all, attributes.
An attribute included in the super-type... - Answers - Is inherited by each of the sub-
types.
In the conceptual design context, the common types of entities are... (Select any/all that
apply.) - Answers - weak, strong, associative entities
Customers, cars, and parts would most likely be examples of which one of the
following? - Answers - Entities
An entity type whose existence depends on another entity type is called a ________
entity - Answers - weak
A property or characteristic of an entity type that is of interest to the organization is
called a(n): - Answers - attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
- Answers - composite
The total quiz points for a student for an entire semester would most likely be an
example of a(n) ________ attribute - Answers - derived
An entity that contains attributes specific to the relationship between instances within
one or more entity(-ies) is called a(n)... (Select any/all that apply.) - Answers -
associative entity
The number of entities that participate in a relationship is called the _____. - Answers -
degree
The relationship between a weak entity type and its owner is a form of which one of the
following? - Answers - Identifying Relationship
A student can attend five classes, each with a different professor. Each professor has
30 students. The relationship of students to professors is a ________ relationship. -
Answers - many to many
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity - Answers - Cardinality Constraint
It would make sense to consider creating a super-type/sub-type relationship when... -
Answers - An entity's instances share some, but not all, attributes.
An attribute included in the super-type... - Answers - Is inherited by each of the sub-
types.
