AIS (Ch. 3) Flashcards
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:
Customer name
Within a database context, the relationship between “assigned parking space” and “car” would most likely be:
one-to-one
The letters “E-R” in the term E-R diagram refers to:
Entity relationship
The best choice for the primary key in an “Employees” table would be his or her:
Employee number
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)?
Foreign key
The _________ helps developers document a database:
Data dictionary
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?
Salesperson number
The purpose of the E-R model is to help database designers:
Design databases and depict data relationships
In the REA framework, a database designer should create a ____ for each entity.
Table
Controls that require a database to either execute a transaction completely, or not at all, are examples of:
Data integrity controls
Controls that do not allow users to update the same database record at the same time are examples of:
Concurrency controls
The foreign key in one database table will always be a _______ key in a linked table.
Secondary key
All of the following are items within the data hierarchy except:
Database
The reason why database designers normalize data is:
To eliminate data errors
Within a database context, the relationship between “students” and “classes” would most likely be:
many-to-many
Which of the following is not an objective of a computerized database?
Reduce the decision‑making functions of subsystem managers
The terms “parent record,” “child record,” and “sibling record” describe the records in a:
Hierarchical database
In the REA framework, which of these would be recorded as an “event?”
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)
Which of these would be an example of an “agent” in the REA framework?
all of these are possibilities(Salesperson, Manager, Customer)
The data item which uniquely identifies a computer record in an AIS database table is called the:
Primary key
In the context of databases, the term data redundancy refers to:
Storing the same information in several records
In the REA accounting framework, the letter “R” stands for:
Resources
The basic unit of information on a computer file of accounting data is a(n):
Data field
REA model steps:
Identify business & economic events Identify entities Identify relationships among entities Create entity relationship diagrams Identify the attributes of data entities Create database tables & records
ER diagram:
Rectangles, Connecting lines, and cardinalities notations
