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
