Mississippi State University
MIS 307 FALL 2022 CHAPTER 8 and 9 EXAM 3
MULTIPLE CHOICE (Answer on green scantron with no. 2 pencil)
1) The most common format used for data modeling is ________ diagramming.
A) Entity
...
Mississippi State University
MIS 307 FALL 2022 CHAPTER 8 and 9 EXAM 3
MULTIPLE CHOICE (Answer on green scantron with no. 2 pencil)
1) The most common format used for data modeling is ________ diagramming.
A) Entity-class
B) Entity-object
C) Entity-subject
D) Entity-relationship
2) During requirements structuring, a ________ model represents conceptual data requirements for
a particular system.
A) Business
B) Project
C) Data
D) Relationship
3) A(n) ________ data model is a detailed model that captures the overall structure of organizational
data that is dependent on the database management system or other implementation considerations.
A) Conceptual
B) Physical
C) Logical
D) Entity
4) What field serves as the unique identifier to records for a table?
A) Secondary key
B) Primary key
C) Composite key
D) Index
5) _________ eventually become the fields in a table when modelling a database.
A) Attributes
B) Entities
C) Records
D) Index
6) An ________ model is a detailed, logical representation of the entities, associations, and data
elements for an organization or business area.
A) E-D
B) E-O
C) E-R
D) E-A
7) A(n) ________ is a person, place, object, event, or concept in the user environment about which
the organization wishes to maintain data.
A) Dimension
B) Attribute
C) Object
D) Entity
8) An entity ________ is a collection of entities that share common properties or characteristics.
A) Object
B) Type
C) Subject
D) Relationship
9) An entity ________ is a single occurrence of an entity type.
A) Instance
B) Object
C) Attribute
D) Class
10) A(n) ________ is a named property or characteristic of an entity that is of interest to the
organization.
A) Event
B) Instance
C) Relationship
D) Attribute
11) A(n) ________ is an association between the instances of one or more entity types that is of
interest to the organization.
A) Attribute
B) Repeating group
C) Relationship
D) Identifier
12) The ________ defines the number of instances of entity B that can (or must) be associated with
each instance of entity A.
A) Cardinality
B) Relationship
C) Identifier
D) Association
13) __________ cardinality is represented by a vertical line and means that one instance of a
relationship between tables is required.
A) Minimum
B) Absolute
C) Maximum
D) Aggregate
14) __________ cardinality is represented by an oval and means that an instance of a relationship
between tables is not required.
A) Minimum
B) Absolute
C) Maximum
D) Aggregate
15) Another name for a table is a ____________.
A) set
B) relation
C) bracket
D) field
16) One purpose of database design is to structure the data in stable structures, called normalized
tables, that are not likely to change over time and that have minimal ________.
A) Data
B) Space
C) Redundancy
D) Columns
17) ________ database design is driven not only from the previously developed E-R data model for
the application or enterprise but also from form and report layouts.
A) Logical
B) Physical
C) Normalized
D) De-normalized
18) In database design, we use a process called ________, which is a way to build a data model that
represents one and only one entity.
A) Data modeling
B) Database designing
C) De-normalization
D) Normalization
19) A(n) ________ is an attribute whose value is unique across all occurrences of a relation.
A) Composite key
B) Primary key
C) Identifier
D) Index
20) During logical database design, you must account for every data _________ on a system input or
output form or report.
A) element
B) key
C) object
D) logic
21) In a ________ database model, data is represented as a set of related tables or relations.
A) Logical
B) Conventional
C) Relational
D) Physical
22) A relation is a ________-dimensional representation of an entity.
A) Two
B) One
C) Three
D) Four
23) Each ________ in a relation corresponds to an attribute of that relation.
A) Entity
B) Data
C) Column
D) Row
24) Each ________ of a relation corresponds to a record that contains data values for an entity.
A) Column
B) Entity
C) Attribute
D) Row
25) Entries in cells are simple and an entry at the intersection of each row and column has a
________ value.
A) Duplicate
B) Single
C) Multi
D) Repeating
26) A ________ is an attribute that appears as a non-primary key attribute in one relation and as a
primary key attribute in another relation.
A) Referential integrity
B) Primary key
C) Foreign key
D) Unique key
27) Each regular entity type in an E-R diagram is transformed into a(n) ________.
A) Identifier
B) Relation
C) Attribute
D) Row
28) Data models that are not complete are said to have __________.
A) Conditions
B) Action questions
C) Rules violations
D) Requirement gaps
29) ______ can be reorganized within a table without it changing the meaning of the overall entity.
A) Fields
B) Relationships
C) Data values
D) Metadata
30) It is always a good idea to have ________ validate a data model.
A) users
B) competitors
C) third party vendors
D) counselors
[Show More]