Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
The data warehouse development life cycle differs from classical systems development.
In an SQL-based relational database, rows in different tables are related based on
common values in common attributes.
Cardinality expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity.
To reveal meaning, information requires ____________________.
We are now said to be entering the "knowledge age."
Data type selection is usually dictated by the nature of the data and by the intended use.
The entity relationship model is limited to conceptual modeling, with no
implementation component.
When using an optimistic approach, during the write phase, the transaction is validated
to ensure that the changes made will not affect the integrity and consistency of the
database.
If a(n) ____________________ is issued before the termination of a transaction, the
DBMS will restore the database only for that particular transaction, rather than for all
transactions, in order to maintain the durability of the previous transactions.
Describe a dependency diagram and explain its purpose.
To test a trigger, you should use the EXECUTE TRIGGER command.
Performance evaluation is rendered more difficult by the fact that there are standard
measurements for database performance.
The ____________________ statement in SQL combines rows from two queries and
returns only the rows that appear in the first set but not in the second.
Explain multivalued attributes, and provide an example. How are multivalued attributes
indicated in the Chen model? How are they indicated in the Crow's Foot model?
____________________ functions allow you to take a value of a given data type and
convert it to the equivalent value in another data type.
What is the system catalog?
The DBA or security officer must secure an insurance policy to provide financial
protection in the event of a database failure.
In _________________________, a three-pronged symbol represents the "many" side
of the relationship.
____________________ focuses on maintaining the data free of inconsistencies and
anomalies.
