MANAGEMENT 3300 EXAM 2 MIZZOU
UPDATED ACTUAL QUESTIONS WITH CORRECT
ANSWERS
Question 1.
structured information
ANSWER
usually considered to be facts and data it is reasonably orderly, and can be broken down into
component parts and organized into hierarchies
Question 2.
unstructured information
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
Question 3.
metadata
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
Question 4.
five advantages of databases
ANSWER
1. reduce redundancy
2. increase information quality
3. flexibility
4. increase information security
5. scalability
,Question 5.
relational integrity constraint
ANSWER
rule that enforces basic and fundamental information-based constraints (ensure accuracy and
consistency of data)
Question 6.
business-critical integrity constraint
ANSWER
rule that enforce business rules vital to an organization's success and often require more
insight and knowledge than relational integrity constraints
Question 7.
password
ANSWER
provides authentication of the user
Question 8.
access level
ANSWER
determines who has access to the different types of information
Question 9.
access control
ANSWER
determines types of user access, such as read-only access
Question 10.
entity
ANSWER
object, concept or event (subject) ex. Customer
,Question 11.
attributes
ANSWER
a characteristic of an entity ex. Customer ID, Customer Name, Contact Name, Phone #
Question 12.
record
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 ________.
Question 13.
table
ANSWER
a collection of records ex. all the information
Question 14.
database
ANSWER
a collection of tables stores info for a single application
Question 15.
primary key
ANSWER
indicates uniqueness within records or rows in a table
Question 16.
foreign key
ANSWER
the primary key from another table, this is the only way join relationships can be established
, Question 17.
The Entity Re- lationship (ER) Model
ANSWER
forms the basis of an ER diagram
Question 18.
ERD (entity re- lationship dia- gram)
ANSWER
represents conceptual database as viewed by end user depicts: entities, attributes, and
relationships
Question 19.
cardinality
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"
Question 20.
Structured query language (SQL)
ANSWER
uses queries to retrieve records, insert and edit data, and delete records. widely used to
manipulate information in relational databases
Question 21.
IVR
ANSWER
interactive voice response
Question 22.
null value
ANSWER
cases where an attribute does not have an applicable value for an attribute never allowed in
KEY fields
UPDATED ACTUAL QUESTIONS WITH CORRECT
ANSWERS
Question 1.
structured information
ANSWER
usually considered to be facts and data it is reasonably orderly, and can be broken down into
component parts and organized into hierarchies
Question 2.
unstructured information
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
Question 3.
metadata
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
Question 4.
five advantages of databases
ANSWER
1. reduce redundancy
2. increase information quality
3. flexibility
4. increase information security
5. scalability
,Question 5.
relational integrity constraint
ANSWER
rule that enforces basic and fundamental information-based constraints (ensure accuracy and
consistency of data)
Question 6.
business-critical integrity constraint
ANSWER
rule that enforce business rules vital to an organization's success and often require more
insight and knowledge than relational integrity constraints
Question 7.
password
ANSWER
provides authentication of the user
Question 8.
access level
ANSWER
determines who has access to the different types of information
Question 9.
access control
ANSWER
determines types of user access, such as read-only access
Question 10.
entity
ANSWER
object, concept or event (subject) ex. Customer
,Question 11.
attributes
ANSWER
a characteristic of an entity ex. Customer ID, Customer Name, Contact Name, Phone #
Question 12.
record
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 ________.
Question 13.
table
ANSWER
a collection of records ex. all the information
Question 14.
database
ANSWER
a collection of tables stores info for a single application
Question 15.
primary key
ANSWER
indicates uniqueness within records or rows in a table
Question 16.
foreign key
ANSWER
the primary key from another table, this is the only way join relationships can be established
, Question 17.
The Entity Re- lationship (ER) Model
ANSWER
forms the basis of an ER diagram
Question 18.
ERD (entity re- lationship dia- gram)
ANSWER
represents conceptual database as viewed by end user depicts: entities, attributes, and
relationships
Question 19.
cardinality
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"
Question 20.
Structured query language (SQL)
ANSWER
uses queries to retrieve records, insert and edit data, and delete records. widely used to
manipulate information in relational databases
Question 21.
IVR
ANSWER
interactive voice response
Question 22.
null value
ANSWER
cases where an attribute does not have an applicable value for an attribute never allowed in
KEY fields
