In an entity-relationship diagram, a line connecting two entities that ends in a crow's foot topped by a short mark designates what kind of relationship?

Correct answer: A one-to-many relationship

Explanation

This question tests the student's ability to interpret the symbols used in an entity-relationship diagram, a standard tool for database design.

Other questions

Question 1

In the data hierarchy, what is the term for a grouping of characters into a word, a group of words, or a complete number?

Question 2

Which of the following problems in a traditional file environment is characterized by the presence of duplicate data in multiple data files?

Question 3

What is the primary role of a Database Management System (DBMS)?

Question 4

In a relational database, what is the purpose of a primary key?

Question 5

Which of the three basic operations of a relational DBMS is used to combine relational tables to provide the user with more information than is available in individual tables?

Question 6

What is the primary purpose of the process known as normalization in database design?

Question 7

According to the chapter, what is the term for a database that stores current and historical data of potential interest to decision makers throughout the company?

Question 8

What technology is described as an open source software framework that enables distributed parallel processing of huge amounts of data across inexpensive computers?

Question 9

Which of the following analytical techniques is more discovery-driven, finding hidden patterns and relationships in large databases?

Question 10

What is the function of an information policy in an organization?

Question 11

A person, place, thing, or event on which we store and maintain information is known as what?

Question 12

Program-data dependence is the term used to describe the coupling of data stored in files and the specific programs required to update them. What is a major consequence of this dependence?

Question 13

Which of the following is an example of a non-relational database technology?

Question 14

An automated or manual file that stores definitions of data elements and their characteristics is called a:

Question 15

What is the most prominent data manipulation language used in DBMS for large and midrange computers today?

Question 16

The conceptual design of a database is modeled from which perspective?

Question 17

Rules that ensure relationships between coupled tables in a relational database remain consistent are called what?

Question 18

What is the term for datasets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, and analyze?

Question 19

A subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users is called a:

Question 20

What type of data mining analysis would be used to identify that when corn chips are purchased, a cola drink is purchased 65 percent of the time?

Question 21

The discovery and analysis of useful patterns and information from the World Wide Web is referred to as:

Question 22

What is the primary function of data cleansing, also known as data scrubbing?

Question 23

According to a Gartner Inc. report mentioned in the chapter, what percentage of critical data in large Fortune 1000 companies’ databases is inaccurate or incomplete?

Question 24

How does a DBMS separate the logical and physical views of data?

Question 25

What is the primary business advantage of using a data warehouse?

Question 26

Which technology relies on a computer's main memory (RAM) for data storage to dramatically shorten query response times?

Question 27

What type of Web mining examines user interaction data recorded by a Web server whenever requests for a Web site's resources are received?

Question 28

The BAE Systems case study highlighted the challenges of what primary issue before implementing its new data management solution?

Question 30

What is the primary reason that a traditional file system cannot deliver ad hoc reports in a timely fashion?

Question 31

What type of data mining is used to discover different groupings within data, such as finding affinity groups for bank cards?

Question 32

What is the primary technology that allows a user with a Web browser to access an organization's internal database?

Question 33

What is the function of data administration?

Question 34

The case of Famous Footwear's inability to get the 'right style of shoe in the right store' illustrates a failure in what area?

Question 35

What technology did TicketDirect adopt to improve management of peak system loads during major ticket sales?

Question 36

How many terabytes of data does Twitter generate daily, according to the chapter?

Question 37

In the human resources database example (Figure 6.3), what would be the logical view for a benefits specialist?

Question 38

What type of analytical tool enables users to view the same data in different ways using multiple dimensions?

Question 39

Sentiment analysis software is used to mine what type of data?

Question 40

What is the primary concern of the controversy surrounding the Consumer Product Safety Database described in the chapter?

Question 41

A structured survey of the accuracy and level of completeness of the data in an information system is called a:

Question 42

Which of the following best describes the database approach to data management?

Question 43

What key services are part of the Hadoop framework?

Question 44

Which business intelligence infrastructure component is described as featuring preconfigured hardware-software systems specifically designed for query processing and analytics, like IBM Netezza?

Question 45

The case of Caesars Entertainment using customer data to build detailed profiles and guide management decisions is a prime example of applying what technology?

Question 46

What is the primary difference between a logical design and a physical design of a database?

Question 47

How much data can a single jet engine generate in just 30 minutes, according to the chapter's discussion on big data?

Question 48

What is the primary function of a foreign key in a relational database table?

Question 49

Which of the following is a primary problem that a DBMS helps solve?

Question 50

What type of business intelligence infrastructure component did Barnes & Noble use to maintain separate databases for retail store sales, college bookstore sales, and online sales?