Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
SQL is considered difficult to learn; its command set has a vocabulary of more than 300
words.
A recursive relationship is one in which a relationship can exist between occurrences of
the same entity set
A relationship ____________________ indicates the number of entities or participants
associated with a relationship.
Creating a data warehouse is a simple exercise that takes little time, money, or effort.
A(n) ____________________ routine pools multiple transactions into a single batch to
update a master table field in a single operation.
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
The ERM forms the basis of a(n) ___________________________________.
The terms data model and database model are often used interchangeably.
The ____________________ outer join returns not only the rows matching the join
condition (that is, rows with matching values in the common column), but also the rows
in the left-side table with unmatched values in the right-side table.
____________________ are objects that manage the connection with a data source and
provide data to the consumers.
To avoid nulls, some designers use special codes, known as ____________________,
to indicate the absence of some value.
If you use a surrogate key, you must ensure that the candidate key of the entity in
question performs properly through the use of the "____________________" and "not
null" constraints.
A(n) ____________________ rule is a brief and precise narrative of a policy,
procedure, or principle within a specific organization's environment.
A person's social security number would be an example of a(n)
____________________ attribute.
Only a single attribute, not multiple attributes, can define functional dependence.
