Database Management and Business Intelligence: A Review

35) A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with: A) one short mark. B) two short marks. C) three short marks. D) a crow's foot. E) a crow's foot topped by a short mark. Answer: E Difficulty: Challenging AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 36) You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table? A) Address B) City C) Airport code D) State E) Day Answer: C Difficulty: Moderate AACSB: Analytical thinking LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 37) A one-to-one relationship between two entities is symbolized in a diagram by a line that ends: A) in two short marks. B) in one short mark. C) with a crow's foot. D) with a crow's foot topped by a short mark. E) with a crow's foot topped by two short marks. Answer: A Difficulty: Challenging AACSB: Application of knowledge LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 11 38) The logical and physical views of data are separated in a DBMS. Answer: TRUE Difficulty: Moderate AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 39) Every record in a file should contain at least one key field. Answer: TRUE Difficulty: Easy AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 40) NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations. Answer: TRUE Difficulty: Easy AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 41) CGI is a DBMS programming language that end users and programmers use to manipulate data in the database. Answer: FALSE Difficulty: Easy AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 42) Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships. Answer: TRUE Difficulty: Easy AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 43) A physical view shows data as it is actually organized and structured on the data storage media. Answer: TRUE Difficulty: Easy AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 12 44) DBMS have a data definition capability to specify the structure of the content of the database. Answer: TRUE Difficulty: Moderate AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 45) Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. Answer: FALSE Difficulty: Challenging AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 46) The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database? Answer: Student answers will vary, but should include some assessment of data quality, business processes and user needs, and relationship to existing IT systems. Key points to include are: Data accuracy when the new data is input, establishing a good data model, determining which data is important and anticipating what the possible uses for the data will be, beyond looking up contract information, technical difficulties linking this system to existing systems, new business processes for data input and handling, and contracts management, determining how end users will use the data, making data definitions consistent with other databases, what methods to use to cleanse the data. Difficulty: Moderate AACSB: Analytical thinking LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 13 47) List and describe three main capabilities or tools of a DBMS. Answer: A DBMS includes capabilities and tools for organizing, managing, and accessing the data in the database. Its most important capabilities and tools are data definition, data dictionary, and data manipulation language. The data definition capability enables a user to be able to specify the structure of the content of the database. This capability is used to create database tables and to define the characteristics of the fields in each table. The data dictionary is used to store definitions of data elements and their characteristics in the database. In large corporate databases, the data dictionary may capture additional information, such as usage; ownership; authorization; security; and the individuals, business functions, programs, and reports that use each data element. A data manipulation language, such as SQL, that is used to add, change, delete, and retrieve the data in the database. This language contains commands that permit end users and programming specialists to extract data from the database to satisfy information requests and develop applications. Difficulty: Moderate AACSB: Analytical thinking LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 48) Identify and describe three basic operations used to extract useful sets of data from a relational database. Answer: The select operation creates a subset consisting of all records (rows) in the table that meets stated criteria. The join operation combines relational tables to provide the user with more information than is available in individual tables. The project operation creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required. Difficulty: Moderate AACSB: Information technology LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is a relational DBMS so powerful? 49) The term big data refers to all of the following except: A) datasets with fewer than a billion records. B) datasets with unstructured data. C) machine-generated data (i.e. from sensors). D) data created by social media (i.e. tweets, Facebook Likes). E) data from Web traffic. Answer: A Difficulty: Challenging AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 14 50) Which of the following technologies would you use to analyze the social media data collected by a major online retailer? A) OLAP B) Data warehouse C) Data mart D) Hadoop E) DBMS Answer: D Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 51) Which of the following is not one of the techniques used in web mining? A) Content mining B) Structure mining C) Server mining D) Usage mining E) Data mining Answer: C Difficulty: Moderate AACSB: Reflective thinking LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 52) You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use the data mining software you are using to do which of the following? A) Identify associations B) Identify clusters C) Identify sequences D) Classify data E) Create a forecast Answer: C Difficulty: Challenging AACSB: Analytical thinking LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 15 53) You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use the data mining software you are using to do which of the following? A) Identify associations B) Identify clusters C) Identify sequences D) Classify data E) Create a forecast Answer: D Difficulty: Challenging AACSB: Analytical thinking LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 54) A data warehouse is composed of: A) historical data from legacy systems. B) current data. C) internal and external data sources. D) historic and current internal data. E) historic external data. Answer: D Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 55) All of the following are technologies used to analyze and manage big data except: A) cloud computing. B) noSQL. C) in-memory computing. D) analytic platforms. E) Hadoop. Answer: A Difficulty: Challenging AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 16 56) A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? A) Text mining tools B) Sentiment analysis software C) Web mining technologies D) Data mining software E) Data governance software Answer: B Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 57) Which of the following tools enables users to view the same data in different ways using multiple dimensions? A) Predictive analysis B) SQL C) OLAP D) Data mining E) Hadoop Answer: C Difficulty: Challenging AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 58) OLAP enables: A) users to obtain online answers to ad-hoc questions in a rapid amount of time. B) users to view both logical and physical views of data. C) programmers to quickly diagram data relationships. D) programmers to normalize data. E) users to quickly generate summary reports. Answer: A Difficulty: Easy AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 17 59) Data mining allows users to: A) quickly compare transaction data gathered over many years. B) find hidden relationships in data. C) obtain online answers to ad-hoc questions in a rapid amount of time. D) summarize massive amounts of data into much smaller, traditional reports. E) access the vast amounts of data in a data warehouse. Answer: B Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 60) In the context of data relationships, the term associations refers to: A) events linked over time. B) patterns that describe a group to which an item belongs. C) occurrences linked to a single event. D) undiscovered groupings. E) relationships between different customers. Answer: C Difficulty: Challenging AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 61) ________ tools are used to analyze large unstructured data sets, such as e-mail, memos, and survey responses to discover patterns and relationships. A) OLAP B) Text mining C) In-memory D) Clustering E) Classification Answer: B Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 18 62) Which of the following enables you to create a script that allows a web server to communicate with a back-end database? A) CGI B) HTML C) Java D) SQL E) NoSQL Answer: A Difficulty: Easy AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 63) Which of the following is software that handles all application operations between browserbased computers and a company's back-end business applications or databases? A) Database server software B) Application server software C) Web browser software D) Data mining software E) Web server software Answer: B Difficulty: Easy AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 64) In data mining, which of the following involves using a series of existing values to determine what other future values will be? A) Associations B) Sequences C) Classifications D) Clustering E) Forecasting Answer: E Difficulty: Moderate AACSB: Information technology LO: 6-3: What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? 19