Exam 9: Data Design

-In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

A _____ specifies the fields and identifies the primary key in a particular file.

To bridge the gap between a database and the Internet, it is necessary to use a _____, which is software that integrates different applications and allows them to exchange data.

A _____ is a set of letters or numbers that represents a data item.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A technique used by analysts to define relationships in more detail, after drawing an initial entity-relationship diagram

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

Briefly describe the seven coding methods used by companies with examples.​

Typically, a database management system is managed by a person called _____, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -Defines only those portions of the database that a particular system or user needs or is allowed to access

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

The basic elements of logical storage are alphabetic or numeric characters, such as the letter A or the number 9.

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A coding method used on mainframe computers and high-capacity servers

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A person, place, thing, or event for which data is collected and maintained

A table design that contains a repeating group is called _____.

In a table or file, each column represents a record and each row represents a field.

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.​

Binary digits have only _____ possible value(s).