CH 5

Which of the following is NOT a problem associated with Big Data? Big Data can be structured, unstructured, or semi-structured. Big Data can come from untrusted sources. Big Data changes. Big Data lacks quality.

Big Data can be structured, unstructured, or semi-structured.

_______ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity. Data dictionary Modality Cardinality Business rules

Cardinality

Africa collaborated with ________ to stop the Ebola virus outbreak in 2013 and 2014. Microsoft IBM Google Amazon

IBM

Data marts and data warehouses typically use ________. OLTP RFID ERP OLAP

OLAP

_______ is the most popular query language used for interacting with a database. ETL RFID SQL TPS

SQL

A ________ is a group of eight ________. field; files bit; bytes file; fields byte; bits

byte; bits

Suppose you work for XYZ Corporation. You know you can contribute 6% of your salary to a 401K and the company will match that 100% after 6 years of service because it is in the employee handbook. This is an example of ________. tacit knowledge explicit knowledge tacit information explicit information

explicit knowledge

All the information about you in your university's database is a(n) ________. attribute instance database entity

instance

Databases ________ inconsistency; this means ________. maximize; the same data are stored in multiple locations minimize; the same data are stored in multiple locations maximize; various copies of the data do not agree minimize; various copies of the data do not agree

minimize; various copies of the data do not agree

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance. minimum; minimum maximum; minimum minimum; maximum maximum; maximum

minimum; maximum

Data marts can be implemented ________ compared to data warehouses. It depends on the situation. less quickly more quickly at the same pace

more quickly

A circle with a "chicken leg" to the entity represents the ________ cardinality symbol. mandatory many mandatory single optional many optional single

optional many

A ________ generally describes an entity. byte record field file

record

Database systems minimize ________. independence redundancy security integrity

redundancy

Jana is a mobile startup designed to ________. offer free smartphones to people who make less than 20 cents an hour in China reward users with data in exchange for collecting their personal information when sampling apps charge users less money to use mobile data than they have to pay their telecommunication company give app developers free access to other apps

reward users with data in exchange for collecting their personal information when sampling apps

You recently inherited an Alvin and The Chipmunks "A Chipmunk Christmas" record. Since you don't have a record player, you need to find a way to convert the record into a CD. This is an example of data ________. rot degradation scattering clickstreaming

rot

Considering the following tables, ________ is a primary key. Student Table SID Name Expected Graduation 123 Smith 2017 234 Jones 2018 567 Barilla 2018 Professor Table PID Name Tenure Year ABC Jones 1995 DEF Brilliant 2000 GHI Genius 2000 Class Table ID Name PID MGT101 Intro to Management ABC BUS101 Intro to Business ABC MGT201 Intermediate Management GHI Student Table: Expected Graduation Year Student Table: ID Class Table: PID Professor Table: Name

student table id

Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization's memory, usually in a(n) ________ format. structured part-structured semi-structured unstructured

unstructured