COSC Exam 4

¡Supera tus tareas y exámenes ahora con Quizwiz!

In the object-oriented database model, this term is the equivalent to a field in a relational model.

Attribute

This lists the assets, liabilities, and the equity of an organization.

Balance sheet

Access to these databases is offered to the public or selected outside individuals, for a fee.

Commercial databases

This system is a flexible tool for data analysis, since its reports do not have a fixed format.

DSS

This subsystem defines the logical structure of the database by using a data dictionary or schema.

Data definition

Information collected by an organization from a variety of external and internal databases is stored in this special type of database.

Data warehouse

Some of these systems have the ability to retrieve information from databases outside the company, such as business-news services.

ESS

Which system presents information in a highly summarized form?

ESS

An example of this type of report would be a sales report that shows that certain items are selling significantly above or below forecasts.

Exception

A purchase order form pertains to the payroll department.

False

A record is a collection of related tables.

False

An MIS differs from a TPS in that it creates databases.

False

In case of an unanticipated union strike, the manager in charge of manufacturing might consult the management information system to determine how it will affect production schedules.

False

The executive support system can analyze the effects of events and trends outside the organization.

False

The management information system records day-to-day transactions, such as customer orders, bills, inventory levels, and production output.

False

The marketing department identifies, investigates, and develops new products and services.

False

The research department strictly involves itself only with the creation of finished goods that are tangible.

False

There are three basic decision models used in GDSS: operational, strategic, and financial.

False

What documentation shows the income, expenses, and difference between them for a company during a specific time period?

Income statements

This typically consists of transactions from the transaction processing system.

Internal data

This commercial database offers news and information on legal, public records, and business issues.

LexisNexis

Pricing, promoting, selling, and distributing the organization's goods and services pertains to which of the following functions?

Marketing

This level of management is involved with tactical planning and implementing the long-term goals within an organization.

Middle management

Which view of data deals with how the data is actually formatted and located?

Physical view

A field that uniquely identifies each record.

Primary key

Creating finished goods and services using raw materials and personnel pertains to which of the following functions?

Production

A collection of related fields such as a person's name, address, and age.

Record

This type of database is organized into many tables with common data items (key fields) linking the tables to one another.

Relational

Which of the following is not an advantage of using a database?

Reliability

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as a specialized programming language called _______.

SQL

This level of management is concerned with long-range planning and uses information that will help them plan the future growth and direction of the organization.

Top management

A commercial database is generally an enormous database that an organization develops to cover particular subjects.

True

Accounts payable refers to money the company owes its suppliers for materials and services it has received.

True

Data redundancy can occur due to lack of data integrity.

True

Database tables can be related or connected to other tables by common key fields.

True

Demand reports do not have to be produced on a regular basis.

True

In order to create, modify, and gain access to a database, special software, called the database management system, is required.

True

Middle-level managers are responsible for tactical planning and the implementation of long-term goals.

True

Supervisors' responsibilities include operational matters.

True

The ATM works on the principle of real-time processing.

True

The database in which data elements are organized using classes, objects, attributes, and methods is called the object-oriented database.

True

The executive support system helps top-level managers oversee the company's operations and develop strategic plans.

True

The logical arrangement of data in a database is called the database model.

True

The logical view of data focuses on meanings and content of the data.

True

The research department identifies, investigates, and develops new products and services.

True

Top-level managers need information both from within the organization and from outside.

True

Typically, one of the duties of a database administrator is to interact with the data administration subsystem.

True

Money collected from or owed by customers is called _______.

accounts receivable

In _______, data from transactions are collected over time and then processed all at once.

batch processing

A transaction processing system is also referred to as a _______.

data processing system

If all the data in a database is not physically located in one place, it would be a(n) _______ database.

distributed

If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a lack of data _______.

integrity

The _______ keeps records of the number of each kind of part or finished good in the warehouse.

inventory control system

Who uses management information systems?

middle level managers

Regional managers can compare their regular sales reports with that of the other regional managers by using _______.

periodic reports

In _______, data is processed at the same time the transaction occurs.

realtime processing

The _______ activity records the customer requests for products or services.

sales order processing


Conjuntos de estudio relacionados

Chapter 14: Physical Development in Adolescence

View Set

The New Deal: Relief, Recovery, and Reform

View Set

NU 322 Exam 2 (Acid Base Balance Ticket to Test)

View Set