1-83 of 83
Click a definition to match it with a term
Which is a true statement about the REA data model?
a. The REA data model classifies entities into three distinct categories.
b. The term REA is an acronym that stands for resources, entities, and agents.
c. Using an REA data model is not helpful when creating an R-E diagram.
Give this one a try later!
a. The REA data model classifies entities into three distinct categories.
,The logical view of a database system refers to
a. how a user or programmer conceptually organizes and understands the data.
b. how the DBMS accesses data for a certain application program.
c. how master files store data values used by more than one application program.
Give this one a try later!
a. how a user or programmer conceptually organizes and understands the
data.
The problem of losing desired information from a database when an unwanted record
is purged from the database is referred to as the ________ anomaly.
a. purge
b. erase
c. delete
Give this one a try later!
c. delete
Which is not a level of schema?
a. Internal-level schema.
b. Entry-level schema
c. External-level schema
Give this one a try later!
, b. Entry-level Schema
The ________ contains information about the structure of the database.
a. data definition language
b. data dictionary
c. data warehouse
Give this one a try later!
b. data dictionary
What is the minimum number of external agents that must participate in each REA
event?
a. 0
b. 2
c. 1
d. 3
Give this one a try later!
a. 0
Identify the item below that would be classified as a resource by the REA data model.
a. an IOU from a customer
b. The customer
, c. A customer sale
d. A loan from a vendor
Give this one a try later!
a. an IOU from a customer
The REA data model approach facilitates efficient operations by all the following
except
a. standardizing source document format.
b. identifying non-value added activities.
c. storing financial and non financial data in the same database.
d. organizing data to simplify data retrieval and analysis.
Give this one a try later!
a. standardizing source document format.
The information about the choice of cardinalities is obtained during the _________ stage
of the database design process.
a. physical design
b. implementation and conversion
c. systems analysis and conceptual design
d. operation and maintenance
Give this one a try later!
c. systems analysis and conceptual design