AIS (Ch. 3)

Question 1

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons. All of these would be likely data fields in a customer order table except:

Answer 1

Customer name

Question 2

Within a database context, the relationship between “assigned parking space” and “car” would most likely be:

Answer 2

one-to-one

Question 3

The letters “E-R” in the term E-R diagram refers to:

Answer 3

Entity relationship

Question 4

The best choice for the primary key in an “Employees” table would be his or her:

Answer 4

Employee number

Question 5

Which of the following creates one-to-many relationships by linking the data in one file (e.g., customer) to an item in a second file (e.g., a sales order)?

Answer 5

Foreign key

Question 6

The _________ helps developers document a database:

Answer 6

Data dictionary

Question 7

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons. Which of these items would probably be a foreign key in the customer orders table?

Answer 7

Salesperson number

Question 8

The purpose of the E-R model is to help database designers:

Answer 8

Design databases and depict data relationships

Question 9

In the REA framework, a database designer should create a ____ for each entity.

Answer 9

Table

Question 10

Controls that require a database to either execute a transaction completely, or not at all, are examples of:

Answer 10

Data integrity controls

Question 11

Controls that do not allow users to update the same database record at the same time are examples of:

Answer 11

Concurrency controls

Question 12

The foreign key in one database table will always be a _______ key in a linked table.

Answer 12

Secondary key

Question 13

All of the following are items within the data hierarchy except:

Answer 13

Database

Question 14

The reason why database designers normalize data is:

Answer 14

To eliminate data errors

Question 15

Within a database context, the relationship between “students” and “classes” would most likely be:

Answer 15

many-to-many

Question 16

Which of the following is not an objective of a computerized database?

Answer 16

Reduce the decision‑making functions of subsystem managers

Question 17

The terms “parent record,” “child record,” and “sibling record” describe the records in a:

Answer 17

Hierarchical database

Question 18

In the REA framework, which of these would be recorded as an “event?”

Answer 18

all of these would be recorded as events(Hiring a new president of the company, Taking an initial sales order from a customer, Buying a piece of equipment for cash)

Question 19

Which of these would be an example of an “agent” in the REA framework?

Answer 19

all of these are possibilities(Salesperson, Manager, Customer)

Question 20

The data item which uniquely identifies a computer record in an AIS database table is called the:

Answer 20

Primary key

Question 21

In the context of databases, the term data redundancy refers to:

Answer 21

Storing the same information in several records

Question 22

In the REA accounting framework, the letter “R” stands for:

Answer 22

Resources

Question 23

The basic unit of information on a computer file of accounting data is a(n):

Answer 23

Data field

Question 24

REA model steps:

Answer 24

Identify business & economic events
Identify entities
Identify relationships among entities
Create entity relationship diagrams
Identify the attributes of data entities
Create database tables & records

Question 25

ER diagram:

Answer 25

Rectangles, Connecting lines, and cardinalities notations