ACING CLR 110 EXAMS WITH THE LATEST A+ QUESTIONS
AND ANSWERS GUIDE BOOK.
Networked items
Relationships between an item in one master file and a record or contact
Cardinality
Numerical relationship between entities in two tables
Value extracted to clarity for chronicles items that are not filled out
Null
The most common database objects and clarity our
Extracted tables
What do you ER diagrams contain
Common tables and their links for a particular reporting area and relationship cardinality
of frequent joins
How do you know it's a few database object
Typically begins with V_
What are visual indicators in ER diagram for views
Views show up with a brownish background. Extract tables show with a white
background
Add-Type
How long a piece of data is valid. Whether an items value is stored on each contact or
on the record
Name 3 add types
No ad, response each time, look back
No add
Stores data directly on a record not a contact should be considered true for all contacts
on that record like a birthday
Response each time
Store values separately on each of a records contacts. If blank for a contact it should be
unknown. Example blood pressure
Lookback add type
, Store value separately on each contact but assume the last value entered remain true til
a new value is entered. Example patient's age
Name two overtime add types
Response each time and look back
Response type
Determines how many lines of data an item can hold. Multi line address only one date of
birth
3 response types
Single response, multiple response, related group
Single response type
Only one line of data can be stored per contact
Multiple response type
Multiple lines of data can be stored per contact example multiple symptoms multi line
address
Related group response type
Multiple lines of data can be stored per contact and each one of these lines is related to
a line in another item. Example list of relatives names and their phone numbers
Limitations of item
Editor
For category values it will only show the first 100 in a category list.
For category values it will only show the first 100 in a category list.
Null values exist in clarity for what reasons
Not all fields are populated in Chronicles, Etl data cleansing deletes in correctly
formatted data, a column may no longer extract data because it is deprecated
Identifying lines. Clarity extracts this number to a line column which becomes
part of the primary key. This comes from multiple response and related group
items
Define the cardinality of a relationship
It describes the numerical relationship between entities in two tables
Not all fields are populated in Chronicles, ATL data cleansing deletes in correctly
formatted data, a column may no longer extract data because it is deprecated
AND ANSWERS GUIDE BOOK.
Networked items
Relationships between an item in one master file and a record or contact
Cardinality
Numerical relationship between entities in two tables
Value extracted to clarity for chronicles items that are not filled out
Null
The most common database objects and clarity our
Extracted tables
What do you ER diagrams contain
Common tables and their links for a particular reporting area and relationship cardinality
of frequent joins
How do you know it's a few database object
Typically begins with V_
What are visual indicators in ER diagram for views
Views show up with a brownish background. Extract tables show with a white
background
Add-Type
How long a piece of data is valid. Whether an items value is stored on each contact or
on the record
Name 3 add types
No ad, response each time, look back
No add
Stores data directly on a record not a contact should be considered true for all contacts
on that record like a birthday
Response each time
Store values separately on each of a records contacts. If blank for a contact it should be
unknown. Example blood pressure
Lookback add type
, Store value separately on each contact but assume the last value entered remain true til
a new value is entered. Example patient's age
Name two overtime add types
Response each time and look back
Response type
Determines how many lines of data an item can hold. Multi line address only one date of
birth
3 response types
Single response, multiple response, related group
Single response type
Only one line of data can be stored per contact
Multiple response type
Multiple lines of data can be stored per contact example multiple symptoms multi line
address
Related group response type
Multiple lines of data can be stored per contact and each one of these lines is related to
a line in another item. Example list of relatives names and their phone numbers
Limitations of item
Editor
For category values it will only show the first 100 in a category list.
For category values it will only show the first 100 in a category list.
Null values exist in clarity for what reasons
Not all fields are populated in Chronicles, Etl data cleansing deletes in correctly
formatted data, a column may no longer extract data because it is deprecated
Identifying lines. Clarity extracts this number to a line column which becomes
part of the primary key. This comes from multiple response and related group
items
Define the cardinality of a relationship
It describes the numerical relationship between entities in two tables
Not all fields are populated in Chronicles, ATL data cleansing deletes in correctly
formatted data, a column may no longer extract data because it is deprecated
