MIS 180 (SDSU) Exam 2 Questions With
All Correct & Verified Answers
structured data Correct answer-data easily searchable by algorithms
ex. facts, questionnaire, online behavior, constructed data
unstructured data Correct answer-data that is difficult to be searched by algorithms, doesn't fit
into relational databases; has internal structure but it is not structured via pre-defined data models
or schema
ex. emails, voice messages, texts, social media
which is easier for businesses to process, and why? Correct answer-structured data is easier for
businesses to process because it is easier for everyone to access and controlled by professionals
why should we, in a business, avoid using spreadsheets to stored data and instead use a database
management system? Correct answer-spreadsheets have issues:
- data duplication
- difficulty in data retrieval and search
- poor data integrity
- difficulty in relating different data elements
what are spreadsheets good for? Correct answer-spreadsheets are fine for very simple data
storage tasks such as keeping simple lists, good for analyzing data, and displaying information visually
what are databases good for? Correct answer-databases are good for storing and organizing
information
what are 3 reasons to avoid using spreadsheets? Correct answer-vulnerable to errors, no clear
formatting rules, only one person can use a spreadsheet at a time, real-time updates are impossible
characteristic of high-quality information: accurate Correct answer-the degree to which
information is correct and free from error
- is there an incorrect value in the information?
characteristic of high-quality information: complete Correct answer-- is there a value missing from
the information?
characteristic of high-quality information: consistent Correct answer-the degree to which
information is compatible with previous information
- is summary information in agreement with the detailed information?
characteristic of high-quality information: timely Correct answer-the degree to which information
is available in time to perform the task at hand
- is the information current with respect to business needs?
characteristic of high-quality information: relevant Correct answer-the degree to which
information is applicable and useful for the task at hand
characteristic of high-quality of information: accessible Correct answer-is it able to be found?
organized?
, why do low-qaulity data and data errors cause the health industry to lose $140 billion each year?
Correct answer-because of data disconnect in the supply chain; healthcare administrators spend
24%-30% of their time correcting data errors; each incorrect transaction costs $60 to $80 to correct;
60% of all invoices among supply chain partners have errors and each one costs $40 to $400 to
correct
data redundancy Correct answer-same data in several places
data inconsistency Correct answer-data values are not synched up across sources
data isolation Correct answer-data in silos, making it hard to access or integrate
data insecurity Correct answer-lots of access points and users, make security tricky
database Correct answer-refers to the stored data and all the files that contain that data; maintains
information about various types of objects (inventory), events (transactions), people (employees),
and places (warehouses)
database management system (DBMS) Correct answer-includes the database AND also includes
the system software, applications, and other system parts that let us USE the database; creates,
reads, updates, and deletes data in a database while controlling access and security
combination of hardware, software, networks, data, procedures, media and people
what are advantages of having a database management system? Correct answer-data is located
centrally: accessible server
data quality (and access) is controlled: by dedicated professionals
data is accessible: everyone can access the data they need
data is easier to maintain: or find, easier to ensure data quality
relational database model Correct answer-a type of database that stores its information in the
form of logically related two-dimensional tables
data value Correct answer-an actual piece of information, at the smallest level
ex. "Mickey" for first name, "Mouse" for last name
field (attribute) Correct answer-stores data about a single characteristic of a record
ex. Mickey's first name, zip code, price, product name (column)
record (row) Correct answer-a set of related fields
ex. all name and address information about one customer, Mickey
file/table (entity) Correct answer-a collection of related records (like customer information,
financial information, inventory information)
ex. a complete set of names and addresses of all customers
instance Correct answer-specific piece of real data
ex. name, address, or phone number
All Correct & Verified Answers
structured data Correct answer-data easily searchable by algorithms
ex. facts, questionnaire, online behavior, constructed data
unstructured data Correct answer-data that is difficult to be searched by algorithms, doesn't fit
into relational databases; has internal structure but it is not structured via pre-defined data models
or schema
ex. emails, voice messages, texts, social media
which is easier for businesses to process, and why? Correct answer-structured data is easier for
businesses to process because it is easier for everyone to access and controlled by professionals
why should we, in a business, avoid using spreadsheets to stored data and instead use a database
management system? Correct answer-spreadsheets have issues:
- data duplication
- difficulty in data retrieval and search
- poor data integrity
- difficulty in relating different data elements
what are spreadsheets good for? Correct answer-spreadsheets are fine for very simple data
storage tasks such as keeping simple lists, good for analyzing data, and displaying information visually
what are databases good for? Correct answer-databases are good for storing and organizing
information
what are 3 reasons to avoid using spreadsheets? Correct answer-vulnerable to errors, no clear
formatting rules, only one person can use a spreadsheet at a time, real-time updates are impossible
characteristic of high-quality information: accurate Correct answer-the degree to which
information is correct and free from error
- is there an incorrect value in the information?
characteristic of high-quality information: complete Correct answer-- is there a value missing from
the information?
characteristic of high-quality information: consistent Correct answer-the degree to which
information is compatible with previous information
- is summary information in agreement with the detailed information?
characteristic of high-quality information: timely Correct answer-the degree to which information
is available in time to perform the task at hand
- is the information current with respect to business needs?
characteristic of high-quality information: relevant Correct answer-the degree to which
information is applicable and useful for the task at hand
characteristic of high-quality of information: accessible Correct answer-is it able to be found?
organized?
, why do low-qaulity data and data errors cause the health industry to lose $140 billion each year?
Correct answer-because of data disconnect in the supply chain; healthcare administrators spend
24%-30% of their time correcting data errors; each incorrect transaction costs $60 to $80 to correct;
60% of all invoices among supply chain partners have errors and each one costs $40 to $400 to
correct
data redundancy Correct answer-same data in several places
data inconsistency Correct answer-data values are not synched up across sources
data isolation Correct answer-data in silos, making it hard to access or integrate
data insecurity Correct answer-lots of access points and users, make security tricky
database Correct answer-refers to the stored data and all the files that contain that data; maintains
information about various types of objects (inventory), events (transactions), people (employees),
and places (warehouses)
database management system (DBMS) Correct answer-includes the database AND also includes
the system software, applications, and other system parts that let us USE the database; creates,
reads, updates, and deletes data in a database while controlling access and security
combination of hardware, software, networks, data, procedures, media and people
what are advantages of having a database management system? Correct answer-data is located
centrally: accessible server
data quality (and access) is controlled: by dedicated professionals
data is accessible: everyone can access the data they need
data is easier to maintain: or find, easier to ensure data quality
relational database model Correct answer-a type of database that stores its information in the
form of logically related two-dimensional tables
data value Correct answer-an actual piece of information, at the smallest level
ex. "Mickey" for first name, "Mouse" for last name
field (attribute) Correct answer-stores data about a single characteristic of a record
ex. Mickey's first name, zip code, price, product name (column)
record (row) Correct answer-a set of related fields
ex. all name and address information about one customer, Mickey
file/table (entity) Correct answer-a collection of related records (like customer information,
financial information, inventory information)
ex. a complete set of names and addresses of all customers
instance Correct answer-specific piece of real data
ex. name, address, or phone number
