Using MIS 9th Edition Kroenke - Test Bank Instant Download - Complete Test Bank With Answers Sample Questions Are Posted Below Using MIS, 9e (Kroenke) Chapter 5 Database Processing 1) A database is used instead of a spreadsheet when ________. A) lists of data involve a single theme B) structures …
$19.99
Using MIS 9th Edition Kroenke – Test Bank
Instant Download – Complete Test Bank With Answers
Sample Questions Are Posted Below
Using MIS, 9e (Kroenke)
Chapter 5 Database Processing
1) A database is used instead of a spreadsheet when ________.
Answer: C
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.1: What is the purpose of a database?
Classification: Concept
2) A spreadsheet can be used to store data if the structure of a list is simple.
Answer: TRUE
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.1: What is the purpose of a database?
Classification: Concept
3) The purpose of a database is to keep track of lists of data that involve a single theme.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.1: What is the purpose of a database?
Classification: Concept
4) What is the purpose of a database?
Answer: The purpose of a database is to keep track of things. Lists of data involving a single theme can be stored in a spreadsheet; while lists that involve data with multiple themes require a database. Thus, the purpose of a database is to keep track of things that involve more than one theme.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.1: What is the purpose of a database?
Classification: Concept
5) Which of the following is the smallest element in a database?
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
6) In a database, ________ are grouped into columns.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
7) The columns in a database are called ________.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
8) The rows in a database are called ________.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
9) A group of similar rows or records is known as ________.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
10) Which of the following data elements is placed higher than records in the database hierarchy?
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
11) A primary key in a database is a ________.
Answer: B
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
12) Albert creates a relational database to store employee performance statistics. He stores each employee’s data in independent rows and creates a column named “Employee Number” to assign unique numbers to each employee. The “Employee Number” column is referred to as a ________.
Answer: A
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Application
13) Columns that are keys to different tables than the ones in which they reside are called ________.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
14) Relational databases represent relationships using ________.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
15) Metadata are ________.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
16) A group of similar rows or records in a table is called a field.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
17) Metadata refers to special data that describes the structure of a database.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
18) Each table in a database must have two or more primary keys.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
19) The format of metadata depends on the software product that processes the database.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
20) Describe a database and its elements.
Answer: A database is a self-describing collection of integrated records. A byte is a character of data. In databases, bytes are grouped into columns, which are also called fields. Columns or fields are grouped into rows, which are also called records. Finally, a group of similar rows or records is called a table or a file. A database is thus a collection of tables, relationships among the rows in those tables, and special data called metadata, that describes the structure of the database.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
21) Define primary key, foreign key, and metadata.
Answer: A primary key is a column or group of columns that identifies a unique row in a table. Columns that are primary keys in a table other than the one in which they reside are called foreign keys. Metadata are data that describe data in the database.
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.2: What is a database?
Classification: Concept
22) A(n) ________ is a program used to create, process, and administer a database.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
23) Which of the following is an example of a database management system?
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
24) Identify an open source DBMS product.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
25) Which of the following is true of MySQL?
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
26) The modification or deletion of data in a database is an example of ________ operations of a database management system.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
27) Which of the following is an international standard language for processing a database?
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
28) Which of the following is a developmental task of database administration?
Answer: A
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
29) Owen, the database administrator for a shipping company, is responsible for checking the data model, which is to be used in the database management system, for accuracy and completeness. This is an example of Owen’s ________ tasks.
Answer: A
AACSB: Reflective Thinking
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Application
30) Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel’s ________ task.
Answer: D
AACSB: Reflective Thinking
Difficulty: 3: Challenging
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Application
31) Which of the following database administration tasks is related to adaptation?
Answer: D
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
32) A DBMS and database are synonymous terms that can be used interchangeably.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
33) To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
34) SQL is an international standard language for processing a database.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
35) One of the functions of a DBMS is to provide tools to assist in the administration of a database.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
36) A user does not need user account credentials to access and process a database.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
37) Managing the impact of database structural changes on applications and users is an operational task for a database administrator.
Answer: FALSE
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
38) Explain how a database management system processes a database.
Answer: A function of the DBMS is to process the database. Such processing can be quite complex, but, fundamentally, the DBMS provides applications for four processing operations: to read, insert, modify, or delete data. These operations are requested in application calls upon the DBMS. From a form, when a user enters new or changed data, a computer program behind the form calls the DBMS to make the necessary database changes. From a Web application, a program on the client or on the server calls the DBMS to make the change.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
39) What is database administration?
Answer: Database administration involves a wide variety of activities. For example, the database management system can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database. To provide database security, a user must sign on using a valid user account before she can process the database. In addition to security, DBMS administrative functions include backing up database data, adding structures to improve the performance of database applications, removing data that are no longer wanted or needed, and similar tasks. For important databases, most organizations dedicate one or more employees to the role of database administration.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.3: What is a database management system (DBMS)?
Classification: Concept
40) A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
41) Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company’s database. Which of the following elements will help Heidi modify her data?
Answer: B
AACSB: Reflective Thinking
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Application
42) A(n) ________ is a request for data from a database.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
43) Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.
Answer: D
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Application
44) Which of the following is true of single-user databases?
Answer: D
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
45) Which of the following is true of traditional database application programs?
Answer: C
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
46) Traditional database application programs are ________.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
47) Browser applications are thin-client applications that ________.
Answer: C
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
48) Which of the following is used to process and display browser database application forms, reports, and queries?
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
49) Browser-based applications ________.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
50) Browser-based applications ________.
Answer: D
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
51) Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles’s report overwrites Irene’s, and her changes are lost. This scenario is an example of the ________.
Answer: A
AACSB: Reflective Thinking
Difficulty: 3: Challenging
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Application
52) Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
53) Most traditional databases use the Internet to transmit traffic back and forth between the users’ computers and the DBMS server.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
54) The lost-update problem can be resolved by implementing single-user database processing.
Answer: FALSE
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
55) Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
56) Browser applications are thin-client applications that need to be preinstalled on the users’ computers.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
57) What is a database application?
Answer: A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data. Database applications reformat database table data to make it more informative and more easily updated. Application programs also have features that provide security, maintain data consistency, and handle special cases.
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
58) State the purposes of the four elements of a database application.
Answer: The specific purposes of the four elements of a database application are as follows:
Forms—View data; insert new, update existing, and delete existing data
Reports—Structured presentation of data using sorting, grouping, filtering, and other operations
Queries—Search based upon data values provided by the user
Application programs—Provide security, data consistency, and special purpose processing, e.g., handle out-of-stock situations
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
59) What are traditional database applications?
Answer: A traditional database is shared among many users. In that case, the application resides on the users’ computers and the database management system and database reside on a server computer. A network, in most cases not the Internet, is used to transmit traffic back and forth between the users’ computers and the DBMS server computer. Traditional database application programs are written in object-oriented languages such as C++ and VisualBasic (and even in earlier languages like COBOL). They are thick applications that need to be installed on users’ computers. In some cases, all of the application logic is contained in a program on users’ computers and the server does nothing except run the DBMS and serve up data.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
60) Explain the functioning of browser applications.
Answer: Browser applications are thin-client applications that need not be preinstalled on the users’ computers. In most cases, all of the code for generating and processing the application elements is shared between the users’ computers and the servers. JavaScript is the standard language for user-side processing. Languages like C# and Java are used for server-side code. The databases in browser-based Internet applications are nearly always shared among many users. The users’ browsers connect over the Internet to a Web server computer, which in turn connects to a database server computer.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
61) What is the disadvantage of multiuser processing?
Answer: Most traditional and browser-based Internet applications involve multiple users processing the same database. While such multiuser processing is common, it does pose unique problems. The lost-update problem exemplifies one of the special characteristics of multiuser database processing. To prevent this problem, some type of locking must be used to coordinate the activities of users who know nothing about one another. Locking brings its own set of problems, however, and those problems must be addressed as well.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.4: How do database applications make databases more useful?
Classification: Concept
62) A ________ describes the data and relationships that will be stored in a database.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
63) Ryan, a database administrator, is in the process of designing his company’s database. Which of the following would Ryan have had to create before he began designing?
Answer: C
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Application
64) A data model is a ________.
Answer: A
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
65) In a data model, a(n) ________ is something that a user wants to track.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
66) Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.
Answer: D
AACSB: Information Technology
Difficulty: 3: Challenging
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Application
67) Entities in a data model have ________ that describe the characteristics of the entity.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
68) Each entity in a database has a unique attribute called a(n) ________.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
69) In an E-R diagram, a line between two entities represents a(n) ________.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
70) The forked lines on the lines representing relationship between two related entities are referred to as ________.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
71) Which of the following is true of N:M relationships?
Answer: D
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
72) Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. This is an example of a(n) ________ relationship.
Answer: C
AACSB: Reflective Thinking
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Application
73) ________ in an E-R diagram refer to the least number of entities required in a relationship.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
74) Constraints on the minimum number of entities in a relationship are called ________ cardinalities.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
75) In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
76) Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
77) A logical representation of database data, called the data model, is constructed by developers after building a database.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
78) An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
79) A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
80) The crow’s-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
81) Describe entities in the context of data models.
Answer: An entity is something that the users want to track. Examples of entities are Order, Customer, Salesperson, and Item. Some entities represent a physical object, such as Item or Salesperson; others represent a logical construct or transaction, such as Order or Contract. Entities have attributes that describe characteristics of the entity. Example attributes of Order are OrderNumber, OrderDate, SubTotal, Tax, Total, and so forth. Entities have an identifier, which is an attribute (or group of attributes) whose value is associated with one, and only one, entity instance. For example, OrderNumber is an identifier of Order, because only one Order instance has a given value of OrderNumber.
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
82) Define the symbols and terms used in entity-relationship (E-R) diagrams.
Answer: Database designers use diagrams called entity-relationship (E-R) diagrams. In these diagrams, all of the entities of one type are represented by a single rectangle. Little lines, which are referred to as crow’s feet, are shorthand for the multiple lines between these entities. 1:N, one-to-many relationships, and N:M, many-to-many relationships, represent the relationship between entities. The crow’s-foot notation shows the maximum number of entities that can be involved in a relationship. They are called the relationship’s maximum cardinality, and constraints on minimum requirements are called minimum cardinalities.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.5: How are data models used for database development?
Classification: Concept
83) ________ is the process of converting a data model into tables, relationships, and data constraints.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
84) ________ is the process of converting a poorly-structured table into two or more well-structured tables.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
85) In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
86) A data integrity problem will occur only if ________.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
87) The process of normalization constructs tables such that every table has a ________.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
88) Identify the first step in transforming a data model into a relational database design.
Answer: D
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
89) When using the relational model to represent two tables, one must ________.
Answer: A
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
90) Which of the following is true about the database development process?
Answer: A
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
91) ________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
92) The data integrity problem occurs only if data are duplicated.
Answer: TRUE
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
93) The accuracy of a database design is not dependent on the corresponding data model.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
94) The easiest time to change the database structure is after the data modeling stage.
Answer: FALSE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
95) How does normalization resolve the data integrity problem?
Answer: Normalization is the process of converting a poorly-structured table into two or more well-structured tables. If an attribute is entered correctly in one row and incorrectly in another, this leads to a problem called a data integrity problem.
The data integrity problem can occur only if data are duplicated. Because of this, one easy way to eliminate the problem is to eliminate the duplication of data. The general goal of normalization is to construct tables such that every table has a single topic or theme. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
96) What are the steps involved in transforming a data model into a relational database design?
Answer: To transform a data model into a relational database design, a database designer creates a table for each entity. The identifier of the entity becomes the key of the table. Each attribute of the entity then becomes a column of the table. Next, the resulting tables are normalized so that each table has a single theme followed by representing relationships among the tables that are normalized. This includes adding foreign keys and additional tables for N:M relationships.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
97) Explain the role of users in the database development process.
Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. Thus, user review of the data model is crucial. When a database is developed, users must carefully review the data model. If they do not understand any aspect of it, they should ask for clarification until they do. Entities must contain all of the data they need to do their jobs, and relationships must accurately reflect their view of the business. If the data model is wrong, the database will be designed incorrectly, and the applications will be difficult to use, if not worthless. Developers should not proceed with the database design unless the data model is accurate.
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.6: How is a data model transformed into a database design?
Classification: Concept
98) For Falcon Security, the primary purpose of creating a database of video information is to ________.
Answer: C
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.7: How can Falcon Security benefit from a database system?
Classification: Concept
99) A significant difference between using Access versus Mongo DB to store Falcon Security’s video information is:
Answer: B
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.7: How can Falcon Security benefit from a database system?
Classification: Concept
100) Which of the following statements correctly describes the relationship between drones and videos in Falcon Security’s database?
Answer: A
AACSB: Application of Knowledge
Difficulty: 3: Challenging
Course LO: Discuss best practices for using and managing databases
LO: 5.7: How can Falcon Security benefit from a database system?
Classification: Application
101) The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.
Answer: B
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.8: 2026?
Classification: Concept
102) Which of the following is true of in-memory DBMS products?
Answer: A
AACSB: Information Technology
Difficulty: 2: Moderate
Course LO: Discuss best practices for using and managing databases
LO: 5.8: 2026?
Classification: Concept
103) NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.
Answer: TRUE
AACSB: Information Technology
Difficulty: 1: Easy
Course LO: Discuss best practices for using and managing databases
LO: 5.8: 2026?
Classification: Concept
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
