MIS 180 (SDSU) EXAM 2 QUESTIONS
WITH COMPLETE SOLUTIONS 2025
, structured data - ANSWERdata easily searchable by algorithms
ex. facts, questionnaire, online behavior, constructed data
unstructured data - ANSWERdata 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? - ANSWERstructured 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? - ANSWERspreadsheets have issues:
- data duplication
- difficulty in data retrieval and search
- poor data integrity
- difficulty in relating different data elements
what are spreadsheets good for? - ANSWERspreadsheets 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? - ANSWERdatabases are good for storing and organizing
information
what are 3 reasons to avoid using spreadsheets? - ANSWERvulnerable 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 - ANSWERthe degree to which
information is correct and free from error
- is there an incorrect value in the information?
characteristic of high-quality information: complete - ANSWER- is there a value missing
from the information?
characteristic of high-quality information: consistent - ANSWERthe degree to which
information is compatible with previous information
- is summary information in agreement with the detailed information?
characteristic of high-quality information: timely - ANSWERthe degree to which
information is available in time to perform the task at hand
WITH COMPLETE SOLUTIONS 2025
, structured data - ANSWERdata easily searchable by algorithms
ex. facts, questionnaire, online behavior, constructed data
unstructured data - ANSWERdata 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? - ANSWERstructured 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? - ANSWERspreadsheets have issues:
- data duplication
- difficulty in data retrieval and search
- poor data integrity
- difficulty in relating different data elements
what are spreadsheets good for? - ANSWERspreadsheets 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? - ANSWERdatabases are good for storing and organizing
information
what are 3 reasons to avoid using spreadsheets? - ANSWERvulnerable 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 - ANSWERthe degree to which
information is correct and free from error
- is there an incorrect value in the information?
characteristic of high-quality information: complete - ANSWER- is there a value missing
from the information?
characteristic of high-quality information: consistent - ANSWERthe degree to which
information is compatible with previous information
- is summary information in agreement with the detailed information?
characteristic of high-quality information: timely - ANSWERthe degree to which
information is available in time to perform the task at hand
