Exam 10: View Integration and Implementation Compromises

Name two information needs that require data from multiple business processes.

List two physical level implementation compromises.

When does attribute conflict exist?

A database table to which the event history rollup compromise has been applied has more rows than the same table had before the compromise.

View integration may be used in the normal course of database design for a single enterprise; alternatively it may be used to consolidate separate databases as a result of a corporate merger, acquisition, or other form of business consolidation.

Number the following procedures for designing and using database consecutively in the order in which they should normally begin. _____ Logical modeling _____ Conceptual modeling implementation compromises _____ View integration _____ Physical implementation _____ Physical level implementation compromises _____ Conceptual modeling _____ Logical level implementation compromises _____ Daily processing of transaction data entry into database

Using the following tables extracted from Carlisle Company's database, calculate the cost of goods sold for the time period covered in these tables, assuming Carlisle uses weighted average unit costing and assuming that all information in the database is up to date.

The conceptual models for each business process view should be converted to logical level models before they are integrated into a common view.

Why does entity name conflict sometimes occur?

Entity name conflict occurs when the same entity in different conceptual models is not labeled identically.

Because most resources flow between business processes, most queries to calculate balances on hand of resources require data from tables in multiple business processes.

A compromised implementation in which conceptually congruent events have been consolidated contains more tables than an uncompromised implementation for the same enterprise.

Two members of a database design team at Large U.S. University assigned different primary keys to the Student entities in their models. One member used Student ID, an internally generated unique number the university assigns to each student upon enrollment. The other chose social security number or other equivalent identifier assigned to each student by the U.S. government. This is an example of

Some information needs require data from multiple business processes.

What cardinality pattern does a relationship between conceptually congruent events have?

Data about the Cash Receipts activity is needed to calculate which of the following GAAP financial reporting numbers?

Two entities exist in separate views as follows: If these entities represent the same underlying phenomenon, which of the following must be resolved to integrate the views?

Two entities exist in separate views as follows Which attributes are assigned to the merged Customer entity after performing a set union of the attributes on the two separate Customer entities?

Why might an enterprise choose to roll up event activity?

Resolution of entity name conflicts is usually part of