COSC Exam 4
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