AIS Ch 4

multiple master files which may contain redundant data

fiel oriented approaches create prblems for organizations because of

Which of the following elements of an REA data model does not necessarily generate a relational table?

one to many relationships

since they do not have to focus on the physical location and layouts of various data items

seperating the logical and physical views in a database allows the programmers to concentrate on coding the application logic

Primary key attributes

-Must be unique -Must be universal -Must be used to identify the entities or relationships to which they are assigned -Can be chosen arbitrarily

Which of the following is an information process event?

-Updating accounts receivable for a sale made to a customer -Changing a customer address in the customer database table -Printing a list of past due sales for the credit manager -Entering sales return data into the enterprise database

database management system (DBMS)

the ____ acts as an interface between the database and the various application programs

database system

the combination of the database, the DBMS, and the application programs that access the database through the DBMS is refferred to as the

database administrator

the person responsible for the database is the

how and where the data are physically arranged and stored

the term physical view refers to:

What is cardinality?

An indication of how many occurrences of one entity in a relationship can be linked to a single occurrence of the other entity in the relationship

Any attribute that may be decomposed into other attributes is called a

Complex Attribute

Multi-attribute primary keys are called:

Concatenated keys

In REA business process level modeling, resources are connected to economic events using

Dualty Relationships

An individual's address is an example of a:

Field.

Where is information about business events best obtained?

From interviews with management

The recommended Step 1 in REA business process level modeling is

Identify the economic exchange events that form the core of the business process.

Redundancy is minimised with a computer based database approach.

True

Which of the following is NOT an essential information process event?

-Communicate to the purchasing department a need to replenish a resource -Record information about an operating event -Report useful information to a decision maker -Maintain reference data about an agent or resource

An Entity-Relationship diagram is a graphical representation of a database schema?

True

Which of the following statements accurately describes the difference between an operating event and a business pro

A business process consists of several operating events

What is a 'tuple'?

A row or record in a database table.

Business policies are specified in the:

Cardinalities

Data warehouses may be subdivided into ________ that hold subsets of data from the warehouse that focus on specific aspects of a company:

Data Marts

What does the abbreviation DBMS stand for?

Database Management System.

A system which integrates the use and storage of data in an information system is called a:

Database management system.

Which of the following is an example of an operating event?

Delivering a product to a customer

These databases may be copies of operational or analytical databases that reside on corporate intranets or extranets:

Distributed Databases

A row in a database can also be called a domain.

False

The minimum and maximum cardinalities in agent-event relationship is almost always one for the minimum and many for the maximum.

False

Calculating amounts, sending documents to outside parties such as customers, and generating analysis reports are all examples of

Information process events

The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?

It uses a pseudo-English style of questioning. It is good at handling geographical concepts. It is widely used. It uses a pseudo-English style of questioning.

Which of the following pairs of entities would typically be associated with each other in a stockflow relationship in a REA model?

Purchase and Inventory

True statements about data warehouses include each of the following except: A) Data has been cleaned, transformed, and catalogued to enable better analysis. B) Store data that has been extracted from both internal and external sources. C) Relatively inexpensive to setup and maintain. D) Data can be converted to new data elements, and aggregated into new data subsets.

Relatively inexpensive to setup and maintain.

The data manipulation tool that helps you graphically design the answer to a question is a:

Report Generator

The typical relationship between Sales Order and Inventory would be:

Sales order (1,m)-(0,m) inventory

Data resource management is the managerial activity that:

Seeks to manage an organization's data resources using the techniques of "database management and administration" and "data administration and planning".

Most databases are accessed using a ________ language:

Structured Query

SQL is an acronym for:

Structured Query Language

Which of the following are characteristics of an RDBMS?

Tables are linked by common data known as keys. Queries are possible on individual or groups of tables. Data are organized in a series of two-dimensional tables each of which contains records for one entity.

Databases that store detailed data generated by the operations of the entire organization are called:

Transaction Databases

A first step in database creation should be needs analysis.

True

Agents are people or organizations about whom information is desired.

True

a database

a set of interrelated, centrally coordinated files is called

DBMS

a software program that creates, minipulates, accesses the database goes by the acronym

decentralized management of data

all the following are benefits of database technology except:

many separate files

using a file oriented approach to data and information, data is maintained in

relational

what is the most popular type of database?

the preliferation of master files creates problems in the consistancy of specific data stored in different files

which statement is true reguarding file systems?