©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
Management 3300 Exam 2 Mizzou Questions
With Correct Answers 100% Verified.
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
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
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
five advantages of databases - Answer✔1. reduce redundancy
2. increase information quality
3. flexibility
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
4. increase information security
5. scalability
relational integrity constraint - Answer✔rule that enforces basic and fundamental information-
based constraints (ensure accuracy and consistency of data)
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
password - Answer✔provides authentication of the user
access level - Answer✔determines who has access to the different types of information
access control - Answer✔determines types of user access, such as read-only access
entity - Answer✔object, concept or event (subject)
ex. Customer
attributes - Answer✔a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
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 ________.
table - Answer✔a collection of records
ex. all the information
database - Answer✔a collection of tables
2
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
stores info for a single application
primary key - Answer✔indicates uniqueness within records or rows in a table
foreign key - Answer✔the primary key from another table, this is the only way join relationships
can be established
The Entity Relationship (ER) Model - Answer✔forms the basis of an ER diagram
ERD (entity relationship diagram) - Answer✔represents conceptual database as viewed by end
user
depicts: entities, attributes, and relationships
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"
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
IVR - Answer✔interactive voice response
null value - Answer✔cases where an attribute does not have an applicable value for an
attribute
never allowed in KEY fields
derived attribute - Answer✔if an attribute can be calculated using the value of another
attribute
not stored in the file, but can be ___________ when needed from the stored attributes
stored attributes - Answer✔the attribute that is used to derive the attribute
3
Management 3300 Exam 2 Mizzou Questions
With Correct Answers 100% Verified.
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
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
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
five advantages of databases - Answer✔1. reduce redundancy
2. increase information quality
3. flexibility
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
4. increase information security
5. scalability
relational integrity constraint - Answer✔rule that enforces basic and fundamental information-
based constraints (ensure accuracy and consistency of data)
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
password - Answer✔provides authentication of the user
access level - Answer✔determines who has access to the different types of information
access control - Answer✔determines types of user access, such as read-only access
entity - Answer✔object, concept or event (subject)
ex. Customer
attributes - Answer✔a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
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 ________.
table - Answer✔a collection of records
ex. all the information
database - Answer✔a collection of tables
2
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
stores info for a single application
primary key - Answer✔indicates uniqueness within records or rows in a table
foreign key - Answer✔the primary key from another table, this is the only way join relationships
can be established
The Entity Relationship (ER) Model - Answer✔forms the basis of an ER diagram
ERD (entity relationship diagram) - Answer✔represents conceptual database as viewed by end
user
depicts: entities, attributes, and relationships
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"
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
IVR - Answer✔interactive voice response
null value - Answer✔cases where an attribute does not have an applicable value for an
attribute
never allowed in KEY fields
derived attribute - Answer✔if an attribute can be calculated using the value of another
attribute
not stored in the file, but can be ___________ when needed from the stored attributes
stored attributes - Answer✔the attribute that is used to derive the attribute
3
