ch 4 end of chapter Flashcards
Martin & Martin, LLC is a nonprofit organization offering pro-bono legal services using a network of lawyers. The basement of their office is filled with boxes containing the files of hundreds of cases completed over the past ten years. The legal documents stored in the file boxes are an example of ________.
A. structured information
B. semistructured information
C. knowledge
D. facts
E. unstructured information
E. unstructured information
Amazon.com stores all transaction data about its customers with clearly defined fields for customer name, items purchased, order history, amount spent, etc. This is an example of ________.
A. a customer service system
B. semistructured information
C. metadata
D. structured information
E. a customer information file
D. structured information
The search function of major photo-sharing websites such Flickr.com depend on information that is tagged with each photo including the photographer’s name, contact information, release and copyright status, as well as caption and location data. This information is collectively known as ________.
A. a database
B. structured information
C. metadata
D. photo tags
E. semi-structured information
C. metadata
John Monfort has been hired by Daniel Appliance Company to collect data from customers who returned appliances over the past ten years. The survey asked for the customer’s opinion about the kind of service they received. John’s survey results are likely to be of little use to the company because the information lacks which of the following characteristics of high-quality information?
A. Timeliness
B. Duplication
C. Logical
D. Bias
E. Completeness
A. Timeliness
When aggregate or summarized information is in agreement with detailed information, it has which characteristic of high-quality information?
A. Completeness
B. Timeliness
C. Consistency
D. Bias
E. Uniqueness
C. Consistency
Professor Jones is accessing information about students currently enrolled in her Management Information Systems course. She wants to print out a class listing so she can take attendance each day. The information about the students in her class is stored in a ________.
A. student enrollment system
B. data dictionary
C. record
D. database
E. data mart
D. database
Iron Bank Coffee has three retail stores, each operating independently with their own database of customers and products. The owner, Richard Smith, has decided to consolidate the databases of the three stores into a single database. Which of the following is NOT a benefit Mr. Smith will realize by consolidating the databases?
A. Uses less hard disk space
B. Improves information quality
C. Increases the number of customers for the coffee shops
D. Makes performing information updates easier
E. Reduces data redundancy
C. Increases the number of customers for the coffee shops
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
A. online processing
B. data modeling
C. data redundancy
D. batch processing
E. data independence
C. data redundancy
The Acme Company’s payroll office maintains its employee pay records within its own computer files, each containing information that is required for processing monthly payroll checks. A separate area of the company handles employee benefits with its own computer system and employee records. Acme Company is limited to comparing and analyzing employee information in these files for which of the following reasons?
A. Complicated tables and fields
B. Consistent data definitions
C. Data independence
D. Data integrity
E. Lack of data integration
E. Lack of data integration
The employee database of Synovus Financial Company needs to store the birth date of each employee. In the context of database architecture, this is an example of ________.
A. many-to-many
B. a hierarchical database
C. data integrity
D. one-to-one
E. one-to-many
D. one-to-one
A database model that organizes information into tables of records that are connected to one another by linking a field in one table to a field in another table with matching data is called a(n) ________ database.
A. web-enabled
B. relational
C. hierarchical
D. object-oriented
E. network
B. relational
Sally Weathers is a student at Valdosta State University. Her student ID number is the main number she uses for her school-related activities such as enrollment and meal charges. Sally’s student ID number in a table of student records would be referred to as a ________.
A. unique ID
B. foreign key
C. normal key
D. secondary key
E. primary key
E. primary key
Devon Degosta is finalizing the database for DD-Designs. The last process involves minimizing the redundant information in the database and eliminating any awkward many-to-many relationships. Which process is Devon performing?
A. Data scrubbing
B. Data modeling
C. Normalization
D. Data recovery
E. Data mining
C. Normalization
Devon Degosta is planning the organization’s database. The model Devon is developing to identify what kind of information is needed, what entities will be created, and how they are related to one another is called a(n) ________.
A. process model
B. functional model
C. hierarchical model
D. archiving model
E. data model
E. data model
In Valdosta State University’s database, student records in the student table are linked to the university’s academic majors table through a common field, which is the major code. In the student table, the major code is a ________.
A. record
B. complex key
C. functional key
D. primary key
E. foreign key
E. foreign key
Taxpayers who move and do not leave a forwarding address may never receive their tax refunds because the check is returned as undeliverable. To address this problem, the IRS has implemented a process where taxpayers can go online and key in their name, state, and tax year to see if they have a refund that was undeliverable. This is an example of using a ________ to retrieve information from the IRS database.
A. primary key
B. SQL query
C. relational database
D. web search tool
E. table
B. SQL query
Devon Degosta is updating the employee database with information on a new employee. She enters the employee information into the employee table and then tries to add a department ID for a department that does not exist in the Departments table. The system does not allow her to add the employee record until she creates a Department ID first in the Department table so the employee can then be assigned to it. This is an example of the system enforcing a ________.
A. database constraint
B. data model
C. business rule
D. scalability constraint
E. referential integrity constraint
E. referential integrity constraint
Realtree Outdoors, Inc. maintains a centralized repository of information from internal sources, competitor information, census reports, metadata from documents and multimedia, and other information. This repository is known as a(n) ________.
A. data dictionary
B. shadow system
C. data warehouse
D. data mart
E. operational database
C. data warehouse
Alyssa Meade is the database administrator for Realtree Outdoors, Inc. She is updating the data warehouse by using zip codes to add demographic data from the U.S. Census Bureau to the company’s customer records before loading them into the data warehouse. What is this process called?
A. Transformation process
B. Assimilation process
C. Extraction process
D. Data-mining process
E. Normalization process
A. Transformation process
Many organizations create ________, which are separate databases that include subsets of the data warehouse’s data focused on particular functional areas of the business.
A. data stores
B. data sets
C. data marts
D. data shops
E. data subsets
C. data marts
To improve performance, a _________ can be implemented in which portions of the database are located on separate servers.
A. data warehouse
B. data mart
C. shadow system
D. database management system
E. distributed database
E. distributed database
An expected benefit of blockchain technology is __________.
A. fewer reporting formats
B. faster response time
C. a reduced possibility of tampering
D. more ownership challenges
E. conflicting information
C. a reduced possibility of tampering
To support an innovative idea for an important business project, a manager creates a separate database system that is not integrated into the enterprise database. This is an example of a(n) ________.
A. foreign database
B. data mart
C. excessive documentation method
D. shadow system
E. data warehouse
D. shadow system
When employees create a shadow system, organizations are often faced with many issues, including ________.
A. better response time to customers
B. higher levels of productivity from employees
C. shadow system data may become inconsistent with data in corporate databases
D. faster and more efficient work being completed
E. not having to use IT staff to manage the shadow systems
C. shadow system data may become inconsistent with data in corporate databases
Why do data ownership issues often arise in the workplace?
A. Data security and compliance controls are well enforced.
B. The quality of data varies across departments.
C. Data is stored in databases on external servers.
D. Data is shared by all the stakeholders in the organization.
E. Data is often taken from external sources.
D. Data is shared by all the stakeholders in the organization.