Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

CLR 110 Part 4: Mapping Chronicles Relationships in Clarity Questions And Correct Answers, Exams of Advanced Education

________________ was designed to easily store and retrieve large amounts of information about one entity at a time. • CORRECT ANSWER: Chronicles

Typology: Exams

2024/2025

Available from 07/13/2025

Academicmaterials
Academicmaterials 🇺🇸

1

(1)

4.4K documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CLR 110 Part 4: Mapping Chronicles
Relationships in Clarity
________________ was designed to easily store and retrieve large amounts of
information about one entity at a time.
CORRECT ANSWER: Chronicles
Due to the structural difference between these databases, some data model
manipulation happens as data moves from _______________
CORRECT 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:
CORRECT ANSWER:
1. Minimize redundant data
2. Maintain consistent granularity
What Chronicles item characteristics allow multiple values to be stored for a single
record?
CORRECT ANSWER: Add type and response type
______________ minimizes data redundancy while maintaining granularity by
mapping a single Chronicles master file to multiple Clarity tables.
CORRECT ANSWER: Clarity
Clarity minimizes data redundancy while maintaining granularity by mapping a
single Chronicles master file to multiple Clarity tables. The key pieces of
pf3
pf4
pf5

Partial preview of the text

Download CLR 110 Part 4: Mapping Chronicles Relationships in Clarity Questions And Correct Answers and more Exams Advanced Education in PDF only on Docsity!

CLR 110 Part 4: Mapping Chronicles

Relationships in Clarity

________________ was designed to easily store and retrieve large amounts of information about one entity at a time.

  • CORRECT ANSWER: Chronicles Due to the structural difference between these databases, some data model manipulation happens as data moves from _______________
  • CORRECT 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:
  • CORRECT ANSWER:
  1. Minimize redundant data
  2. Maintain consistent granularity What Chronicles item characteristics allow multiple values to be stored for a single record?
  • CORRECT ANSWER: Add type and response type ______________ minimizes data redundancy while maintaining granularity by mapping a single Chronicles master file to multiple Clarity tables.
  • CORRECT 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 ____________

  • CORRECT ANSWER: add type; response type; primary key. The two Chronicles item characteristics that are particularly important for Clarity queries are _______ and __________
  • CORRECT ANSWER: Add Type; Response Type. stored on the record. Always considered "current".
  • CORRECT ANSWER: No-Add: stored on the contact.
  • CORRECT ANSWER: Overtime Indicates if data is stored on a record or on a contact in the record.
  • CORRECT ANSWER: Add type Indicates how many lines of data an item can hold
  • CORRECT ANSWER: Response type holds only one line of data
  • CORRECT ANSWER: single holds multiple lines of data
  • CORRECT ANSWER: multiple In chronicles, the internal identifier is stored in the .1 item on the record and is referred to as a __________
  • CORRECT ANSWER: record ID.

____________ in Chronicles define relationships between an item in one master file and a record or contact. Each networked item will store the ID of a Chronicles record or contact.

  • CORRECT ANSWER: Networked items There are several ways to find the INI that a networked item points to
  • CORRECT ANSWER:
  1. Hyperspace CTL + Click: Use Ctrl+ Click in the field to reveal the item information window. Click More to reveal more item information, including Network INI.
  2. Record Viewer: Hover over the item to show Net. Or, hover over the value to show Network to database. You may also open the linked record to find the network INI.
  3. Item editor: Under the Network section, look for the value in Target INI. Both networked items and category items store a value from a ______
  • CORRECT ANSWER: list. Which part of the join does the Chronicles networked item map to?
  • CORRECT ANSWER: The foreign key of the source table. Which column in the destination table is used with the starting table's foreign key column in the join?
  • CORRECT ANSWER: The primary key of the destination table is used with the starting table's foreign key column in the join. What is a common Clarity naming convention for columns that extract from record pointers?
  • CORRECT ANSWER: The column name ends with _ID.