- What are the different types of information?
A. Levels, forms, granularities
B. Levels, forms, data
C. Levels, formats, granularities
D. Data, formats, granularities
- Which of the following represents the different information levels?
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
- Which of the following represents the different information formats?
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
- Which of the following represents the different information granularities?
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
- All of the following are characteristics of information, except:
A. Transactional
B. Analytical
C. Timeliness
D. Quantity
- 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?
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
- Which of the following is an example of transactional information?
A. Withdrawing cash from an ATM
B. Making an airline reservation
C. Purchasing stock
D. All of the above
- ________________ achieved great success by managing information, while _________ was unsuccessful at managing information.
A. Samsung Electronics, Staples
B. Staples, Samsung Electronics
C. Office Max, Staples
D. Staples, Office Max
- What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
- Which of the following is an example of transactional information?
A. Trend projection
B. Sales projection
C. Purchasing stock
D. All of the above
- What is immediate, up-to-date information?
A. Real-time information
B. Real-time systems
C. Information granularity
D. All of the above
- What provides real-time information in response to query requests?
A. Real-time information
B. Real-time systems
C. Information level
D. All of the above
- What is one of the biggest pitfalls associated with real-time information?
A. It is only available to high-level executives due to the expense
B. It is only available in aggregate levels of granularity
C. It continually changes
D. It rarely changes
- Which of the following is not one of the five characteristics common to high quality information?
A. Accuracy
B. Completeness
C. Quantity
D. Consistency
- Which of the following implies that aggregate or summary information is in agreement with detailed information?
A. Uniqueness
B. Completeness
C. Consistency
D. Accuracy
- Which of the following implies that information is current with respect to the business requirement?
A. Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
- What is it called when each transaction, entity, and event is represented only once in the information?
A. Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
- What is a real-time system?
A. Provides immediate, up-to-date information
B. Provides real-time information in response to query requests
C. Encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks
D. 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
True / False Questions
- Organizational information comes at different levels and in different formats and granularities.
True False
- Reports for each sales person, product, and part are examples of detail or fine information granularities.
True False
- Purchasing stocks is an example of analytical information.
True False
- 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.
True False
- Timely information must be up-to-the-second to be accurate.
True False
Fill in the Blank Questions
- Organizational information comes in different ___________, formats, and granularities.
________________________________________
- Detail, summary, and _________ are the typical information granularities.
________________________________________
- ____________ information 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.
________________________________________
- ____________ information encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks.
________________________________________
- Organizations use _______________ information to make repetitive decisions.
________________________________________
- Organizations use _________ information to make ad hoc decisions.
________________________________________
- The ________ characteristic of high quality information ensures that all the values are correct.
________________________________________
- The ________ characteristic of high quality information ensures that none of the values are missing.
________________________________________
- The ________ characteristic of high quality information ensures that each transaction, entity, and event is represented only once.
________________________________________
- The ________ characteristic of high quality information ensures that the information is current with respect to the business requirement.
________________________________________
Essay Questions
- Describe the broad levels, formats, and granularities of information.
- List, describe, and provide an example of each of the five characteristics of high quality information.
- List the four primary sources of low quality information.
- Assess the impact of low quality information on an organization and the benefits of high quality information on an organization.
Chapter 06 Valuing Organizational Information Answer Key
Multiple Choice Questions
- What are the different types of information?
A.Levels, forms, granularities
B. Levels, forms, data
C. Levels, formats, granularities
D. Data, formats, granularities
Levels, formats, and granularities are the different types of information.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following represents the different information levels?
A.Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
The different information levels include individual, department, and enterprise.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following represents the different information formats?
A.Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
The different information formats include document, presentation, spreadsheet, and database.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following represents the different information granularities?
A.Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of the above
The different information granularities include detail, summary, and aggregate.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- All of the following are characteristics of information, except:
A.Transactional
B. Analytical
C. Timeliness
D. Quantity
Quality is the characteristic of information, not quantity.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- 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?
A.Transactional information
B. Analytical information
C. Timeliness
D. Quality
This is the definition of transactional information.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following is an example of transactional information?
A.Withdrawing cash from an ATM
B. Making an airline reservation
C. Purchasing stock
D. All of the above
All of the above are examples of transactional information.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- ________________ achieved great success by managing information, while _________ was unsuccessful at managing information.
A.Samsung Electronics, Staples
B. Staples, Samsung Electronics
C. Office Max, Staples
D. Staples, Office Max
Samsung Electronics achieved great success by managing information, while Staples was unsuccessful at managing information.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Medium
Taxonomy: Knowledge & Understanding
- What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
A.Transactional information
B. Analytical information
C. Timeliness
D. Quality
This is the definition of analytical information.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following is an example of transactional information?
A.Trend projection
B. Sales projection
C. Purchasing stock
D. All of the above
Purchasing stock is an example of transactional information.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- What is immediate, up-to-date information?
A.Real-time information
B. Real-time systems
C. Information granularity
D. All of the above
This is the definition of real-time information.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- What provides real-time information in response to query requests?
A.Real-time information
B. Real-time systems
C. Information level
D. All of the above
This is the definition of real-time information systems.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- What is one of the biggest pitfalls associated with real-time information?
A.It is only available to high-level executives due to the expense
B. It is only available in aggregate levels of granularity
C. It continually changes
D. It rarely changes
Information continually changes and this can cause issues with real-time information.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Medium
Taxonomy: Knowledge & Understanding
- Which of the following is not one of the five characteristics common to high quality information?
A.Accuracy
B. Completeness
C. Quantity
D. Consistency
Accuracy, completeness, consistency, uniqueness, and timeliness are the characteristics of high quality information.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following implies that aggregate or summary information is in agreement with detailed information?
A.Uniqueness
B. Completeness
C. Consistency
D. Accuracy
This is the definition of consistency as displayed in Figure 6.3.
AACSB: Use of Information Technology
Learning Outcome: 6.4
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following implies that information is current with respect to the business requirement?
A.Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
This is the definition of timeliness.
AACSB: Use of Information Technology
Learning Outcome: 6.4
Level: Easy
Taxonomy: Knowledge & Understanding
- What is it called when each transaction, entity, and event is represented only once in the information?
A.Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
This is the definition of uniqueness.
AACSB: Use of Information Technology
Learning Outcome: 6.4
Level: Easy
Taxonomy: Knowledge & Understanding
- What is a real-time system?
A.Provides immediate, up-to-date information
B. Provides real-time information in response to query requests
C. Encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks
D. 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
This is the definition of real-time system.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
True / False Questions
- Organizational information comes at different levels and in different formats and granularities.
TRUE
Employees must be able to correlate the different formats, levels, and granularities of information.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Reports for each sales person, product, and part are examples of detail or fine information granularities.
TRUE
Information granularities include detailed (or fine) information such as reports for each sales person, product, or parts.
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Medium
Taxonomy: Knowledge & Understanding
- Purchasing stocks is an example of analytical information.
FALSE
Purchasing stocks is an example of transactional information.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- 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.
TRUE
Transactional information is used to perform operational tasks.
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Timely information must be up-to-the-second to be accurate.
FALSE
Timely information can change for each business decision. Some decisions require weekly information while others require daily information.
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Medium
Taxonomy: Knowledge & Understanding
Fill in the Blank Questions
- Organizational information comes in different ___________, formats, and granularities.
Levels
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Detail, summary, and _________ are the typical information granularities.
Aggregate
AACSB: Use of Information Technology
Learning Outcome: 6.1
Level: Easy
Taxonomy: Knowledge & Understanding
- ____________ information 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.
Transactional
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- ____________ information encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks.
Analytical
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Organizations use _______________ information to make repetitive decisions.
Transactional
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Organizations use _________ information to make ad hoc decisions.
Analytical
AACSB: Use of Information Technology
Learning Outcome: 6.2
Level: Easy
Taxonomy: Knowledge & Understanding
- The ________ characteristic of high quality information ensures that all the values are correct.
Accuracy
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- The ________ characteristic of high quality information ensures that none of the values are missing.
Completeness
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- The ________ characteristic of high quality information ensures that each transaction, entity, and event is represented only once.
Uniqueness
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
- The ________ characteristic of high quality information ensures that the information is current with respect to the business requirement.
Timeliness
AACSB: Use of Information Technology
Learning Outcome: 6.3
Level: Easy
Taxonomy: Knowledge & Understanding
Essay Questions
- Describe the broad levels, formats, and granularities of information.
Information levels include individual, department, and enterprise. Information format include document, presentation, spreadsheet, and database. Information granularities include detail, summary, and aggregate.
AACSB: Reflective Thinking Skills
Learning Outcome: 6.1
Level: Easy
Taxonomy: Application and Analysis
- List, describe, and provide an example of each of the five characteristics of high quality information.
Accuracy determines if all values are correct. Example – is the name spelled correctly? Completeness determines if any values are missing. Example – is the address complete? Consistency ensures that aggregate or summary information is in agreement with detailed information. Example – do totals equal the true total of the individual fields? Uniqueness ensures that each transaction, entity, and event is represented only once in the information. Example – are there any duplicate customers? Timeliness determines if the information is current with respect to the business requirement. Example – is the information updated weekly?
AACSB: Reflective Thinking Skills
Learning Outcome: 6.3
Level: Easy
Taxonomy: Application and Analysis
- List the four primary sources of low quality information.
(1) Online customers intentionally enter inaccurate information to protect their privacy. (2) Information from different systems that have different information entry standards and formats. (3) Call center operators enter abbreviated or erroneous information by accident or to save time. (4) Third party and external information contains inconsistencies, inaccuracies, and errors.
AACSB: Reflective Thinking Skills
Learning Outcome: 6.4
Level: Medium
Taxonomy: Application and Analysis
- Assess the impact of low quality information on an organization and the benefits of high quality information on an organization.
Using the wrong information can lead to making the wrong decision. Making the wrong decision can cost time, money, and even reputations. Business decisions are only as good as the information used to make the decision. Low quality information leads to low quality business decisions. High quality information can significantly improve the chances of making a good business decision and directly effect an organization’s bottom line.
AACSB: Reflective Thinking Skills
Learning Outcome: 6.4
Level: Medium
Taxonomy: Application and Analysis
Chapter 07
Storing Organizational Information-Databases
Multiple Choice Questions
- Which of the following types of information can be found in a database?
A. Inventory
B. Transactions
C. Employees
D. All of the above
- 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?
A. Hierarchical database
B. Network database
C. Relational database model
D. All of the above
- Which of the following database structures offers a flexible way of representing objects and their relationships?
A. Hierarchical database
B. Network database
C. Relational database model
D. All of the above
- In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
A. Entity
B. Logical view
C. Attribute
D. Physical view
- In the relational database model, what are characteristics or properties of an entity?
A. Entity
B. Logical view
C. Attribute
D. Physical view
- What are characteristics or properties of an entity called?
A. Attributes
B. Fields
C. Columns
D. All of the above
- Why do relational databases use primary keys and foreign keys?
A. To create a database
B. To create physical relationships
C. To create logical relationships
D. All of the above
- What is a primary key?
A. A field (or group of fields) that uniquely identifies a given entity in a table
B. 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
C. Characteristics or properties of an entity
D. A field (or group of fields) that uniquely identifies a given attribute in a table
- What is a foreign key?
A. A field (or group of fields) that uniquely identifies a given entity in a table
B. 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
C. Characteristics or properties of an entity
D. A field (or group of fields) that uniquely identifies a given attribute in a table
- All of the following are advantages of database-stored information, except:
A. Increased flexibility
B. Increased performance
C. Increased information redundancy
D. Increased information integrity
- Which of the following is incorrect in reference to a database?
A. Can be relational or network
B. Information is accessed by logical structure
C. Information is accessed by physical structure
D. Users can access different views of information
- What is the physical view of information?
A. Deals with the physical storage of information on a storage device such as a hard disk
B. Deals with the logical storage of information on a storage device such as a hard disk
C. Focuses on how users logically access information to meet their particular business needs
D. Focuses on how users physically access information to meet their particular business needs
- Which of the following is correct in reference to a database?
A. A database can support only one logical view
B. A database can support many physical views
C. A database can support many logical views
D. A database can support up to 3 logical views
- What refers to how well a system can adapt to increased demands?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
- Which of the following measures how quickly a system performs a certain process or transaction?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
- What is information redundancy?
A. Duplication of information
B. Storing the same information in multiple places
C. Storing duplicate information in multiple places
D. All of the above
- What is the primary problem with redundant information?
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
- Which of the following is true in regards to the elimination of redundant information?
A. Uses additional hard disk space
B. Makes performing information updates harder
C. Improves information quality
D. All of the above
- What are the rules that help ensure the quality of information?
A. Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints
- What are the rules that enforce basic and fundamental information-based constraints?
A. Information integrity
B. Integrity constraint
C. Business-critical integrity constraint
D. Relational integrity constraint
- Which of the following is a valid type of integrity constraint?
A. Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint
- What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
A. Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of the above
- All of the following are business-critical integrity constraints, except:
A. System will not allow an entry for an order for a nonexistent customer
B. System will not allow returns of fresh produce after 15 days past delivery
C. System will not allow shipping a product to a customer who does not have a valid address
D. Systems will not allow shipping of a nonexistent product to a customer
- Which of the following uses a DBMS to interact with a database?
A. Users of accounting programs
B. Users of human resource programs
C. Users of marketing programs
D. All of the above
- What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
A. Customer-driven website
B. Data-driven website
C. Customer-driven database
D. Data-driven database
- What type of website is best to build for a general informational website with static information?
A. Data-driven website
B. Static website
C. Relational website
D. All of the above
- What type of website is best to build for a website with continually changing information including press releases, new product information, and updated pricing?
A. Data-driven website
B. Static website
C. Relational website
D. All of the above
- Which of the following is not an advantage of building a data-driven website?
A. Minimizes human error
B. Cuts production and update costs
C. Improves or maximizes stability
D. Minimizes or reduces efficiency
- What is a forward integration?
A. Takes information entered into a given system and sends it to the application generation component
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes
D. Takes information entered into a given system and sends it to the DBMS
- What is a backward integration?
A. Takes information entered into a given system and sends it to the application generation component
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes
D. Takes information entered into a given system and sends it to the DBMS
- What is an integration?
A. Allows separate systems to communicate directly with each other
B. Takes information entered into a given system and sends it to the database
C. Takes information entered into a given system and sends it to other processes
D. Takes information entered into a given system and sends it to the DBMS
True / False Questions
- A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.
True False
- One of the advantages found in a relational database is increased information redundancy.
True False
- Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
True False
- 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.
True False
- Ideally, an organization only wants to build forward integrations.
True False
Fill in the Blank Questions
- The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.
________________________________________
- Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.
________________________________________
- A(n) ___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.
________________________________________
- A _______________ key is a field that uniquely identifies a given entity in a table.
________________________________________
- The _________ view of information deals with the physical storage of information on a storage device such as a hard disk.
________________________________________
- The ________ view of information focuses on how users logically access information to meet their particular business needs.
________________________________________
- ______________ is the duplication of information, or storing the same information in multiple places.
________________________________________
- ______________ integrity constraints are rules that enforce business rules vital to an organization’s success.
________________________________________
- _________ integrity is a measure of the quality of information.
________________________________________
Essay Questions
- Evaluate the advantages of the relational database model.
- Compare relational integrity constraints and business-critical integrity constraints.
- Describe the role and purpose of a database management system.
Chapter 07 Storing Organizational Information-Databases Answer Key
Multiple Choice Questions
- Which of the following types of information can be found in a database?
A.Inventory
B. Transactions
C. Employees
D. All of the above
A database maintains information on inventory, transactions, and employees.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- 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?
A.Hierarchical database
B. Network database
C. Relational database model
D. All of the above
This is the definition of hierarchical database.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following database structures offers a flexible way of representing objects and their relationships?
A.Hierarchical database
B. Network database
C. Relational database model
D. All of the above
This is the definition of network database model.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
A.Entity
B. Logical view
C. Attribute
D. Physical view
This is the definition of entity.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- In the relational database model, what are characteristics or properties of an entity?
A.Entity
B. Logical view
C. Attribute
D. Physical view
This is the definition of attribute.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- What are characteristics or properties of an entity called?
A.Attributes
B. Fields
C. Columns
D. All of the above
Attributes are also called fields or columns.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Medium
Taxonomy: Knowledge & Understanding
- Why do relational databases use primary keys and foreign keys?
A.To create a database
B. To create physical relationships
C. To create logical relationships
D. All of the above
Keys are used to create logical relationships.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Medium
Taxonomy: Knowledge & Understanding
- What is a primary key?
A.A field (or group of fields) that uniquely identifies a given entity in a table
B. 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
C. Characteristics or properties of an entity
D. A field (or group of fields) that uniquely identifies a given attribute in a table
This is the definition of primary key.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- What is a foreign key?
A.A field (or group of fields) that uniquely identifies a given entity in a table
B. 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
C. Characteristics or properties of an entity
D. A field (or group of fields) that uniquely identifies a given attribute in a table
This is the definition of foreign key.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- All of the following are advantages of database-stored information, except:
A.Increased flexibility
B. Increased performance
C. Increased information redundancy
D. Increased information integrity
Database-stored information reduces information redundancy.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following is incorrect in reference to a database?
A.Can be relational or network
B. Information is accessed by logical structure
C. Information is accessed by physical structure
D. Users can access different views of information
A database accesses information by logical structure and stores information by physical structure.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Medium
Taxonomy: Knowledge & Understanding
- What is the physical view of information?
A.Deals with the physical storage of information on a storage device such as a hard disk
B. Deals with the logical storage of information on a storage device such as a hard disk
C. Focuses on how users logically access information to meet their particular business needs
D. Focuses on how users physically access information to meet their particular business needs
This is the definition of physical view.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following is correct in reference to a database?
A.A database can support only one logical view
B. A database can support many physical views
C. A database can support many logical views
D. A database can support up to 3 logical views
A database can support many logical views.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Medium
Taxonomy: Knowledge & Understanding
- What refers to how well a system can adapt to increased demands?
A.Scalability
B. Performance
C. Redundancy
D. Information integrity
This is the definition of scalability.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Which of the following measures how quickly a system performs a certain process or transaction?
A.Scalability
B. Performance
C. Redundancy
D. Information integrity
This is the definition of performance.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- What is information redundancy?
A.Duplication of information
B. Storing the same information in multiple places
C. Storing duplicate information in multiple places
D. All of the above
Redundancy is all of the above.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Medium
Taxonomy: Knowledge & Understanding
- What is the primary problem with redundant information?
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
All of the above are problems with redundant information.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Hard
Taxonomy: Knowledge & Understanding
- Which of the following is true in regards to the elimination of redundant information?
A.Uses additional hard disk space
B. Makes performing information updates harder
C. Improves information quality
D. All of the above
Eliminating redundant information improves the quality of the information, uses less hard disk space, and makes performing updates easier.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Medium
Taxonomy: Knowledge & Understanding
- What are the rules that help ensure the quality of information?
A.Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints
This is the definition of integrity constraints.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- What are the rules that enforce basic and fundamental information-based constraints?
A.Information integrity
B. Integrity constraint
C. Business-critical integrity constraint
D. Relational integrity constraint
This is the definition of relational integrity constraints.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Medium
Taxonomy: Knowledge & Understanding
- Which of the following is a valid type of integrity constraint?
A.Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint
Business-critical integrity constraint is valid integrity constraint.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
A.Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of the above
This is an example of relational integrity constraints.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- All of the following are business-critical integrity constraints, except:
A.System will not allow an entry for an order for a nonexistent customer
B. System will not allow returns of fresh produce after 15 days past delivery
C. System will not allow shipping a product to a customer who does not have a valid address
D. Systems will not allow shipping of a nonexistent product to a customer
Business-critical integrity constraint will not allow a return of fresh produce after 15 days. A and C represent relational integrity constraints.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Medium
Taxonomy: Knowledge & Understanding
- Which of the following uses a DBMS to interact with a database?
A.Users of accounting programs
B. Users of human resource programs
C. Users of marketing programs
D. All of the above
Interacting directly and indirectly with a database through a DBMS figure displays these three types of database interactions.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
A.Customer-driven website
B. Data-driven website
C. Customer-driven database
D. Data-driven database
This is the definition of data-driven website.
AACSB: Use of Information Technology
Learning Outcome: 7.4
Level: Hard
Taxonomy: Knowledge & Understanding
- What type of website is best to build for a general informational website with static information?
A.Data-driven website
B. Static website
C. Relational website
D. All of the above
For a general informational website with static information, it is best to build a “static” website, one that a developer can update on an as-needed basis, perhaps a few times a year.
AACSB: Use of Information Technology
Learning Outcome: 7.4
Level: Medium
Taxonomy: Knowledge & Understanding
- What type of website is best to build for a website with continually changing information including press releases, new product information, and updated pricing?
A.Data-driven website
B. Static website
C. Relational website
D. All of the above
For a website with continually changing information, press releases, new product information, updated pricing it is best to build a data-driven website.
AACSB: Use of Information Technology
Learning Outcome: 7.4
Level: Medium
Taxonomy: Knowledge & Understanding
- Which of the following is not an advantage of building a data-driven website?
A.Minimizes human error
B. Cuts production and update costs
C. Improves or maximizes stability
D. Minimizes or reduces efficiency
A data-driven website adds more efficiency; it does not minimize or decrease efficiency.
AACSB: Use of Information Technology
Learning Outcome: 7.4
Level: Hard
Taxonomy: Knowledge & Understanding
- What is a forward integration?
A.Takes information entered into a given system and sends it to the application generation component
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes
D. Takes information entered into a given system and sends it to the DBMS
This is the definition of forward integration.
AACSB: Use of Information Technology
Learning Outcome: 7.5
Level: Easy
Taxonomy: Knowledge & Understanding
- What is a backward integration?
A.Takes information entered into a given system and sends it to the application generation component
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes
D. Takes information entered into a given system and sends it to the DBMS
This is the definition of backward integration.
AACSB: Use of Information Technology
Learning Outcome: 7.5
Level: Easy
Taxonomy: Knowledge & Understanding
- What is an integration?
A.Allows separate systems to communicate directly with each other
B. Takes information entered into a given system and sends it to the database
C. Takes information entered into a given system and sends it to other processes
D. Takes information entered into a given system and sends it to the DBMS
This is the definition of integration.
AACSB: Use of Information Technology
Learning Outcome: 7.5
Level: Easy
Taxonomy: Knowledge & Understanding
True / False Questions
- A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.
FALSE
A primary key is a field (or group of fields) that uniquely identifies a given entity in a table.
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- One of the advantages found in a relational database is increased information redundancy.
FALSE
Relational databases reduce information redundancy, not increase information redundancy.
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
TRUE
This is the definition of relational integrity constraints.
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- 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.
TRUE
This is the definition of data-driven website.
AACSB: Use of Information Technology
Learning Outcome: 7.4
Level: Easy
Taxonomy: Knowledge & Understanding
- Ideally, an organization only wants to build forward integrations.
FALSE
Ideally, an organization wants to build both forward and backward integrations.
AACSB: Use of Information Technology
Learning Outcome: 7.5
Level: Medium
Taxonomy: Knowledge & Understanding
Fill in the Blank Questions
- The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.
Relational
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.
Attributes
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- A(n) ___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.
Foreign
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- A _______________ key is a field that uniquely identifies a given entity in a table.
Primary
AACSB: Use of Information Technology
Learning Outcome: 7.1
Level: Easy
Taxonomy: Knowledge & Understanding
- The _________ view of information deals with the physical storage of information on a storage device such as a hard disk.
Physical
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- The ________ view of information focuses on how users logically access information to meet their particular business needs.
Logical
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- ______________ is the duplication of information, or storing the same information in multiple places.
Redundancy
AACSB: Use of Information Technology
Learning Outcome: 7.2
Level: Easy
Taxonomy: Knowledge & Understanding
- ______________ integrity constraints are rules that enforce business rules vital to an organization’s success.
Business-critical
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
- _________ integrity is a measure of the quality of information.
Information
AACSB: Use of Information Technology
Learning Outcome: 7.3
Level: Easy
Taxonomy: Knowledge & Understanding
Essay Questions
- Evaluate the advantages of the relational database model.
Database advantages from a business perspective include increased flexibility, increased scalability and performance, reduced information redundancy, increased information integrity (quality), and increased information security.
AACSB: Reflective Thinking Skills
Learning Outcome: 7.2
Level: Easy
Taxonomy: Application and Analysis
- Compare relational integrity constraints and business-critical integrity constraints.
Relational integrity constraints are rules that enforce basic and fundamental information-based constraints. Business-critical integrity constraints are rules that enforce business rules vital to an organization’s success and often require more insight and knowledge than operational integrity constraints.
AACSB: Reflective Thinking Skills
Learning Outcome: 7.3
Level: Easy
Taxonomy: Application and Analysis
- Describe the role and purpose of a database management system.
A database management system (DBMS) is software through which users and application programs interact with a database. The user sends requests to the DBMS and the DBMS performs the actual manipulation of the information in the database. There are two primary ways that users can interact with a DBMS, directly and indirectly.
AACSB: Reflective Thinking Skills
Learning Outcome: 7.3
Level: Easy
Taxonomy: Application and Analysis
