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
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

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

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Management Systems (DBMS, Exams of Database Management Systems (DBMS)

Carnegie Mellon University (CMU)Database Management Systems (DBMS)

Database Management Systems (DBMS

Typology: Exams

2025/2026

Available from 05/02/2026

Professor_Beatrice
Professor_Beatrice ๐Ÿ‡บ๐Ÿ‡ธ

5

(1)

49K documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CLR110 CLARITY DATA MODEL ACTUAL
TEST PAPER 2026 COMPLETE QUESTIONS
AND CORRECT ANSWERS VERIFIED A+
โ—โ— 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
pf3
pf4
pf5

Partial preview of the text

Download Database Management Systems (DBMS and more Exams Database Management Systems (DBMS) in PDF only on Docsity!

CLR110 CLARITY DATA MODEL ACTUAL

TEST PAPER 2026 COMPLETE QUESTIONS

AND CORRECT ANSWERS VERIFIED A+

โ—โ— 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

  1. 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

โ—โ— Most master files will use a CSN to identify their records' contacts. Thus, most Clarity tables based on overtime items will have a _________ in their primary key. Answer: CSN โ—โ— Here are some fundamental concepts about contacts within a master file: Answer: 1. The meaning of a contact differs between master files.

  1. Some master files contain contacts that change meaning within the master file, depending on the type of record the contact is stored in.
  2. Some master files only ever use one contact per record โ—โ— These general rules for Clarity are not always going to be a substitute for investigating directly in Chronicles. You will often save time and energy to start your research in ________________, rather than going straight to Clarity. Answer: Chronicles โ—โ— ____________ 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. Answer: Networked items โ—โ— There are several ways to find the INI that a networked item points to

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.

  1. 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.
  2. Item editor: Under the Network section, look for the value in Target INI. โ—โ— Both networked items and category items store a value from a

Answer: list. โ—โ— Which part of the join does the Chronicles networked item map to? 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? 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? Answer: The column name ends with _ID.