Management Information Systems
queations with correct answers
"federated" data sources - CORRECT ANSWERS-dynamically combine information
from constituent systems
- that is, a federated system presents a single interface, but draws on data stored in
multiple underlying systems
. For example, two divisions of a merged company might
use different and incompatible accounting systems, but with a federated system
providing
combined reports and queries.
"normalize" database design - CORRECT ANSWERS-you break up tables or create
new tables so that all the
dependencies within each table have determinants that
are primary or candidate keys.
An
Inter
organizational System
(IOS) - CORRECT ANSWERS-is a system that connects two organizations - for
example, it may allow a company to automatically share inventory and backlog da
ta with
suppliers or customers
Analytical processing - CORRECT ANSWERS-means combining data from many or all
table rows in order to obtain "higher-level" information. An example of analytical
processing would be computing the
number of customer orders and total dollar value of orders for the current month and
comparing them to similar figures for the previous month.
, Anomalies occur because of the
two kinds of database design mistakes - CORRECT ANSWERS-1.)data redundancy
and 2.)create a database that includes
functional dependencies whose determinants are not
candidate keys, including partial dependencies and transitive dependencies. For
example, in the table ACTIVITY (Member ID, Activity,Fee), Activity by itself is not a
candidate key but it determines Fee, so there is a partial dependency and therefore the
potential for anomalies
Application
and
application program
(nowadays sometimes simply "app") - CORRECT ANSWERS-are somewhat ill-
defined
terms, but typically denote computer software and databases supporting a particular
task
or group of tasks.
atomic - CORRECT ANSWERS-A datum is called ________ if it holds a single piece of
information such as a single name or amount of money
candidate
key - CORRECT ANSWERS-each option when there is more than 1 possible key
columns - CORRECT ANSWERS-attributes or fields
computed field/calculated field - CORRECT ANSWERS-computed from the other fields
in the same record when you display the form, but
is not
stored in the database itself.
Concatenation key/ composite key - CORRECT ANSWERS-means appending two or
more pieces of
information to one another
Data Management Issues - CORRECT ANSWERS-Massive and Increasing Amounts of
Data
Data Dispersal
data accuracy and quality
data security
data marts - CORRECT ANSWERS-similar to data warehouses but smaller in scale
data mining - CORRECT ANSWERS-refers to using statistical or
other mathematical
techniques to discover data patterns that might not be apparent in standard reports.
queations with correct answers
"federated" data sources - CORRECT ANSWERS-dynamically combine information
from constituent systems
- that is, a federated system presents a single interface, but draws on data stored in
multiple underlying systems
. For example, two divisions of a merged company might
use different and incompatible accounting systems, but with a federated system
providing
combined reports and queries.
"normalize" database design - CORRECT ANSWERS-you break up tables or create
new tables so that all the
dependencies within each table have determinants that
are primary or candidate keys.
An
Inter
organizational System
(IOS) - CORRECT ANSWERS-is a system that connects two organizations - for
example, it may allow a company to automatically share inventory and backlog da
ta with
suppliers or customers
Analytical processing - CORRECT ANSWERS-means combining data from many or all
table rows in order to obtain "higher-level" information. An example of analytical
processing would be computing the
number of customer orders and total dollar value of orders for the current month and
comparing them to similar figures for the previous month.
, Anomalies occur because of the
two kinds of database design mistakes - CORRECT ANSWERS-1.)data redundancy
and 2.)create a database that includes
functional dependencies whose determinants are not
candidate keys, including partial dependencies and transitive dependencies. For
example, in the table ACTIVITY (Member ID, Activity,Fee), Activity by itself is not a
candidate key but it determines Fee, so there is a partial dependency and therefore the
potential for anomalies
Application
and
application program
(nowadays sometimes simply "app") - CORRECT ANSWERS-are somewhat ill-
defined
terms, but typically denote computer software and databases supporting a particular
task
or group of tasks.
atomic - CORRECT ANSWERS-A datum is called ________ if it holds a single piece of
information such as a single name or amount of money
candidate
key - CORRECT ANSWERS-each option when there is more than 1 possible key
columns - CORRECT ANSWERS-attributes or fields
computed field/calculated field - CORRECT ANSWERS-computed from the other fields
in the same record when you display the form, but
is not
stored in the database itself.
Concatenation key/ composite key - CORRECT ANSWERS-means appending two or
more pieces of
information to one another
Data Management Issues - CORRECT ANSWERS-Massive and Increasing Amounts of
Data
Data Dispersal
data accuracy and quality
data security
data marts - CORRECT ANSWERS-similar to data warehouses but smaller in scale
data mining - CORRECT ANSWERS-refers to using statistical or
other mathematical
techniques to discover data patterns that might not be apparent in standard reports.
