Management 3300 Final Exam QUESTIONS WITH ANSWER
GUARANTEE A+ 2025/2026
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 - -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 - rule that enforce business rules vital
to an organization's success and often require more insight and knowledge
than relational integrity constraints
entity - object, concept or event (subject)
ex. Customer
attributes - a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
record - 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 - a collection of records
,ex. all the information
database - a collection of tables
stores info for a single application
primary key - indicates uniqueness within records or rows in a table
foreign key - the primary key from another table, this is the only way join
relationships can be established
ERD (entity relationship diagram) - represents conceptual database as
viewed by end user
depicts: entities, attributes, and relationships
cardinality - 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 - a process that refines entities and their relationships to help
minimize duplication of information tables
null value - cases where an attribute does not have an applicable value for
an attribute
never allowed in KEY fields
derived attribute - 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 - the attribute that is used to derive the attribute
, composite attributes - can be divided into smaller subparts, which represent
more basic attributes that have their own meanings
ex. Address
-can be broken down into a number of subparts, such as street, city, state,
zip code
data dictionary - stores definitions of information types, identifies the
primary and foreign keys, and maintains the relationships among the
tables.
big data - an accumulation of data from:
company employees entering data
users entering their own data
machines/computers are accumulating data
collections of data that are so enormous in size, so varied in content, and
so fast to accumulate that they are difficult to store and analyze transitional
approaches
parallel processing - so much data is being generated that it can't load the
dataset on one computer, server. In order to compensate we use this
hadoop - an open source platform, allows parallel processing of big data
created by doug cutting
data warehousing - provides the ability to support decision making without
disrupting the day-to-day operations. Used for business analysis, not
business transactions.
Primary purpose is to aggregate information throughout an organization
into a single repository for decision-making purposes
stores info from multiple databases, or multiple applications, and external
info such as industry info
database - stores information for single application
extract, transform, load (ETL) - the process used to build a data warehouse
GUARANTEE A+ 2025/2026
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 - -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 - rule that enforce business rules vital
to an organization's success and often require more insight and knowledge
than relational integrity constraints
entity - object, concept or event (subject)
ex. Customer
attributes - a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
record - 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 - a collection of records
,ex. all the information
database - a collection of tables
stores info for a single application
primary key - indicates uniqueness within records or rows in a table
foreign key - the primary key from another table, this is the only way join
relationships can be established
ERD (entity relationship diagram) - represents conceptual database as
viewed by end user
depicts: entities, attributes, and relationships
cardinality - 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 - a process that refines entities and their relationships to help
minimize duplication of information tables
null value - cases where an attribute does not have an applicable value for
an attribute
never allowed in KEY fields
derived attribute - 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 - the attribute that is used to derive the attribute
, composite attributes - can be divided into smaller subparts, which represent
more basic attributes that have their own meanings
ex. Address
-can be broken down into a number of subparts, such as street, city, state,
zip code
data dictionary - stores definitions of information types, identifies the
primary and foreign keys, and maintains the relationships among the
tables.
big data - an accumulation of data from:
company employees entering data
users entering their own data
machines/computers are accumulating data
collections of data that are so enormous in size, so varied in content, and
so fast to accumulate that they are difficult to store and analyze transitional
approaches
parallel processing - so much data is being generated that it can't load the
dataset on one computer, server. In order to compensate we use this
hadoop - an open source platform, allows parallel processing of big data
created by doug cutting
data warehousing - provides the ability to support decision making without
disrupting the day-to-day operations. Used for business analysis, not
business transactions.
Primary purpose is to aggregate information throughout an organization
into a single repository for decision-making purposes
stores info from multiple databases, or multiple applications, and external
info such as industry info
database - stores information for single application
extract, transform, load (ETL) - the process used to build a data warehouse
