CLR 110 PART 4: MAPPING
CHRONICLES RELATIONSHIPS IN
CLARITY WITH CORRECT SOLUTIONS
________________ was designed to easily store and retrieve large amounts of
information about one entity at a time. - ANSWER-Chronicles
Due to the structural difference between these databases, some data model
manipulation happens as data moves from _______________ - ANSWER-Chronicles to
Clarity.
As tempting as it may be to suggest that one Chronicles master file would translate to
one Clarity table, that would be impossible due to two main principles for constructing
tables in the Clarity database: - ANSWER-1. Minimize redundant data
2. Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a single
record? - ANSWER-Add type and response type
______________ minimizes data redundancy while maintaining granularity by mapping
a single Chronicles master file to multiple Clarity tables. - ANSWER-Clarity
Clarity minimizes data redundancy while maintaining granularity by mapping a single
Chronicles master file to multiple Clarity tables. The key pieces of information needed to
understand this mapping are a Chronicles item's __________ and ____________, and
a Clarity table's ____________ - ANSWER-add type; response type; primary key.
The two Chronicles item characteristics that are particularly important for Clarity queries
are _______ and __________ - ANSWER-Add Type; Response Type.
stored on the record. Always considered "current". - ANSWER-No-Add:
stored on the contact. - ANSWER-Overtime
Indicates if data is stored on a record or on a contact in the record. - ANSWER-Add type
Indicates how many lines of data an item can hold - ANSWER-Response type
holds only one line of data - ANSWER-single
holds multiple lines of data - ANSWER-multiple
CHRONICLES RELATIONSHIPS IN
CLARITY WITH CORRECT SOLUTIONS
________________ was designed to easily store and retrieve large amounts of
information about one entity at a time. - ANSWER-Chronicles
Due to the structural difference between these databases, some data model
manipulation happens as data moves from _______________ - ANSWER-Chronicles to
Clarity.
As tempting as it may be to suggest that one Chronicles master file would translate to
one Clarity table, that would be impossible due to two main principles for constructing
tables in the Clarity database: - ANSWER-1. Minimize redundant data
2. Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a single
record? - ANSWER-Add type and response type
______________ minimizes data redundancy while maintaining granularity by mapping
a single Chronicles master file to multiple Clarity tables. - ANSWER-Clarity
Clarity minimizes data redundancy while maintaining granularity by mapping a single
Chronicles master file to multiple Clarity tables. The key pieces of information needed to
understand this mapping are a Chronicles item's __________ and ____________, and
a Clarity table's ____________ - ANSWER-add type; response type; primary key.
The two Chronicles item characteristics that are particularly important for Clarity queries
are _______ and __________ - ANSWER-Add Type; Response Type.
stored on the record. Always considered "current". - ANSWER-No-Add:
stored on the contact. - ANSWER-Overtime
Indicates if data is stored on a record or on a contact in the record. - ANSWER-Add type
Indicates how many lines of data an item can hold - ANSWER-Response type
holds only one line of data - ANSWER-single
holds multiple lines of data - ANSWER-multiple
