Test Bank Docx | Ch6 – Valuing And Storing Organizational

Business Driven Technology, 8e (Baltzan)

Chapter 6 Valuing and Storing Organizational Information—Databases

1) Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract).

2) Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

3) Information has three characteristics: levels, formats, and granularities.

4) The four primary traits that help determine the value of information are type, timeliness, quality, and governance.

5) Information has three characteristics: timeliness, quality, and governance.

6) The four primary traits of the value of information are levels, formats, granularities, and type.

7) There are only two main primary traits that help you determine the value of information: timeliness and quality.

8) If a manager identifies numerous information integrity issues, he should consider the reports generated from that data as invalid and not use them when making decisions.

9) Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

10) Information granularity means immediate, up-to-date information.

11) Real-time systems provide real-time information in response to requests.

12) Information integrity issues occur when the same data element has different values.

13) Information integrity issues occur when a system produces incorrect, inconsistent, or duplicate data.

14) Data governance refers to the overall management of the availability, usability, integrity, and security of company data.

15) 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.

16) Timeliness information must be up-to-the-second to be accurate.

17) Information comes at the same level, formats, and granularities.

18) Reports for each sales person, product, and part are examples of information granularities.

19) Master data management (MDM) is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems. MDM is commonly included in data governance.

20) Data governance is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

21) Accurate information asks if there is an incorrect value in the information.

22) Complete information asks if there is a value missing from the information.

23) Consistent information asks if the aggregate or summary information is in agreement with detailed information.

24) Timely information asks if the information is current with respect to the business needs.

25) Unique information asks if each transaction and event is represented only once in the information.

26) Complete information asks if there is an incorrect value in the information.

27) Consistent information asks if there is a value missing from the information.

28) Accurate information asks if the aggregate or summary information is in agreement with detailed information.

29) Unique information asks if the information is current with respect to the business needs.

30) Timely information asks if each transaction and event is represented only once in the information.

31) Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

32) Determining if all total columns equal the true total of the individual items is an example of a consistent characteristic of high-quality information.

33) A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

34) Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

35) Data latency includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

36) Data validation includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

37) In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

38) Identity management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

39) A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

40) Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

41) Determining if information is updated weekly, daily, or hourly is an example of an accurate characteristic of high-quality information.

42) A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

43) The core components of any system, regardless of size, are a database and a database management system.

44) MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

45) A foreign key provides details about data.

46) There are three primary data models for organizing information including the hierarchical, network, and relational database models.

47) Data element (or data field) is the smallest, or basic, unit of information.

48) Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

49) Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

50) Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

51) Data dictionary compiles all of the metadata about the data elements in the data model.

52) Relational database model stores information in the form of logically related two-dimensional tables.

53) Relational database management system allows users to create, read, update, and delete data in a relational database.

54) Attributes (also called columns or fields) are the data elements associated with an entity.

55) Record is a collection of related data elements.

56) Primary key is a field (or group of fields) that uniquely identifies a given record in a table.

57) Foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

58) A primary key is the smallest or basic unit of information.

59) Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

60) Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

61) A DBMS provides details about data.

62) Structured query language compiles all of the metadata about the data elements in the data model.

63) Hierarchal database model stores information in the form of logically related two-dimensional tables.

64) Entities are the data elements associated with an attribute.

65) A field is a collection of related data elements.

66) A foreign key uniquely identifies a given record in a table.

67) A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

68) Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

69) Information redundancy is the duplication of data, or the storage of the same data in multiple places.

70) Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

71) The physical view of information deals with the physical storage of information on a storage device.

72) The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

73) The logical view of information deals with the physical storage of information on a storage device.

74) The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

75) A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

76) A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

77) Information redundancy is the duplication of data, or the storage of the same data in multiple places.

78) Information integrity is a measure of the quality of information.

79) Integrity constraints are rules that help ensure the quality of information.

80) Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

81) Information constraints are measures of the quality of information.

82) Information integrity comprises rules that help ensure the quality of information.

83) Relationship integrity criteria are rules that enforce basic and fundamental information-based constraints.

84) Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

85) Data latency is the time it takes for data to be stored or retrieved.

86) Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

87) Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

88) One of the advantages found in a relational database is increased information redundancy.

89) A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

90) Data-driven websites offer several advantages as it is far easier to manage content and store large amounts of data.

91) A content creator is the person responsible for creating the original website content.

92) A content creator is the person responsible for updating and maintaining website content.

93) A content editor is the person responsible for updating and maintaining website content.

94) Static information includes fixed data incapable of change in the event of a user action.

95) Static information includes data that change based on user actions.

96) Dynamic information includes data that change based on user actions.

97) Dynamic website information is stored in a dynamic catalog, or an area of a website that stores information about products in a database.

98) A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

99) Integrations allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.

100) Middleware translates information between disparate systems.

101) Enterprise application integration (EAI) middleware takes a new approach to middleware by packaging commonly used applications together, reducing the time needed to integrate applications from multiple vendors.

102) Eintegration is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

103) Data integration is the integration of a company's existing management information systems.

104) Application integration is the integration of data from multiple sources, which provides a unified view of all data.

105) Application integration is the integration of a company's existing management information systems.

106) Data integration is the integration of data from multiple sources, which provides a unified view of all data.

107) A forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

108) A backward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

109) A backward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

110) A forward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

111) Integrations are achieved using middleware—several types of software that sit between and provide connectivity for two or more software applications. Middleware translates information between disparate systems.

112) Enterprise application integration (EAI) middleware takes a new approach to middleware by packaging commonly used applications together, reducing the time needed to integrate applications from multiple vendors.

113) Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization?

A) Levels, forms, granularities

B) Levels, forms, data

C) Levels, formats, granularities

D) Data, formats, granularities

114) Which of the following represents the different information levels?

A) Detail, summary, aggregate

B) Document, presentation, spreadsheet, database

C) Individual, department, enterprise

D) Executives, managers, operational employees

115) Which of the following represents the different information formats?

A) Detail, summary, aggregate

B) Document, presentation, spreadsheet, database

C) Individual, department, enterprise

D) Executives, managers, operational employees

116) Which of the following represents the different information granularities?

A) Detail, summary, aggregate

B) Document, presentation, spreadsheet, database

C) Individual, department, enterprise

D) Executives, managers, operational employees

117) Which of the following is not a primary trait of information?

A) Governance

B) Type

C) Timeliness

D) Quantity

118) 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

119) 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

120) What is immediate, up-to-date information?

A) Real-time information

B) Real-time systems

C) Information granularity

D) Information governance

121) What provides real-time information in response to query requests?

A) Information systems

B) Real-time systems

C) Information level

D) Information quality

122) 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.

123) Which of the following is not one of the five characteristics common to high-quality information?

A) Accuracy

B) Completeness

C) Quantity

D) Consistency

124) What is the function of 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 with the primary purpose of supporting the performance of managerial analysis tasks.

D) Encompasses all of the information contained within a single business process or unit of work with the primary purpose of supporting the performance of daily operational tasks.

125) Which of the following implies that aggregate or summary information is in agreement with detailed information?

A) Uniqueness

B) Completeness

C) Consistency

D) Accuracy

126) Which of the following implies that information is current with respect to the business requirement?

A) Uniqueness

B) Accuracy

C) Consistency

D) Timeliness

127) 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

128) Which of the following refers to the extent of detail within the information?

A) Knowledge information

B) Information granularity

C) Chance information

D) Information analytics

129) Which of the following represent the four primary traits that help determine the value of information?

A) Information type, information timeliness, information quality, and information governance

B) Information statistics, information tracking, information quality, and information governance

C) Information type, information chance, information analytics, and information policy

D) Information timeliness, information quality, information quantity, and information governance policy

130) What are the two different categories for information type?

A) Analytical and productive

B) Analytical and analysis

C) Transactional and analytical

D) Transactional and analysis

131) Which of the following encompasses all of the information contained within a single business process or unit of work with the primary purpose of supporting daily operational tasks?

A) Targeted information

B) Analytical information

C) Productive information

D) Transactional information

132) Which of the following encompasses all organizational information with the primary purpose of supporting the performance of managerial analysis tasks?

A) Analytical information

B) Transactional information

C) Statistical information

D) Targeted information

133) Justin works at a top accounting firm in Los Angeles and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Justin's duties provide value-added to his company and would be categorized as occurring at the different ________.

A) Information lists

B) Information formats

C) Information granularities

D) Information focus

134) Justin works at a top accounting firm in Los Angeles, and his responsibilities include developing individual and departmental goals and generating financial analysis across departments and the enterprise as a whole for the executive team to review. Justin's duties provide value-added to his company and would be categorized as occurring at the different  ________.

A) Information levels

B) Information formulas

C) Information granularities

D) Information focus

135) Justin works at a top accounting firm in Los Angeles and his responsibilities include developing reports for each salesperson, product, and part as well as department wide sales reports by salesperson, product, and part. Justin's duties provide value to his company and would be categorized as occurring at the different ________.

A) Information levels

B) Information formats

C) Information granularities

D) Information focus

136) Which of the following refers to immediate, up-to-date information?

A) Daily information

B) Strategic information

C) Real-time information

D) Crisis information

137) Which of the below does not represent a company that requires up-to-the-second information?

A) 911 response

B) Stock traders

C) Banks

D) Construction companies

138) Which of the following provides real-time information in response to requests?

A) Sales system

B) Transactional system

C) Real-time system

D) Salary system

139) Which of the following are examples of transactional information?

A) Airline ticket, sales receipts, and packing slips

B) Trends and sales statistics

C) Product sales results, grocery receipts, and growth projections

D) Airline tickets and sales growth spreadsheets

140) Which of the following are examples of analytical information?

A) Airline ticket, sales receipts, and packing slips

B) Hotel reservation, sales receipts, and packing slips

C) Future growth, sales projections, and product statistics

D) Packing slips, grocery receipt, and competitor information

141) Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

A) Improvements

B) Change

C) Clustering

D) Cleansing

142) Which of the following occurs when the same data element has different values?

A) Data modeling issue

B) Data mining issue

C) Data governance issue

D) Information inconsistency issue

143) Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

A) Information inconsistency issue

B) Information integrity issue

C) Data control issue

D) Data mining issue

144) Which of the following lists include all of the five characteristics common to high-quality information?

A) Accuracy, completeness, strength, support, and positive feedback

B) Accuracy, association, referral, sales, and marketing

C) Accuracy, competition, support, customer service, and visibility

D) Accuracy, completeness, consistency, timeliness, and uniqueness

145) Which of the following would not be considered part of the complete characteristic of high-quality information?

A) Is a value missing from the personal information?

B) Is each transaction represented only once in the information?

C) Is the address incomplete?

D) Is the area code missing for the phone information?

146) Which of the following would not be considered part of the timely characteristic of high-quality information?

A) Is the zip code missing in the address?

B) Is the information current with respect to business needs?

C) Is the information updated hourly?

D) Is the information updated weekly?

147) Which of the following would not be considered part of the accuracy characteristic of high-quality information?

A) Is the name spelled correctly?

B) Is there an incorrect value in the information?

C) Is the dollar amount recorded properly?

D) Is aggregate information in agreement with detailed information?

148) Which of the following would not be considered part of the unique characteristic of high-quality information?

A) Are there any duplicate orders?

B) Are there any duplicate customers?

C) Is aggregate information in agreement with detailed information?

D) Is each transaction and event represented only once in the information?

149) Which of the following would not be considered part of the consistency characteristic of high-quality information?

A) Do all total columns equal the true total of the individual item?

B) Is the two-digit state code missing in the information?

C) Is all summary information in agreement with detailed information?

D) All of the above are part of the consistency characteristic of high-quality information.

150) Which of the following represents a reason for low-quality information?

A) Online customers intentionally enter inaccurate information to protect their privacy.

B) Different systems have different information entry standards and formats.

C) Third-party and external information contains inaccuracies and errors.

D) All of these.

151) Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except:

A) Inability to accurately track customers

B) Inability to identify selling opportunities

C) The success of the organization depends on appreciating and leveraging the low-quality information

D) Lost revenue opportunities from marketing to nonexistent customers

152) What is the overall management of the availability, usability, integrity, and security of company data?

A) Data intelligence

B) Data governance

C) Data forbearance

D) Data forecasting

153) What occurs when the same data element has different values?

A) Information inconsistency

B) Information integrity issues

C) Data governance

D) Master data management

154) What occurs when a system produces incorrect, inconsistent, or duplicate data?

A) Information inconsistency

B) Information integrity issues

C) Data governance

D) Master data management

155) What refers to the overall management of the availability, usability, integrity, and security of company data?

A) Information inconsistency

B) Information integrity issues

C) Data governance

D) Master data management

156) What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?

A) Information inconsistency

B) Information integrity issues

C) Data governance

D) Master data management

157) What is information inconsistency?

A) Occurs when the same data element has different values

B) Occurs when a system produces incorrect, inconsistent, or duplicate data

C) Refers to the overall management of the availability, usability, integrity, and security of company data

D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems

158) What are information integrity issues?

A) Occurs when the same data element has different values

B) Occurs when a system produces incorrect, inconsistent, or duplicate data

C) Refers to the overall management of the availability, usability, integrity, and security of company data

D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems

159) What is data governance?

A) Occurs when the same data element has different values

B) Occurs when a system produces incorrect, inconsistent, or duplicate data

C) Refers to the overall management of the availability, usability, integrity, and security of company data

D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems

160) What is master data management?

A) Occurs when the same data element has different values.

B) Occurs when a system produces incorrect, inconsistent, or duplicate data.

C) Refers to the overall management of the availability, usability, integrity, and security of company data.

D) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

161) What is a data steward responsible for?

A) Acting as a liaison between the MIS department and the business

B) Ensuring policies and procedures are implemented across the organization

C) Acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization

D) None of these

162) What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

A) Data steward

B) Data stewardship

C) Data gap analysis

D) Data governance

163) What is the term for the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data?

A) Data steward

B) Data stewardship

C) Data validation

D) Data gap analysis

164) What is the term for when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

A) Data steward

B) Data stewardship

C) Data validation

D) Data gap analysis

165) What is the term for the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

A) Data governance

B) Master data management

C) Data validation

D) Data gap analysis

166) What is the term for the time it takes for data to be stored or retrieved?

A) Data governance

B) Data latency

C) Data validation

D) Data gap analysis

167) What is data latency?

A) The time it takes for data to be stored or retrieved

B) The management and oversight of an organization's data assets

C) The person responsible for ensuring policies and procedures are implemented across the organization

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

168) What is data stewardship?

A) The time it takes for data to be stored or retrieved

B) The management and oversight of an organization's data assets

C) The person responsible for ensuring policies and procedures are implemented across the organization

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

169) What is a data steward?

A) The time it takes for data to be stored or retrieved

B) The management and oversight of an organization's data assets

C) The person responsible for ensuring policies and procedures are implemented across the organization

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

170) What is data validation?

A) The time it takes for data to be stored or retrieved

B) The management and oversight of an organization's data assets

C) The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

171) What is data gap analysis?

A) The time it takes for data to be stored or retrieved

B) The management and oversight of an organization's data assets

C) The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

172) What is master data management?

A) The time it takes for data to be stored or retrieved

B) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete

C) The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data

D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps

173) What maintains information about various types of objects, events, people, and places?

A) Database

B) Data model

C) Data mining

D) Data intelligence

174) A database maintains information on ________.

A) Inventory

B) Transactions

C) Employees

D) All of these

175) In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

A) Entity

B) Relationships

C) Attribute

D) Foreign Key

176) Why do relational databases use primary keys and foreign keys?

A) To create an entity.

B) To create physical relationships.

C) To create logical relationships.

D) To create an attribute.

177) What is a primary key?

A) A field (or group of fields) that uniquely identifies a given record 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

178) 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

179) Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

A) Database element

B) Database management system

C) Data governance

D) Data file

180) Which of the following asks users to write lines of code to answer questions against a database?

A) Structured query language

B) Relational query language

C) Structured elements

D) Data mining tools

181) What is the primary tool that retrieves information and helps users graphically design the answer to a question?

A) Data mining tools

B) Structured example language

C) Query-by-example tool

D) Relational query tool

182) What is the smallest or basic unit of information?

A) Database management element

B) Data element

C) Data model

D) Data integrity issue

183) What is a logical data structure that details the relationship among data elements using graphics or pictures?

A) Data model

B) Data element

C) Data mining tool

D) Data mart tool

184) What compiles all of the metadata about the data elements in the data model?

A) Data entity

B) Data element

C) Data attribute

D) Data dictionary

185) Which of the following systems allow users to create, read, update, and delete data in a relational database?

A) Business intelligence system

B) Informational database system

C) Relational database management system

D) Data mining system

186) Which of the following illustrates the primary concepts of the relational database model?

A) Ethics, applications, keys, and relationships

B) Entities, attributes, keys, and relationships

C) Endeavor, aspire, control, and regulate

D) Early, after, before, and future

187) Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a record?

A) Entity

B) Extraction

C) Attribute

D) Foreign key

188) What is the primary difference between an entity and an attribute?

A) An attribute is a table, whereas an entity is a column from the attribute table.

B) An entity is specific, whereas an attribute is not data at all but brainstorming of ideas that takes place before the entity is created.

C) An attribute refers to applications, and an entity refers to executives.

D) An entity is part of a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity.

189) What type of keys do you need to use to create a relational database model?

A) Primary keys and secondary keys

B) Primary keys and foreign keys

C) Entity keys and attribute keys

D) Relational keys and DBMS keys

190) What is a field that uniquely identifies a given record in a table?

A) Foreign key

B) Primary key

C) Data mining key

D) DBMS key

191) What is the role of a foreign key?

A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

B) It is a unique way to identify each record.

C) It is a field that uniquely identifies a given record in a table.

D) All of these.

192) Your textbook discussed an example where one user could perform a query to determine which recordings had a track length of four minutes or more, and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories. This is an advantage of which database example?

A) Increased scalability and performance

B) Increased information security

C) Reduced information redundancy

D) Increased flexibility

193) Which of the following is not an advantage of database-stored information?

A) Increased flexibility

B) Increased performance

C) Increased information redundancy

D) Increased information integrity

194) Which of the following is incorrect in reference to a database?

A) A database can be relational.

B) Database information is accessed by logical structure.

C) Database information is accessed by physical structure.

D) Database users can have different views of information.

195) What is the logical 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

196) 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

197) Which of the below is not an example of an advantage of using a relational database?

A) Increased information quality

B) Increased flexibility

C) Decreased information redundancy

D) Decreased information security

198) What is information redundancy?

A) Duplication of data

B) Storing the same data in multiple places

C) Storing duplicate data in multiple places

D) All of the choices are correct.

199) What is the primary problem with redundant information?

A) It is difficult to determine which values are the most current

B) It causes confusion

C) It is difficult to determine which values are the most accurate

D) All of these

200) 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 these

201) 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

202) What are rules that enforce basic and fundamental information-based constraints?

A) Information integrity

B) Integrity constraint

C) Business-critical integrity constraint

D) Relational integrity constraint

203) 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

204) 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) Mission-critical integrity constraint

205) Which of the following is a business-critical integrity constraint?

A) System will not allow an entry of 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

206) What is identity management?

A) Enforces business rules vital to an organization's success

B) The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete

C) A broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system

D) A company's examination of its data to determine if the company can meet business expectations and to identify possible data gaps

207) What is the term for a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

A) Identity management

B) Master data management

C) Data validation

D) Data latency

208) Which of the following focuses on how individual users logically access information to meet their own particular business needs?

A) Physical view

B) Logical view

C) Data mart view

D) Data view

209) The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of?

A) Increased scalability and performance

B) Increased information security

C) Reduced information redundancy

D) Increased flexibility

210) One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

A) Reduces disk space requirements

B) Makes updating information easier

C) Improves information quality

D) All of these

211) What are rules that help ensure the quality of information?

A) Information integrity

B) Integrity constraints

C) Information quality

D) Information ethics

212) What are the rules that enforce basic and fundamental information-based constraints?

A) Responsibly integrity constraints

B) Quality constraints

C) Web integrity constraints

D) Relational integrity constraints

213) Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

A) Quality business constraints

B) Critical web constraints

C) Business critical integrity constraints

D) Web integrity constraints

214) What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

A) Data-driven website

B) Interactive website

C) Database performing website

D) Data processing website

215) Which of the following offers an advantage of using a data-driven website?

A) Easy to eliminate human errors

B) Easy to manage content

C) Easy to store large amounts of data

D) All of these

216) Which of the following statements means the same as easy to manage content?

A) Website owners can make changes only with the aid of MIS professionals.

B) The website cannot organize customer data.

C) Users can update data-driven website with little or no training.

D) Users with extensive training can update data-driven websites.

217) Which of the following is not an example of an advantage to using the web to access organizational databases?

A) Web browsers are much easier to use than a computer based database.

B) The web interface requires few or no changes to the database model.

C) It is cleaner and virus-free.

D) It costs less.

218) Which of the following does not describe Zappos database?

A) Zappos database was high scalable.

B) Zappos database was highly flexible.

C) Zappos database was highly secure.

D) Zappos database was highly redundant.

219) Which of the following is not an advantage to a data-driven website?

A) Easy to manage content

B) Minimizing human error

C) Increasing web interface costs

D) Easy to store large amounts of data

220) Who is the person responsible for creating the original website content?

A) Content creator

B) Content editor

C) Static information

D) Dynamic information

221) Who is the person responsible for updating and maintaining website content?

A) Content creator

B) Content editor

C) Static information

D) Dynamic information

222) What includes fixed data incapable of change in the event of a user action?

A) Content creator

B) Content editor

C) Static information

D) Dynamic information

223) What includes data that change based on user actions?

A) Content creator

B) Content editor

C) Static information

D) Dynamic information

224) What is stored in a dynamic catalog, or an area of a website that stores information about products in a database?

A) Dynamic website

B) Data-driven website

C) Static information

D) Dynamic information

225) What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

A) Dynamic website

B) Data-driven website

C) Static information

D) Dynamic information

226) What is a content creator?

A) The person responsible for creating the original website content.

B) The person responsible for updating and maintaining website content.

C) Includes fixed data incapable of change in the event of a user action.

D) Includes data that change based on user action.

227) What is a content editor?

A) The person responsible for creating the original website content

B) The person responsible for updating and maintaining website content

C) Includes fixed data incapable of change in the event of a user action

D) Includes data that change based on user action

228) What is static information?

A) The person responsible for creating the original website content

B) The person responsible for updating and maintaining website content

C) Includes fixed data incapable of change in the event of a user action

D) Includes data that change based on user action

229) What is dynamic information?

A) The person responsible for creating the original website content

B) The person responsible for updating and maintaining website content

C) Includes fixed data incapable of change in the event of a user action

D) Includes data that change based on user action

230) What is a dynamic website?

A) The person responsible for creating the original website content

B) Includes data that change based on user action

C) Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database

D) An interactive website kept constantly updated and relevant to the needs of its customers using a database

231) What is a data-driven website?

A) The person responsible for creating the original website content

B) Includes data that change based on user action

C) Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database

D) An interactive website kept constantly updated and relevant to the needs of its customers using a database

232) What allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems?

A) Integration

B) Intelligence

C) Data interchange

D) Demand plan

233) What takes information entered into a given system and sends it automatically to all downstream systems and processes?

A) Forward integration

B) Forward data interchange

C) Backward integration

D) Backward data interchange

234) What takes information entered into a given system and sends it automatically to all upstream systems and processes?

A) Forward integration

B) Forward data interchange

C) Backward integration

D) Backward data interchange

235) What provides enterprisewide support and data access for a firm's operations and business processes?

A) Enterprise systems

B) Enterprise application integration

C) Middleware

D) Enterprise application integration middleware

236) What connects the plans, methods, and tools aimed at integrating separate enterprise systems?

A) Enterprise systems

B) Enterprise application integration

C) Middleware

D) Enterprise application integration middleware

237) What are several different types of software that sit between and provide connectivity for two or more software applications?

A) Enterprise systems

B) Enterprise application integration

C) Middleware

D) Enterprise application integration middleware

238) What takes a new approach to middleware by packaging commonly used applications together, reducing the time needed to integrate applications from multiple vendors?

A) Enterprise systems

B) Enterprise application integration

C) Middleware

D) Enterprise application integration middleware

239) What is an application integration?

A) The integration of a company's existing management information systems.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Sends information entered into a given system automatically to all downstream systems and processes.

D) Sends information entered into a given system automatically to all upstream systems and processes.

240) What is a data integration?

A) The integration of a company's existing management information systems.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Sends information entered into a given system automatically to all downstream systems and processes.

D) Sends information entered into a given system automatically to all upstream systems and processes.

241) What is forward integration?

A) The integration of a company's existing management information systems

B) The integration of data from multiple sources, which provides a unified view of all data

C) Sending information entered into a given system automatically to all downstream systems and processes

D) Sending information entered into a given system automatically to all upstream systems and processes

242) What is a backward integration?

A) The integration of a company's existing management information systems

B) The integration of data from multiple sources, which provides a unified view of all data

C) Sending information entered into a given system automatically to all downstream systems and processes

D) Sending information entered into a given system automatically to all upstream systems and processes

243) What are enterprise systems?

A) The integration of a company's existing management information systems.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Sends information entered into a given system automatically to all downstream systems and processes.

D) Enterprisewide support and data access for a firm's operations and business processes.

244) What is enterprise application integration (EAI)?

A) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Sends information entered into a given system automatically to all downstream systems and processes.

D) Enterprisewide support and data access for a firm's operations and business processes.

245) How are integrations achieved?

A) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

B) Integrations are achieved using middleware—several types of software that sit between and provide connectivity for two or more software applications.

C) Sends information entered into a given system automatically to all downstream systems and processes.

D) Enterprisewide support and data access for a firm's operations and business processes.

246) What is middleware?

A) The use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Translates information between disparate systems.

D) Packages commonly used applications together, reducing the time needed to integrate applications from multiple vendors.

247) What is enterprise application integration (EAI) middleware?

A) The use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Translates information between disparate systems.

D) Packages commonly used applications together, reducing the time needed to integrate applications from multiple vendors.

248) What is eintegration?

A) The use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

B) The integration of data from multiple sources, which provides a unified view of all data.

C) Translates information between disparate systems.

D) Packages commonly used applications together, reducing the time needed to integrate applications from multiple vendors.

249) Which of the following is not an example of a primary enterprise system?

A) Supply chain management

B) Customer relationship management

C) Enterprise revenue planning

D) Enterprise resource planning

250) What is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources?

A) Eintegration

B) Application integration

C) Data integration

D) Forward integration

251) What is the integration of a company's existing management information systems?

A) Backward integration

B) Application integration

C) Data integration

D) Forward integration

252) What is the integration of data from multiple sources, which provides a unified view of all data?

A) Backward integration

B) Application integration

C) Data integration

D) Forward integration

253) What takes information entered into a given system and sends it automatically to all downstream systems and processes?

A) Backward integration

B) Application integration

C) Data integration

D) Forward integration

254) What takes information entered into a given system and sends it automatically to all upstream systems and processes?

A) Backward integration

B) Application integration

C) Data integration

D) Forward integration

255) What is data integration?

A) The integration of data from multiple sources, which provides a unified view of all data.

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) The integration of a company's existing management information systems.

256) What is a forward integration?

A) The integration of data from multiple sources, which provides a unified view of all data

B) Taking information entered into a given system and sending it automatically to all downstream systems and processes

C) Taking information entered into a given system and sending it automatically to all upstream systems and processes

D) The integration of a company's existing management information systems

257) What is a backward integration?

A) The integration of data from multiple sources, which provides a unified view of all data

B) Taking information entered into a given system and sending it automatically to all downstream systems and processes

C) Taking information entered into a given system and sending it automatically to all upstream systems and processes

D) The integration of a company's existing management information systems

258) What is application integration?

A) The integration of data from multiple sources, which provides a unified view of all data.

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) The integration of a company's existing management information systems.

259) What is supply chain management (SCM)?

A) The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability.

B) Takes information entered into a given system and sends it automatically to all downstream systems and processes.

C) A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability.

D) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

260) What is enterprise resource planning (ERP)?

A) The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability.

B) Integrates all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so employees can make decisions by viewing enterprisewide information about all business operations.

C) A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability.

D) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

261) What is customer relationship management (CRM)?

A) The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability.

B) Integrates all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so employees can make decisions by viewing enterprisewide information about all business operations.

C) A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability.

D) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

262) What is enterprise application integration (EAI)?

A) The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability.

B) Integrates all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so employees can make decisions by viewing enterprisewide information about all business operations.

C) A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability.

D) Connects the plans, methods, and tools aimed at integrating separate enterprise system.

263) Explain the four primary traits that determine the value of information.

264) Describe a database, a database management system, and the relational database model.

265) Identify the business advantages of a relational database.

266) Explain the business benefits of a data-driven website.

267) Explain integrations and the role they play in connecting a corporation.