Management 3300 Exam 2 Mizzou
UPDATED Exam Questions and
CORRECT Answers
structured information - CORRECT ANSWER - usually considered to be facts and data
it is reasonably orderly, and can be broken down into component parts and organized into
hierarchies
unstructured information - CORRECT ANSWER - has no inherent structure or order, and
the parts can't be easily linked together
it is more difficult to break down, categorize, organize, and query
semi-structured information - CORRECT ANSWER - -grey area between structured and
unstructured data
-web page with a title, subtitle, content, and a few images
metadata - CORRECT ANSWER - data about data
clarifies the nature of the information
for structured information, it describes the definitions for each field, table and their relationships
for unstructured or semi-structured info it describes properties of a document or other resource
characteristics that affect quality information - CORRECT ANSWER - -accuracy:
mistakes in dates, spelling, etc.
-precision: rounding miles for example
,-completeness: leaving off the house number in an order
-consistency: using different definitions in reports
-timeliness: having out-dated information
-bias
-duplication:information can be redundant
business-critical integrity constraint - CORRECT ANSWER - rule that enforce business
rules vital to an organization's success and often require more insight and knowledge than
relational integrity constraints
entity - CORRECT ANSWER - object, concept or event (subject)
ex. Customer
attributes - CORRECT ANSWER - a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
record - CORRECT ANSWER - the specific characteristics of one entity also called a row
or tuple
ex. 314-882-2409 or David Logan
A representation of an entity in a meaningful way, which includes the attributes of the entity, is
called a ________.
table - CORRECT ANSWER - a collection of records
ex. all the information
, database - CORRECT ANSWER - a collection of tables
stores info for a single application
primary key - CORRECT ANSWER - indicates uniqueness within records or rows in a
table
foreign key - CORRECT ANSWER - the primary key from another table, this is the only
way join relationships can be established
ERD (entity relationship diagram) - CORRECT ANSWER - represents conceptual
database as viewed by end user
depicts: entities, attributes, and relationships
cardinality - CORRECT ANSWER - the count of records that are allowed or are necessary
between entity relationship
tells us how many rows we need from one table before we can link it to another table
"number of elements of the set"
normalization - CORRECT ANSWER - a process that refines entities and their
relationships to help minimize duplication of information tables
null value - CORRECT ANSWER - cases where an attribute does not have an applicable
value for an attribute
never allowed in KEY fields
UPDATED Exam Questions and
CORRECT Answers
structured information - CORRECT ANSWER - usually considered to be facts and data
it is reasonably orderly, and can be broken down into component parts and organized into
hierarchies
unstructured information - CORRECT ANSWER - has no inherent structure or order, and
the parts can't be easily linked together
it is more difficult to break down, categorize, organize, and query
semi-structured information - CORRECT ANSWER - -grey area between structured and
unstructured data
-web page with a title, subtitle, content, and a few images
metadata - CORRECT ANSWER - data about data
clarifies the nature of the information
for structured information, it describes the definitions for each field, table and their relationships
for unstructured or semi-structured info it describes properties of a document or other resource
characteristics that affect quality information - CORRECT ANSWER - -accuracy:
mistakes in dates, spelling, etc.
-precision: rounding miles for example
,-completeness: leaving off the house number in an order
-consistency: using different definitions in reports
-timeliness: having out-dated information
-bias
-duplication:information can be redundant
business-critical integrity constraint - CORRECT ANSWER - rule that enforce business
rules vital to an organization's success and often require more insight and knowledge than
relational integrity constraints
entity - CORRECT ANSWER - object, concept or event (subject)
ex. Customer
attributes - CORRECT ANSWER - a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
record - CORRECT ANSWER - the specific characteristics of one entity also called a row
or tuple
ex. 314-882-2409 or David Logan
A representation of an entity in a meaningful way, which includes the attributes of the entity, is
called a ________.
table - CORRECT ANSWER - a collection of records
ex. all the information
, database - CORRECT ANSWER - a collection of tables
stores info for a single application
primary key - CORRECT ANSWER - indicates uniqueness within records or rows in a
table
foreign key - CORRECT ANSWER - the primary key from another table, this is the only
way join relationships can be established
ERD (entity relationship diagram) - CORRECT ANSWER - represents conceptual
database as viewed by end user
depicts: entities, attributes, and relationships
cardinality - CORRECT ANSWER - the count of records that are allowed or are necessary
between entity relationship
tells us how many rows we need from one table before we can link it to another table
"number of elements of the set"
normalization - CORRECT ANSWER - a process that refines entities and their
relationships to help minimize duplication of information tables
null value - CORRECT ANSWER - cases where an attribute does not have an applicable
value for an attribute
never allowed in KEY fields
