MIS 3353 EXAM 2 QUESTIONS AND ANSWERS
In the conceptual design context, the common types of entities are... - Answers - strong,
associative and weak
Customers, cars, and parts would most likely be examples of which one of... - 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)... - 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
In the diagram, what type of relationship is depicted?
entity<--->entity - Answers - binary
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.
, Regarding completeness constraints... - Answers - Total specialization means each
instance of the super-type must belong to at least one sub-type.
The disjoint rule and the overlap rule... - Answers - Refer to whether an instance can
belong to multiple sub-types or not.
If I...
1. Had a super-type of Personnel with sub-types Volunteer, Donor, and Employee;
2. Was okay with having people in my Personnel table about whom I wasn't sure their
role in the organization; and
3. Was okay with, employees volunteering for events, volunteers making donations, and
donors also being employees.
What constraints would I want to place on my super-type/sub-type relationship? -
Answers - partial specialization rule, overlap rule
The attribute within the super-type entity that is used to specify the sub-type(s) to which
an instance belongs is called what? - Answers - sub-type discriminator
Which of the following would be considered a "threat" to an organization? (Mark any/all
that apply.)
-Meteor striking the production facility
-Putting locks on warehouse doors
-Paying the same invoice multiple times
-Inconsistent quality of manufactured products - Answers - meteor striking production
facility, paying same invoice multiple times, inconsistent quality of manufactured
products
Threat exposure... - Answers - Reflects a combination of both the magnitude and
probability of a threat.
Which of the following is true regarding inputs, processes, and outputs? - Answers - A
vendor's invoice is an input, a SQL query is a process, and a sales invoice is an output.
Recording each customer's assigned credit limit in the database... - Answers - is a form
of control
In the default revenue cycle ERD, why are there three different relationships between
Employee and ShipmentOut? - Answers - The three lines enables the "segregation of
duties" among the picking, packing, and shipping activities.
In the relationship between <SalesOrderLine> and ShipmentOut, why is the one-side
cardinality optional-one rather than mandatory-one? - Answers - This allows a sales
order to exist without it having been shipped yet.
In the conceptual design context, the common types of entities are... - Answers - strong,
associative and weak
Customers, cars, and parts would most likely be examples of which one of... - 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)... - 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
In the diagram, what type of relationship is depicted?
entity<--->entity - Answers - binary
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.
, Regarding completeness constraints... - Answers - Total specialization means each
instance of the super-type must belong to at least one sub-type.
The disjoint rule and the overlap rule... - Answers - Refer to whether an instance can
belong to multiple sub-types or not.
If I...
1. Had a super-type of Personnel with sub-types Volunteer, Donor, and Employee;
2. Was okay with having people in my Personnel table about whom I wasn't sure their
role in the organization; and
3. Was okay with, employees volunteering for events, volunteers making donations, and
donors also being employees.
What constraints would I want to place on my super-type/sub-type relationship? -
Answers - partial specialization rule, overlap rule
The attribute within the super-type entity that is used to specify the sub-type(s) to which
an instance belongs is called what? - Answers - sub-type discriminator
Which of the following would be considered a "threat" to an organization? (Mark any/all
that apply.)
-Meteor striking the production facility
-Putting locks on warehouse doors
-Paying the same invoice multiple times
-Inconsistent quality of manufactured products - Answers - meteor striking production
facility, paying same invoice multiple times, inconsistent quality of manufactured
products
Threat exposure... - Answers - Reflects a combination of both the magnitude and
probability of a threat.
Which of the following is true regarding inputs, processes, and outputs? - Answers - A
vendor's invoice is an input, a SQL query is a process, and a sales invoice is an output.
Recording each customer's assigned credit limit in the database... - Answers - is a form
of control
In the default revenue cycle ERD, why are there three different relationships between
Employee and ShipmentOut? - Answers - The three lines enables the "segregation of
duties" among the picking, packing, and shipping activities.
In the relationship between <SalesOrderLine> and ShipmentOut, why is the one-side
cardinality optional-one rather than mandatory-one? - Answers - This allows a sales
order to exist without it having been shipped yet.
