MIS 180 (SDSU) Exam 2 Questions With Complete Solutions

structured data - Answer-data easily searchable by algorithms ex. facts, questionnaire, online behavior, constructed data unstructured data - 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? - 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? - 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? - 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? - Answer-databases are good for storing and organizing information what are 3 reasons to avoid using spreadsheets? - 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 - 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 - Answer-- is there a value missing from the information? characteristic of high-quality information: consistent - 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 - 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 - Answer-the degree to which information is applicable and useful for the task at hand characteristic of high-quality of information: accessible - 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? - 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 - Answer-same data in several places data inconsistency - Answer-data values are not synched up across sources data isolation - Answer-data in silos, making it hard to access or integrate data insecurity - Answer-lots of access points and users, make security tricky database - 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) - 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? - 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