BIS 111 ch6&7 – Flashcards
Unlock all answers in this set
Unlock answersquestion
What are the different types of information?
answer
Levels, formats, granularities
question
Which of the following represents the different information levels?
answer
Individual, department, enterprise
question
Which of the following represents the different information formats?
answer
Document, presentation, spreadsheet, database
question
Which of the following represents the different information granularities?
answer
Detail, summary, aggregate
question
All of the following are characteristics of information, except:
answer
Quantity
question
What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?
answer
Transactional information
question
Which of the following is an example of transactional information?
answer
A. Withdrawing cash from an ATM B. Making an airline reservation C. Purchasing stock D. All of the above
question
________________ achieved great success by managing information, while _________ was unsuccessful at managing information.
answer
Samsung Electronics, Staples
question
What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
answer
Analytical information
question
Which of the following is an example of transactional information?
answer
purchasing stock
question
What is immediate, up-to-date information?
answer
Real-time information
question
What provides real-time information in response to query requests?
answer
Real-time systems
question
What is one of the biggest pitfalls associated with real-time information?
answer
It continually changes
question
Which of the following is not one of the five characteristics common to high quality information?
answer
Quantity
question
Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
Which of the following implies that information is current with respect to the business requirement?
answer
Timeliness
question
What is it called when each transaction, entity, and event is represented only once in the information?
answer
Uniqueness
question
What is a real-time system?
answer
Provides real-time information in response to query requests
question
Organizational information comes at different levels and in different formats and granularities.
answer
True
question
Reports for each sales person, product, and part are examples of detail or fine information granularities.
answer
True
question
Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.
answer
True
question
Timely information must be up-to-the-second to be accurate.
answer
False Timely information can change for each business decision. Some decisions require weekly information while others require daily information.
question
Which of the following types of information can be found in a database?
answer
A database maintains information on inventory, transactions, and employees.
question
Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?
answer
Hierarchical database
question
Which of the following database structures offers a flexible way of representing objects and their relationships?
answer
Network database
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
In the relational database model, what are characteristics or properties of an entity?
answer
Attribute
question
What are characteristics or properties of an entity called?
answer
A. Attributes B. Fields C. Columns D. All of the above Attributes are also called fields or columns.
question
Why do relational databases use primary keys and foreign keys?
answer
To create logical relationships
question
What is a primary key?
answer
A field (or group of fields) that uniquely identifies a given entity in a table
question
What is a foreign key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
question
All of the following are advantages of database-stored information, except:
answer
Increased information redundancy
question
Which of the following is incorrect in reference to a database?
answer
Information is accessed by physical structure
question
What is the physical view of information?
answer
Deals with the physical storage of information on a storage device such as a hard disk
question
Which of the following is correct in reference to a database?
answer
A database can support many logical views
question
What refers to how well a system can adapt to increased demands?
answer
Scalability
question
Which of the following measures how quickly a system performs a certain process or transaction?
answer
Performance
question
What is information redundancy?
answer
A. Duplication of information B. Storing the same information in multiple places C. Storing duplicate information in multiple places D. All of the above
question
What is the primary problem with redundant information?
answer
A. It is difficult to determine which values are the most current B. It is often inconsistent C. It is difficult to determine which values are the most accurate D. All of the above
question
Which of the following is true in regards to the elimination of redundant information?
answer
Improves information quality
question
What are the rules that help ensure the quality of information?
answer
Integrity constraints
question
What are the rules that enforce basic and fundamental information-based constraints?
answer
Relational integrity constraint
question
Which of the following is a valid type of integrity constraint?
answer
Business-critical integrity constraint
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraint
question
All of the following are business-critical integrity constraints, except:
answer
System will not allow returns of fresh produce after 15 days past delivery
question
Which of the following uses a DBMS to interact with a database?
answer
A. Users of accounting programs B. Users of human resource programs C. Users of marketing programs D. All of the above
question
What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
answer
Data-driven website
question
What type of website is best to build for a general informational website with static information?
answer
Static website
question
What type of website is best to build for a website with continually changing information including press releases, new product information, and updated pricing?
answer
Data-driven website
question
Which of the following is not an advantage of building a data-driven website?
answer
Minimizes or reduces efficiency
question
What is a forward integration?
answer
Takes information entered into a given system and sends it automatically to all downstream systems and processes
question
What is a backward integration?
answer
Takes information entered into a given system and sends it automatically to all upstream systems and processes
question
What is an integration?
answer
Allows separate systems to communicate directly with each other
question
A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.
answer
FALSE A primary key is a field (or group of fields) that uniquely identifies a given entity in a table.
question
Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
answer
True
question
A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.
answer
True
question
Ideally, an organization only wants to build forward integrations.
answer
FALSE Ideally, an organization wants to build both forward and backward integrations.
