Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A(n) ______________________________ is an arrangement of computerized tools
used to assist managerial decision making within a business.
When you can change the internal model without affecting the conceptual model, you
have ____________________ independence.
The ____________________, also known as the information resource manager (IRM),
usually reports directly to top management and is given a higher degree of
responsibility and authority than the DBA, although the two roles overlap some.
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain.
A(n) ____________________ is a carefully designed and constructed repository of
facts that is a part of a larger whole known as an information system.
The existence of a mandatory relationship indicates that the minimum cardinality is 0 or
1 for the mandatory entity.
The introduction of a DBMS represents a big change and challenge, and is likely to
have a profound impact throughout the organization.
Once an SQL statement is transformed, the DBMS creates what is commonly known as
a(n) ____________________ plan.
To list the contents of a table, you must use the DISPLAY command.
In MS Access, you can use the ____________________ data type to define a column in
your table that will be automatically populated with unique numeric values.
If you have not yet used the COMMIT command to store the changes permanently in
the database, you can restore the database to its previous condition with the
ROLLBACK command.
All SQL commands must be issued on a single line.
The one-to-many (1:M) relationship is easily implemented in the relational model by
putting the foreign key of the "1" side in the table of the "many" side as a primary key.
Database designers determine the data and information that yield the required
understanding of the entire business.
____________________ is the result of processing raw data to reveal its meaning.
In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level
supertype inherits all of the attributes and relationships from all of its upper-level
subtypes.
The DBA must periodically generate a(n) ____________________ report to determine
whether there have been actual or attempted security violationsand, if so, from what
locations, and if possible, by whom.
The allocation of storage resources is determined when the DBMS is created.
