AIN2601 - GLOSSARY
(AIS) - question and answerAn AIS collects an organisation's day-to-day financial and
nonfinancial transactions, processes them into valuable financial information and stores
and retrieves the data and financial information
AIS AUDIT TRAIL - question and answerAn AIS audit trail tracks user activity on the
AIS by recording the user name and access date and time as well as the actions
performed by that user
APPLICATION PROGRAMMERS - question and answerApplication programmers are
responsible for creating, maintaining, updating and managing the application and DBMS
software which the end-users use to interact with the physical database
ATTRIBUTE - question and answerAn attribute, commonly known as a column,
represents one unique characteristic of a single database table.
BATCH INPUT - question and answerBatch input involves similar source documents
being grouped together (batch) and then entered in the CIS periodically, say, daily,
weekly or monthly.
BATCH OUTPUT - question and answerBatch output occurs when all requests for
information (i.e. reports, queries, etc.) are batched together and periodically extracted
from the CIS.
BATCH PROCESSING - question and answerBatch processing occurs when
transaction files (containing the captured data) are updated to the master files
periodically, that is, daily, weekly or monthly.
BILL OF MATERIALS (BOM) - question and answerThe bill of materials (BOM)
specifies, for each finished goods inventory item, the type and quantities of raw
materials needed in the manufacturing.
BUSINESS INTELLIGENCE SOFTWARE (BIS) - question and answerBusiness
intelligence software (BIS) is special software that combines information obtained from
a data warehouse (cube structure), from all functional areas in the organisation and
external sources to a lesser extent to generate reports required by top management.
, BIS DASHBOARD - question and answerBIS can provide a "dashboard", which gives
access to all the required reports. The dashboard can be located on the computer's
desktop to give management access to the information with the click of a button.
CENTRALISED DATABASE - question and answerWhen using a centralised database,
the database is physically stored in one central location (i.e. it is on one server).
CHART OF ACCOUNTS (COA) - question and answerA CoA is a list of accounts used
in the organisation's general ledger.
CLASSIFYING DATA - question and answerData is arranged into different groups
(categories) using some of the data's specific characteristics
COMPUTER-AIDED MANUFACTURING (CAM) - question and answerCAM controls
and coordinates all the machines used in the manufacturing process such as conveyor
systems, cutting or welding machines and so forth
COMPUTER-INTEGRATED MANUFACTURING (CIM) - question and answerCIM is the
automation and integration of the complete manufacturing process by using computers
to control and/ or execute the process from product design right through manufacturing,
to quality control, storage of raw materials, WIP and finished goods, and ultimately, the
shipment of the finished products.
CONCEPTUAL LEVEL - question and answerThe conceptual level is a complete view
of the entire database, that is, a view of all the data from which the user views can be
derived.
DATA ADMINISTRATOR - question and answerThe data administrator, also called a
database analyst, is responsible for managing and controlling the data in the
organisation's databases.
DATA CONTROL LANGUAGE (DCL) - question and answerDCL controls the security
and user access to the database objects and data in the database.
DATA DEFINITION LANGUAGE (DDL) - question and answerDDL is used to define a
database and includes commands to (1) create, modify and delete the database and
database objects, (2) define and describe the data structure of the database according
to the database model used, and (3) create the data dictionary.
DATA DICTIONARY - question and answerThe data dictionary contains a record for
each data field in the database and this record gives a detailed description of that data
field.
DATA FIELD - question and answerA data field contains a single data value and is the
smallest unit of data that can be accessed in a database.
(AIS) - question and answerAn AIS collects an organisation's day-to-day financial and
nonfinancial transactions, processes them into valuable financial information and stores
and retrieves the data and financial information
AIS AUDIT TRAIL - question and answerAn AIS audit trail tracks user activity on the
AIS by recording the user name and access date and time as well as the actions
performed by that user
APPLICATION PROGRAMMERS - question and answerApplication programmers are
responsible for creating, maintaining, updating and managing the application and DBMS
software which the end-users use to interact with the physical database
ATTRIBUTE - question and answerAn attribute, commonly known as a column,
represents one unique characteristic of a single database table.
BATCH INPUT - question and answerBatch input involves similar source documents
being grouped together (batch) and then entered in the CIS periodically, say, daily,
weekly or monthly.
BATCH OUTPUT - question and answerBatch output occurs when all requests for
information (i.e. reports, queries, etc.) are batched together and periodically extracted
from the CIS.
BATCH PROCESSING - question and answerBatch processing occurs when
transaction files (containing the captured data) are updated to the master files
periodically, that is, daily, weekly or monthly.
BILL OF MATERIALS (BOM) - question and answerThe bill of materials (BOM)
specifies, for each finished goods inventory item, the type and quantities of raw
materials needed in the manufacturing.
BUSINESS INTELLIGENCE SOFTWARE (BIS) - question and answerBusiness
intelligence software (BIS) is special software that combines information obtained from
a data warehouse (cube structure), from all functional areas in the organisation and
external sources to a lesser extent to generate reports required by top management.
, BIS DASHBOARD - question and answerBIS can provide a "dashboard", which gives
access to all the required reports. The dashboard can be located on the computer's
desktop to give management access to the information with the click of a button.
CENTRALISED DATABASE - question and answerWhen using a centralised database,
the database is physically stored in one central location (i.e. it is on one server).
CHART OF ACCOUNTS (COA) - question and answerA CoA is a list of accounts used
in the organisation's general ledger.
CLASSIFYING DATA - question and answerData is arranged into different groups
(categories) using some of the data's specific characteristics
COMPUTER-AIDED MANUFACTURING (CAM) - question and answerCAM controls
and coordinates all the machines used in the manufacturing process such as conveyor
systems, cutting or welding machines and so forth
COMPUTER-INTEGRATED MANUFACTURING (CIM) - question and answerCIM is the
automation and integration of the complete manufacturing process by using computers
to control and/ or execute the process from product design right through manufacturing,
to quality control, storage of raw materials, WIP and finished goods, and ultimately, the
shipment of the finished products.
CONCEPTUAL LEVEL - question and answerThe conceptual level is a complete view
of the entire database, that is, a view of all the data from which the user views can be
derived.
DATA ADMINISTRATOR - question and answerThe data administrator, also called a
database analyst, is responsible for managing and controlling the data in the
organisation's databases.
DATA CONTROL LANGUAGE (DCL) - question and answerDCL controls the security
and user access to the database objects and data in the database.
DATA DEFINITION LANGUAGE (DDL) - question and answerDDL is used to define a
database and includes commands to (1) create, modify and delete the database and
database objects, (2) define and describe the data structure of the database according
to the database model used, and (3) create the data dictionary.
DATA DICTIONARY - question and answerThe data dictionary contains a record for
each data field in the database and this record gives a detailed description of that data
field.
DATA FIELD - question and answerA data field contains a single data value and is the
smallest unit of data that can be accessed in a database.
