Exam 9: Data Design

If a primary key combines two or more fields, then it is called a _____.

_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

A _____ controls database operations, including storing, retrieving, updating, and deleting data.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A set of rules that avoids data inconsistency and quality problems

A(n) _____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

A _____, which is not unique, is a field or combination of fields that can be used to access or retrieve records.

Any field that is not a primary key or a candidate key is called a _____.

_____ is strictly hardware-related because it involves the process of reading and writing binary data to physical media, such as a hard drive, CD/DVD, or network-based storage device.

List and discuss at least 5 specific database management system (DBMS) advantages.

Each _____ contains data about people, places, things, or events.

In the event of a file catastrophe, _____ can be used to restore the file or database to its current state at the time of the last backup.

Which of the following are the advantages of a DBMS (database management system)?

Designing tables is easier if a _____ is used to show a table's structure, fields, and primary key.

_____ are numbers or letters assigned in a specific order.

_____, a coding method that uses one byte per character, is used on mainframe computers and high-capacity servers.

The inherent efficiency of high-volume processing on larger computers is called _____.

Anna asks if it is manageable to fetch records using a field or combination of fields that is not unique. Emily tells her that it is possible using one type of key. Identify the type of key used here.

A _____ is designed to serve the needs of a specific department, such as sales, marketing, or finance.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A kind of storage that refers to data that a user can view, regardless of how or where the information actually is organized or stored

_____, a coding method that uses one byte per character, is used on most personal computers.